CiviCRM Community Forums (archive)

I keep getting this database error on my site. Any idea what is causing this? I had it on a previous installation, couldn't fix it, so I reinstalled and I'm getting the same errors. ARGH. 


Database Error Code: Cannot add or update a child row: a foreign key constraint fails (`3riversCiviCRM`.`civicrm_event`, CONSTRAINT `FK_civicrm_event_created_id` FOREIGN KEY (`created_id`) REFERENCES `civicrm_contact` (`id`) ON DELETE SET NULL), 1452

Additional Details:

Array
(
    [callback] => Array
        (
           

• => CRM_Core_Error
[1] => handle
        )
 
   

=> -3
    [message] => DB Error: constraint violation
    [mode] => 16
    [debug_info] => INSERT INTO civicrm_event (title , summary , description , event_type_id , participant_listing_id , is_public , start_date , end_date , max_participants , event_full_text , is_map , is_active , default_role_id , has_waitlist , is_template , created_id , created_date ) VALUES ('13th Annual 3 Rivers Wet Weather Sewer Conference' ,  NULL ,  NULL ,  1 ,  NULL ,  0 ,  20111004000000 ,  20111005000000 ,  NULL , 'This event is currently full.' ,  0 ,  1 ,  1 ,  0 ,  0 ,  102 ,  20110726130000 )  [nativecode=1452 ** Cannot add or update a child row: a foreign key constraint fails (`3riversCiviCRM`.`civicrm_event`, CONSTRAINT `FK_civicrm_event_created_id` FOREIGN KEY (`created_id`) REFERENCES `civicrm_contact` (`id`) ON DELETE SET NULL)]
    [type] => DB_Error
    [user_info] => INSERT INTO civicrm_event (title , summary , description , event_type_id , participant_listing_id , is_public , start_date , end_date , max_participants , event_full_text , is_map , is_active , default_role_id , has_waitlist , is_template , created_id , created_date ) VALUES ('13th Annual 3 Rivers Wet Weather Sewer Conference' ,  NULL ,  NULL ,  1 ,  NULL ,  0 ,  20111004000000 ,  20111005000000 ,  NULL , 'This event is currently full.' ,  0 ,  1 ,  1 ,  0 ,  0 ,  102 ,  20110726130000 )  [nativecode=1452 ** Cannot add or update a child row: a foreign key constraint fails (`3riversCiviCRM`.`civicrm_event`, CONSTRAINT `FK_civicrm_event_created_id` FOREIGN KEY (`created_id`) REFERENCES `civicrm_contact` (`id`) ON DELETE SET NULL)]
    [to_string] => [db_error: message="DB Error: constraint violation" code=-3 mode=callback callback=CRM_Core_Error::handle prefix="" info="INSERT INTO civicrm_event (title , summary , description , event_type_id , participant_listing_id , is_public , start_date , end_date , max_participants , event_full_text , is_map , is_active , default_role_id , has_waitlist , is_template , created_id , created_date ) VALUES ('13th Annual 3 Rivers Wet Weather Sewer Conference' ,  NULL ,  NULL ,  1 ,  NULL ,  0 ,  20111004000000 ,  20111005000000 ,  NULL , 'This event is currently full.' ,  0 ,  1 ,  1 ,  0 ,  0 ,  102 ,  20110726130000 )  [nativecode=1452 ** Cannot add or update a child row: a foreign key constraint fails (`3riversCiviCRM`.`civicrm_event`, CONSTRAINT `FK_civicrm_event_created_id` FOREIGN KEY (`created_id`) REFERENCES `civicrm_contact` (`id`) ON DELETE SET NULL)]"]
)

It's referencing a non-existing contact_id as creator. Log out and log back in - should fix it since that will re-create the civicrm contact record for your logged in user. Generally this happens to me if I reload sample DB / reinstall civi while logged in and don't log out / log back in.

Yesssss that fixed it. Thanks!!

Folks are working on catching and fixing those notices over time. They are not errors, only notices so generally will not affect functionality. The reason they are popping up is because D7 default PHP error reporting level is higher than D6 - so these went un-noticed in prior releases (and for folks using 3.4.x on D6).

I've recreated that one and a few others along the way and posted an issue here:
http://issues.civicrm.org/jira/browse/CRM-8564

If you find a few others you can add them as comments in the next few days. If you are a coder, the fix for most of these is to use the CRM_Utils_Array::value() function when testing for value of an item in an array where the item may or may not exist.