CiviCRM Community Forums (archive)

Hi everyone,

I added a few custom fields to some of my civicrm profiles and whenever I try to use these forms to submit information, I get this error:


Database Error Code: Cannot add or update a child row: a foreign key constraint fails (`civicrmpowarts/civicrm_value_professional_experience__resume_1`, CONSTRAINT `FK_civicrm_value_professional_exper_d2453118f9ed0d92` FOREIGN KEY (`entity_id`) REFERENCES `civicrm_contribution` ), 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_professional_experience__resume_1  ( professional_background_6,what_kind_of_programming_and_eve_2,entity_id ) VALUES ( 'Test background','Stuff',1268 ) ON DUPLICATE KEY UPDATE professional_background_6 = 'Test background',what_kind_of_programming_and_eve_2 = 'Stuff' [nativecode=1452 ** Cannot add or update a child row: a foreign key constraint fails (`civicrmpowarts/civicrm_value_professional_experience__resume_1`, CONSTRAINT `FK_civicrm_value_professional_exper_d2453118f9ed0d92` FOREIGN KEY (`entity_id`) REFERENCES `civicrm_contribution` )]
    [type] => DB_Error
    [user_info] => INSERT INTO civicrm_value_professional_experience__resume_1  ( professional_background_6,what_kind_of_programming_and_eve_2,entity_id ) VALUES ( 'Test background','Stuff',1268 ) ON DUPLICATE KEY UPDATE professional_background_6 = 'Test background',what_kind_of_programming_and_eve_2 = 'Stuff' [nativecode=1452 ** Cannot add or update a child row: a foreign key constraint fails (`civicrmpowarts/civicrm_value_professional_experience__resume_1`, CONSTRAINT `FK_civicrm_value_professional_exper_d2453118f9ed0d92` FOREIGN KEY (`entity_id`) REFERENCES `civicrm_contribution` )]
    [to_string] => [db_error: message="DB Error: constraint violation" code=-3 mode=callback callback=CRM_Core_Error::handle prefix="" info="INSERT INTO civicrm_value_professional_experience__resume_1  ( professional_background_6,what_kind_of_programming_and_eve_2,entity_id ) VALUES ( 'Test background','Stuff',1268 ) ON DUPLICATE KEY UPDATE professional_background_6 = 'Test background',what_kind_of_programming_and_eve_2 = 'Stuff' [nativecode=1452 ** Cannot add or update a child row: a foreign key constraint fails (`civicrmpowarts/civicrm_value_professional_experience__resume_1`, CONSTRAINT `FK_civicrm_value_professional_exper_d2453118f9ed0d92` FOREIGN KEY (`entity_id`) REFERENCES `civicrm_contribution` )]"]
)


Any idea what could be causing this and how to fix it?

Thank you!![/code]

I'm having the same problem, how does this happen from a fresh install, and what is the solution?