CiviCRM Community Forums (archive)

I am consistently getting constraint violation errors when I sync users, or add users.

I am running Drupal 5.5, civicrm 1.9

I loaded civicrm_41.mysql and civicrm_data.mysql.  I also tried civicrm_generated.mysql and also got similar errors when adding users.

I found constraint errors in another forum topic, but it shows a different table that causes the constraint error.

thanks for any help. 

Thanks,  Abe


==================
sync user error
==================
Array
(
    [callback] => Array
        (
           

• => CRM_Core_Error
[1] => handle
        )

   

=> -3
    [message] => DB Error: constraint violation
    [mode] => 16
    [debug_info] => INSERT INTO civicrm_log (entity_table , entity_id , data , modified_id , modified_date ) VALUES ('civicrm_contact' ,  1 , 'civicrm_contact,1' ,  104 ,  20080110010720 )  [nativecode=1216 ** Cannot add or update a child row: a foreign key constraint fails]
    [type] => DB_Error
    [user_info] => INSERT INTO civicrm_log (entity_table , entity_id , data , modified_id , modified_date ) VALUES ('civicrm_contact' ,  1 , 'civicrm_contact,1' ,  104 ,  20080110010720 )  [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_log (entity_table , entity_id , data , modified_id , modified_date ) VALUES ('civicrm_contact' ,  1 , 'civicrm_contact,1' ,  104 ,  20080110010720 )  [nativecode=1216 ** Cannot add or update a child row: a foreign key constraint fails]"]
)

==============
add user error
==============
     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 home page.

Error Details:

Array
(
    [callback] => Array
        (
            [0] => CRM_Core_Error
            [1] => handle
        )

    [code] => -3
    [message] => DB Error: constraint violation
    [mode] => 16
    [debug_info] => INSERT INTO civicrm_log (entity_table , entity_id , data , modified_id , modified_date ) VALUES ('civicrm_contact' ,  3 , 'civicrm_contact,3' ,  104 ,  20080110011319 )  [nativecode=1216 ** Cannot add or update a child row: a foreign key constraint fails]
    [type] => DB_Error
    [user_info] => INSERT INTO civicrm_log (entity_table , entity_id , data , modified_id , modified_date ) VALUES ('civicrm_contact' ,  3 , 'civicrm_contact,3' ,  104 ,  20080110011319 )  [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_log (entity_table , entity_id , data , modified_id , modified_date ) VALUES ('civicrm_contact' ,  3 , 'civicrm_contact,3' ,  104 ,  20080110011319 )  [nativecode=1216 ** Cannot add or update a child row: a foreign key constraint fails]"]
)
[/code]

Make sure you log out of Drupal and also try truncating the Drupal sessions table. It looks like you've got an invalid contact ID associated with the logged in user - which often happens when you do DB operations while logged in.