Author Topic: DB error: Cannot add or update a child row: a foreign key constraint fails (Read 1523 times)

shakergeek · June 05, 2013, 09:13:24 am

hello,

Getting an error when we try to add a new meeting from the contact search results page, anyone have an idea what going on here:

Code: [Select]

 [debug_info] =&gt; INSERT INTO civicrm_activity_target ( activity_id, target_contact_id ) VALUES ( 2049, 5079 ); [nativecode=1452 ** Cannot add or update a child row: a foreign key constraint fails (`onehealth_civi`.`civicrm_activity_target`, CONSTRAINT `FK_civicrm_activity_target_activity_id` FOREIGN KEY (`activity_id`) REFERENCES `___temp_dreamhost_restore_20130525_081805`.`civicrm_acti)]
    [type] =&gt; DB_Error
    [user_info] =&gt; INSERT INTO civicrm_activity_target ( activity_id, target_contact_id ) VALUES ( 2049, 5079 ); [nativecode=1452 ** Cannot add or update a child row: a foreign key constraint fails (`onehealth_civi`.`civicrm_activity_target`, CONSTRAINT `FK_civicrm_activity_target_activity_id` FOREIGN KEY (`activity_id`) REFERENCES `___temp_dreamhost_restore_20130525_081805`.`civicrm_acti)]
    [to_string] =&gt; [db_error: message="DB Error: constraint violation" code=-3 mode=callback callback=CRM_Core_Error::handle prefix="" info="INSERT INTO civicrm_activity_target ( activity_id, target_contact_id ) VALUES ( 2049, 5079 ); [nativecode=1452 ** Cannot add or update a child row: a foreign key constraint fails (`onehealth_civi`.`civicrm_activity_target`, CONSTRAINT `FK_civicrm_activity_target_activity_id` FOREIGN KEY (`activity_id`) REFERENCES `___temp_dreamhost_restore_20130525_081805`.`civicrm_acti)]"]

thanks

JonGold · June 05, 2013, 09:22:50 am

Hi there,

The last line says:
CONSTRAINT `FK_civicrm_activity_target_activity_id` FOREIGN KEY (`activity_id`) REFERENCES `___temp_dreamhost_restore_20130525_081805`.`civicrm_acti)]"

The part that concerns me is this:
___temp_dreamhost_restore_20130525_081805

If I had to gues, I'd say that your web host is Dreamhost, and at some point you had to restore your CiviCRM database from a backup, but it was improperly restored.

I'm not sure I can recommend the best course of action for fixing this, since there are probably bad foreign keys everywhere. You may have to go in and edit them manually - but that's not a trivial task.

CiviCRM Community Forums (archive)

News:

Author Topic: DB error: Cannot add or update a child row: a foreign key constraint fails (Read 1523 times)

shakergeek

DB error: Cannot add or update a child row: a foreign key constraint fails

JonGold

Re: DB error: Cannot add or update a child row: a foreign key constraint fails