CiviCRM Community Forums (archive)

I am getting a DB Error: constraint violation when I try and edit a contact record:

Database Error Code: Cannot add or update a child row: a foreign key constraint fails (`ecotouri_civicrm/civicrm_value_additional_membership_questions_9`, CONSTRAINT `FK_civicrm_value_additional_members_f8f4848ee168bf38` FOREIGN KEY (`entity_id`) REFERENCES `civicrm_membership` ), 1452
Additional Details:

Array
(
    [callback] => Array
        (
            [0] => CRM_Core_Error
            [1] => handle
        )

    [code] => -3
    [message] => DB Error: constraint violation
    [mode] => 16
    [debug_info] => INSERT INTO civicrm_value_additional_membership_questions_9  ( do_you_want_your_member_profile__24,i_agree_to_ties_code_of_conduct_23,entity_id ) VALUES ( 1,1,118 ) ON DUPLICATE KEY UPDATE do_you_want_your_member_profile__24 = 1,i_agree_to_ties_code_of_conduct_23 = 1 [nativecode=1452 ** Cannot add or update a child row: a foreign key constraint fails (`ecotouri_civicrm/civicrm_value_additional_membership_questions_9`, CONSTRAINT `FK_civicrm_value_additional_members_f8f4848ee168bf38` FOREIGN KEY (`entity_id`) REFERENCES `civicrm_membership` )]
    [type] => DB_Error
    [user_info] => INSERT INTO civicrm_value_additional_membership_questions_9  ( do_you_want_your_member_profile__24,i_agree_to_ties_code_of_conduct_23,entity_id ) VALUES ( 1,1,118 ) ON DUPLICATE KEY UPDATE do_you_want_your_member_profile__24 = 1,i_agree_to_ties_code_of_conduct_23 = 1 [nativecode=1452 ** Cannot add or update a child row: a foreign key constraint fails (`ecotouri_civicrm/civicrm_value_additional_membership_questions_9`, CONSTRAINT `FK_civicrm_value_additional_members_f8f4848ee168bf38` FOREIGN KEY (`entity_id`) REFERENCES `civicrm_membership` )]
    [to_string] => [db_error: message="DB Error: constraint violation" code=-3 mode=callback callback=CRM_Core_Error::handle prefix="" info="INSERT INTO civicrm_value_additional_membership_questions_9  ( do_you_want_your_member_profile__24,i_agree_to_ties_code_of_conduct_23,entity_id ) VALUES ( 1,1,118 ) ON DUPLICATE KEY UPDATE do_you_want_your_member_profile__24 = 1,i_agree_to_ties_code_of_conduct_23 = 1 [nativecode=1452 ** Cannot add or update a child row: a foreign key constraint fails (`ecotouri_civicrm/civicrm_value_additional_membership_questions_9`, CONSTRAINT `FK_civicrm_value_additional_members_f8f4848ee168bf38` FOREIGN KEY (`entity_id`) REFERENCES `civicrm_membership` )]"]
)

I have emptied the caches, logged out, logged back in, and still no luck.

Any suggestions?

no, I haven't deleted anything.

I was looking at the SQL table for these fields, and it asks for a entity_id, which I assume is the contact id.  In phpMyAdmin, it only allows a drop down box that goes from -27 to +27.

So, I guess that field is not set up correctly, cause nearly all of the contact IDs are bigger than 27.

the value being passed for entity id from the form is the contact  id.

I went ahead and re-created these custom fields, and it seems to be working, now.  Something must have messed up when we originally created it.

Ok, now I can't delete the old custom field sets....  I don't get an error or anything, but when I try and delete, nothing happens.

Yes, it was editing contact 118.

It is strange, cause I created a few test custom fields sets, and none of them can be deleted.