Author Topic: constraint violation (civicrm_acl_cache, FK_civicrm_acl_cache_contact_id) (Read 1632 times)

scurra71 · August 04, 2010, 01:06:44 am

Hi

I have just run the "sites/all/modules/civicrm/bin/UpdateMembershipRecord.php" for the first time. Now, when I view Drupal user details (/users/<username>), I get the following error:

Code: [Select]

Sorry. A non-recoverable error has occurred.

DB Error: constraint violation


Database Error Code: Cannot add or update a child row: a foreign key constraint fails (`drupalsaoga/civicrm_acl_cache`, CONSTRAINT `FK_civicrm_acl_cache_contact_id` FOREIGN KEY (`contact_id`) REFERENCES `civicrm_contact` (`id`) ON DELETE CASCADE), 1452


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

    [code] => -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 (`drupalsaoga/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 (`drupalsaoga/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 (`drupalsaoga/civicrm_acl_cache`, CONSTRAINT `FK_civicrm_acl_cache_contact_id` FOREIGN KEY (`contact_id`) REFERENCES `civicrm_contact` (`id`) ON DELETE CASCADE)]"]
)

I am using the following versions:

PHP 5.2.4-2ubuntu5.10 with Suhosin-Patch 0.9.6.2
Drupal 6.16
CiviCRM 3.1.4

What's the best way to resolve this?

[/code]

scurra71 · August 04, 2010, 01:18:09 am

Some database info:

Code: [Select]

mysql> select count(*) from civicrm_acl_cache;
+----------+
| count(*) |
+----------+
|       32 | 
+----------+
1 row in set (0.00 sec)

mysql> select count(*) from civicrm_contact;
+----------+
| count(*) |
+----------+
|     1945 | 
+----------+
1 row in set (0.00 sec)

mysql> select count(*) from civicrm_acl;
+----------+
| count(*) |
+----------+
|       61 | 
+----------+
1 row in set (0.00 sec)

Kurund Jalmi · August 04, 2010, 01:28:40 am

Can empty following tables and check if that helps:
civicrm_acl_cache
civicrm_acl_contact_cache
civicrm_cache

Hth
Kurund

scurra71 · August 04, 2010, 01:37:05 am

Thanks! That worked. Much obliged.

I should have Googled before I posted. I see now this has come up before.

(http://forum.civicrm.org/index.php?topic=14560.0)

Thanks again!

ehowland · December 02, 2010, 03:39:35 pm

I got this from a multisite drupal install (separate everything) in which I was temporarily pointing to a different sites CiviCRM database. What worked for me was truncating the drupal sessions table as suggested in this thread:

http://forum.civicrm.org/index.php?topic=15788.0

CiviCRM Community Forums (archive)

News:

Author Topic: constraint violation (civicrm_acl_cache, FK_civicrm_acl_cache_contact_id) (Read 1632 times)

scurra71

constraint violation (civicrm_acl_cache, FK_civicrm_acl_cache_contact_id)

scurra71

Re: constraint violation (civicrm_acl_cache, FK_civicrm_acl_cache_contact_id)

Kurund Jalmi

Re: constraint violation (civicrm_acl_cache, FK_civicrm_acl_cache_contact_id)

scurra71

Re: constraint violation (civicrm_acl_cache, FK_civicrm_acl_cache_contact_id)

ehowland

Re: constraint violation (civicrm_acl_cache, FK_civicrm_acl_cache_contact_id)