CiviCRM Community Forums (archive)

Hi All,
I received the following error while trying to run an advanced search after upgrading CiviCRM 2.03 to 2.1.1
The search criteria was a certain group and a range of Zip codes within that group.
Any ideas?
Using Drupal 6.6 and CiviCRM 2.1.1
Thanks
Ryan


Advanced Search
 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 (`civicrmtest/civicrm_group_contact_cache`, CONSTRAINT `FK_civicrm_group_contact_cache_contact_id` FOREIGN KEY (`contact_id`) REFERENCES `civicrm_contact` (`id`) ON DELETE CASCADE), 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] => REPLACE INTO civicrm_group_contact_cache (group_id,contact_id) VALUES (12,15434),(12,16070),(12,10643),(12,15941),(12,15942); [nativecode=1452 ** Cannot add or update a child row: a foreign key constraint fails (`civicrmtest/civicrm_group_contact_cache`, CONSTRAINT `FK_civicrm_group_contact_cache_contact_id` FOREIGN KEY (`contact_id`) REFERENCES `civicrm_contact` (`id`) ON DELETE CASCADE)]
    [type] => DB_Error
    [user_info] => REPLACE INTO civicrm_group_contact_cache (group_id,contact_id) VALUES (12,15434),(12,16070),(12,10643),(12,15941),(12,15942); [nativecode=1452 ** Cannot add or update a child row: a foreign key constraint fails (`civicrmtest/civicrm_group_contact_cache`, CONSTRAINT `FK_civicrm_group_contact_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="REPLACE INTO civicrm_group_contact_cache (group_id,contact_id) VALUES (12,15434),(12,16070),(12,10643),(12,15941),(12,15942); [nativecode=1452 ** Cannot add or update a child row: a foreign key constraint fails (`civicrmtest/civicrm_group_contact_cache`, CONSTRAINT `FK_civicrm_group_contact_cache_contact_id` FOREIGN KEY (`contact_id`) REFERENCES `civicrm_contact` (`id`) ON DELETE CASCADE)]"]
)



I just had a similar problem. I did run both queries as indicated in the previous post, but it didn't help.

I had to go in through MySQL Admin/Browser and delete the smart group I recently created. Additionally I also saw that another group must have been created automatically (does CiviCRM create two group entries / smart group?), so I deleted it as well.

Everything seems to be working fine now.

What might be going on? Smart groups are a nice feature, but if they such trouble, I'm afraid to use them.

Oops ... we actually have recently upgraded to 3.0.3 recently. I just forgot to update my forum profile.

Would you recommend to upgrade to 3.1?

Wanted to report that clearing civicrm cache table solved this problem for me. (using civicrm 3.1.2 Drual 6 mysql 5 and php 5.2.0 as of this writing)