CiviCRM Community Forums (archive)

Hi,
Having searched the old Nabble posts and this forum, we are still hunting for a solution to yet another foreign key error message.

We have been upgrading a drupal 5.1 site from civiCRM 1.6 to 1.7.9327

We reached step 8 in the upgrade instructions and then received the following error message after logging in as root user and visiting  civiCRM:

   
Code:

  Sorry. A non-recoverable error has occurred.

    Database Error Code: Cannot add or update a child row: a foreign key constraint fails, 1216

    Return to CiviCRM menu.

Error Details:

Array
(
    [callback] => Array
        (
           

• => CRM_Core_Error
[1] => handle
        )

   

=> -3
    [message] => DB Error: constraint violation
    [mode] => 16
    [debug_info] => INSERT INTO civicrm_contact (domain_id , contact_type , sort_name , display_name , hash ) VALUES ( 1 , 'Individual' , 'webmaster@blah.asn.au' , 'webmaster@blah.asn.au' , 'e0688d9adbee548bf2232b9ce0da0653' )  [nativecode=1216 ** Cannot add or update a child row: a foreign key constraint fails]
    [type] => DB_Error
    [user_info] => INSERT INTO civicrm_contact (domain_id , contact_type , sort_name , display_name , hash ) VALUES ( 1 , 'Individual' , 'webmaster@blah.asn.au' , 'webmaster@blah.asn.au' , 'e0688d9adbee548bf2232b9ce0da0653' )  [nativecode=1216 ** Cannot add or update a child row: a foreign key constraint fails]
    [to_string] => [db_error: message="DB Error: constraint violation" code=-3 mode=callback callback=CRM_Core_Error::handle prefix="" info="INSERT INTO civicrm_contact (domain_id , contact_type , sort_name , display_name , hash ) VALUES ( 1 , 'Individual' , 'webmaster@blah.asn.au' , 'webmaster@blah.asn.au' , 'e0688d9adbee548bf2232b9ce0da0653' )  [nativecode=1216 ** Cannot add or update a child row: a foreign key constraint fails]"]
)


We have emptied the sessions table and tried to cleanup template cache, but can't even get to the point of turning debugging on.

Hope you can help,