CiviCRM Community Forums (archive)

    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
        (
           

• => CRM_Core_Error
[1] => handle
        )

   

Code: [Select]

=> -3
    [message] => DB Error: constraint violation
    [mode] => 16
    [debug_info] => INSERT INTO civicrm_location (entity_table , entity_id , location_type_id , is_primary ) VALUES ('civicrm_contact' ,  1 ,  8 ,  0 )  [nativecode=1216 ** Cannot add or update a child row: a foreign key constraint fails]
    [type] => db_error
    [user_info] => INSERT INTO civicrm_location (entity_table , entity_id , location_type_id , is_primary ) VALUES ('civicrm_contact' ,  1 ,  8 ,  0 )  [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_location (entity_table , entity_id , location_type_id , is_primary ) VALUES ('civicrm_contact' ,  1 ,  8 ,  0 )  [nativecode=1216 ** Cannot add or update a child row: a foreign key constraint fails]"]
)
[/quote]

If I have not filled in the required information I get taken to the backend of the site the form is from and get a list of missing information.


Cancel works just fine.