CiviCRM Community Forums (archive)

DB Error: constraint violation

Database Error Code: Cannot add or update a child row: a foreign key constraint fails (`284332`.`civicrm_uf_match`, CONSTRAINT `FK_civicrm_uf_match_domain_id` FOREIGN KEY (`domain_id`) REFERENCES `civicrm_domain` (`id`)), 1452

Return to home page.
Error Details:


Array
(
    [callback] => Array
        (
           

• => CRM_Core_Error
[1] => handle
        )

   

=> -3
    [message] => DB Error: constraint violation
    [mode] => 16
    [debug_info] => INSERT INTO civicrm_uf_match (domain_id , uf_id , uf_name , contact_id ) VALUES ( 1 ,  62 , 'email@example.com' ,  3 )  [nativecode=1452 ** Cannot add or update a child row: a foreign key constraint fails (`284332`.`civicrm_uf_match`, CONSTRAINT `FK_civicrm_uf_match_domain_id` FOREIGN KEY (`domain_id`) REFERENCES `civicrm_domain` (`id`))]
    [type] => DB_Error
    [user_info] => INSERT INTO civicrm_uf_match (domain_id , uf_id , uf_name , contact_id ) VALUES ( 1 ,  62 , 'email@example.com' ,  3 )  [nativecode=1452 ** Cannot add or update a child row: a foreign key constraint fails (`284332`.`civicrm_uf_match`, CONSTRAINT `FK_civicrm_uf_match_domain_id` FOREIGN KEY (`domain_id`) REFERENCES `civicrm_domain` (`id`))]
    [to_string] => [db_error: message="DB Error: constraint violation" code=-3 mode=callback callback=CRM_Core_Error::handle prefix="" info="INSERT INTO civicrm_uf_match (domain_id , uf_id , uf_name , contact_id ) VALUES ( 1 ,  62 , 'email@example.com' ,  3 )  [nativecode=1452 ** Cannot add or update a child row: a foreign key constraint fails (`284332`.`civicrm_uf_match`, CONSTRAINT `FK_civicrm_uf_match_domain_id` FOREIGN KEY (`domain_id`) REFERENCES `civicrm_domain` (`id`))]"]
)

I get exactly the same error after setting up a multi-site installation. Works fine on my main host site but the secondary site doesn't function at all, just this fatal error.

Did you find out why it was happening for you? Have cleared cache's, logged in, logged out, manually tried to add the line of values given in the error (which gives the same error in my mysql tool).

Stuck