CiviCRM Community Forums (archive)

In case someone else sees this error.

Error: Still don't know the cause but we were finding that we could not add new contact.  The error message debug info is below.   The error indicated that we were adding someone to a group that did not exist, which was true.  We have not enabled any of the Drupal integration modules (other forum posts indicate this caused similar issues for tother people). 

Solution:The only way to fix it was to create a new group, change it's id (in this case to 17) in the civicrm_group table.  We then disabled the group as it was useless.  All is well now

I looked all over the place in the db and couldn't find any place this group was referenced, celar the civicrm_cache table, etc...  All to no avail.




[debug_info] => INSERT INTO civicrm_subscription_history (contact_id , group_id , date , method , status ) VALUES ( 22753 ,  17 ,  20101025102116 , 'Admin' , 'Added' )  [nativecode=1452 ** Cannot add or update a child row: a foreign key constraint fails (`uhcanohi_civicrm/civicrm_subscription_history`, CONSTRAINT `FK_civicrm_subscription_history_group_id` FOREIGN KEY (`group_id`) REFERENCES `civicrm_group` (`id`) ON DELETE CASCADE)]
    [type] => DB_Error
    [user_info] => INSERT INTO civicrm_subscription_history (contact_id , group_id , date , method , status ) VALUES ( 22753 ,  17 ,  20101025102116 , 'Admin' , 'Added' )  [nativecode=1452 ** Cannot add or update a child row: a foreign key constraint fails (`uhcanohi_civicrm/civicrm_subscription_history`, CONSTRAINT `FK_civicrm_subscription_history_group_id` FOREIGN KEY (`group_id`) REFERENCES `civicrm_group` (`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_subscription_history (contact_id , group_id , date , method , status ) VALUES ( 22753 ,  17 ,  20101025102116 , 'Admin' , 'Added' )  [nativecode=1452 ** Cannot add or update a child row: a foreign key constraint fails (`uhcanohi_civicrm/civicrm_subscription_history`, CONSTRAINT `FK_civicrm_subscription_history_group_id` FOREIGN KEY (`group_id`) REFERENCES `civicrm_group` (`id`) ON DELETE CASCADE)]"]
)