CiviCRM Community Forums (archive)

Hi,

I've juste finished a new intall of a CiviCRM 3.2.3 and, when I want to modify the domain infos, I've tgh following error message displayed :

DB Error: constraint violation
Error Details
Base de donnée de code d'erreur: Cannot add or update a child row: a foreign key constraint fails (`civicrm-vs/civicrm_acl_cache`, CONSTRAINT `FK_civicrm_acl_cache_contact_id` FOREIGN KEY (`contact_id`) REFERENCES `civicrm_contact` (`id`) ON DELETE CASCADE), 1452
Additional Details:

Array
(
    [callback] => Array
        (
           

• => CRM_Core_Error
[1] => handle
        )

   

=> -3
    [message] => DB Error: constraint violation
    [mode] => 16
    [debug_info] => INSERT INTO civicrm_acl_cache (contact_id , acl_id ) VALUES ( 102 ,  2 )  [nativecode=1452 ** Cannot add or update a child row: a foreign key constraint fails (`civicrm-vs/civicrm_acl_cache`, CONSTRAINT `FK_civicrm_acl_cache_contact_id` FOREIGN KEY (`contact_id`) REFERENCES `civicrm_contact` (`id`) ON DELETE CASCADE)]
    [type] => DB_Error
    [user_info] => INSERT INTO civicrm_acl_cache (contact_id , acl_id ) VALUES ( 102 ,  2 )  [nativecode=1452 ** Cannot add or update a child row: a foreign key constraint fails (`civicrm-vs/civicrm_acl_cache`, CONSTRAINT `FK_civicrm_acl_cache_contact_id` FOREIGN KEY (`contact_id`) REFERENCES `civicrm_contact` (`id`) ON DELETE CASCADE)]
    [to_string] => [db_error: message="DB Error: constraint violation" code=-3 mode=callback callback=CRM_Core_Error::handle prefix="" info="INSERT INTO civicrm_acl_cache (contact_id , acl_id ) VALUES ( 102 ,  2 )  [nativecode=1452 ** Cannot add or update a child row: a foreign key constraint fails (`civicrm-vs/civicrm_acl_cache`, CONSTRAINT `FK_civicrm_acl_cache_contact_id` FOREIGN KEY (`contact_id`) REFERENCES `civicrm_contact` (`id`) ON DELETE CASCADE)]"]
)


Many thanks for the help !



Thanks it works like a charm now !