[SOLVED]Custom field data not saving

[beerguts]

Hello All,

I've created a custom profile field through the admin center for VATSIM ID's.

I've gone into the member's profile to add their VATSIM ID and get the "saved successfully" message. But when I go out of that screen then back in the data is missing.

Any help appreciated.

[Nabeel]

Follow the instructions in my sig to enable debug logs, and then once that's done, try saving a custom field, then lemme know, we'll check the logs for any errors

[beerguts]

Thanks Nabeel.

This is what I am getting....

Backtrace: DB::write_debug > DB::query > PilotData::SaveFields > PilotAdmin->viewpilots > call_user_func_array > MainController::RunAllActions

Query: INSERT INTO phpvms_fieldvalues (fieldid, pilotid, value) VALUES (2, 1, '1234567')

Error: (1452) - Cannot add or update a child row: a foreign key constraint fails (`mysite/phpvms_fieldvalues`, CONSTRAINT `phpvms_fieldvalues_ibfk_2` FOREIGN KEY (`pilotid`) REFERENCES `phpvms_zzzz` (`pilotid`) ON DELETE CASCADE)

=====

The thing is phpvms_zzzz doesn't exist. I believe it was a table used early on to replicate the pilots table but since has been deleted.

[Nabeel]

Try this - in the phpvms fieldvalues table, using phpMyAdmin, find this FOREIGN KEY:

phpvms_fieldvalues_ibfk_2

Delete that... Probably when the pilots table was duplicated, there was a second key added which didn't get removed. The error is coming from that field values action though, so that's a good thing

[beerguts]

Perfect! Thanks Nabeel