CiviCRM Community Forums (archive)

I try to create an event and I get the error as listed below. I've also run into foreign key restraint errors in trying to migrate databases (which I've managed to bypass via turning it off an on again in the db itself, per a workaround suggested here) - this is very disturbing. I've gone through a lot to find a host that supports MySQL 5 (and had to find out myself about InnoDB), but things feel really unstable. I have to say I'm not feeling very confident with this software right now - any help would be greatly appreciated! Thanks in advance...

---error message---

Sorry. A non-recoverable error has occurred.

    Database Error Code: Cannot add or update a child row: a foreign key constraint fails (`borodkin_civicrm/civicrm_log`, CONSTRAINT `FK_civicrm_log_modified_id` FOREIGN KEY (`modified_id`) REFERENCES `civicrm_contact` (`id`) ON DELETE CASCADE), 1452

    Return to home page.

Error Details:

Array
(
    [callback] => Array
        (
           

• => CRM_Core_Error
[1] => handle
        )

   

=> -1
    [message] => DB Error: unknown error
    [mode] => 16
    [debug_info] => INSERT INTO civicrm_log (entity_table , entity_id , modified_id , modified_date ) VALUES ('civicrm_event' ,  1 ,  102 ,  20080421 )  [nativecode=1452 ** Cannot add or update a child row: a foreign key constraint fails (`borodkin_civicrm/civicrm_log`, CONSTRAINT `FK_civicrm_log_modified_id` FOREIGN KEY (`modified_id`) REFERENCES `civicrm_contact` (`id`) ON DELETE CASCADE)]
    [type] => DB_Error
    [user_info] => INSERT INTO civicrm_log (entity_table , entity_id , modified_id , modified_date ) VALUES ('civicrm_event' ,  1 ,  102 ,  20080421 )  [nativecode=1452 ** Cannot add or update a child row: a foreign key constraint fails (`borodkin_civicrm/civicrm_log`, CONSTRAINT `FK_civicrm_log_modified_id` FOREIGN KEY (`modified_id`) REFERENCES `civicrm_contact` (`id`) ON DELETE CASCADE)]
    [to_string] => [db_error: message="DB Error: unknown error" code=-1 mode=callback callback=CRM_Core_Error::handle prefix="" info="INSERT INTO civicrm_log (entity_table , entity_id , modified_id , modified_date ) VALUES ('civicrm_event' ,  1 ,  102 ,  20080421 )  [nativecode=1452 ** Cannot add or update a child row: a foreign key constraint fails (`borodkin_civicrm/civicrm_log`, CONSTRAINT `FK_civicrm_log_modified_id` FOREIGN KEY (`modified_id`) REFERENCES `civicrm_contact` (`id`) ON DELETE CASCADE)]"]
)