CiviCRM Community Forums (archive)

I created a CiviCRM profile called "Website User Profile", enabled "User Registration, View/Edit User Account", and created 12 new Drupal user accounts, filling out the CiviCRM Profile fields for each user during the drupal account creation.

Then, after playing around editing many things in the CiviCRM profile settings, I begin to see the following error when logging in with any of the 12 users:

DB Error: constraint violation

Database Error Code: Cannot add or update a child row: a foreign key constraint fails (`[databasename]_civicrm/civicrm_subscription_history`, CONSTRAINT `FK_civicrm_subscription_history_group_id` FOREIGN KEY (`group_id`) REFERENCES `civicrm_group` (`id`) ON DELETE CASCADE), 1452
This error also occurs when updating or editing a user profile.

It does NOT occur when I create a new account. It seems like the when profile was changed it messed up recorded data for the 12 users that I created before changing the profile.

Please let me know if you have any suggestions. Thanks!

CiviCRM 2.2.7 fresh install on Drupal 6.13 with the views shared tables array in settings.php

Here is the rest of the error:

Error Details:

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

    [code] => -3
    [message] => DB Error: constraint violation
    [mode] => 16
    [debug_info] => INSERT INTO civicrm_subscription_history (contact_id , group_id , date , method , status ) VALUES ( 15 ,  1 ,  20090804114026 , 'API' , 'Added' )  [nativecode=1452 ** Cannot add or update a child row: a foreign key constraint fails (`[databasename]_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 ( 15 ,  1 ,  20090804114026 , 'API' , 'Added' )  [nativecode=1452 ** Cannot add or update a child row: a foreign key constraint fails (`[databasename]_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 ( 15 ,  1 ,  20090804114026 , 'API' , 'Added' )  [nativecode=1452 ** Cannot add or update a child row: a foreign key constraint fails (`[databasename]_civicrm/civicrm_subscription_history`, CONSTRAINT `FK_civicrm_subscription_history_group_id` FOREIGN KEY (`group_id`) REFERENCES `civicrm_group` (`id`) ON DELETE CASCADE)]"]
)


I can fix the issue by deleting and re-creating all the records, but there must be another way . . . [/code]

Sounds like this "misbehavior" might be caused by a combination of group(s) being deleted AND a CiviCRM-related module (e.g. CivCRM Group Roles etc.).

In order to narrow this down, you should:
* recreate the error on your site
* then disable all CiviCRM RELATED modules (but not CiviCRM) and see if that makes the error go away (I suspect it will)
* then re-enable the related modules one at a time to see which one causes the error to reappear
* finally - if you narrow it down AND it's a module we include in our distribution - file an issue tracker report w/ details on steps to recreate

This is a bug in CiviGroup Roles Synch IMO (it should delete or disable the mapping if the CiviCRM group is deleted). Can you file an issue (preferably with a patch).

Suggest you start a new thread and post exact steps and complete error message. The prior poster had an issue specifically related to the CiviCRM Group Roles add-on module (which you didn't mention using).

Mick - Haven't installed Group Roles module for a while, but taking a quick look at the code it looks like that module creates a new table that joins CiviCRM groups to Drupal roles - civicrm_group_roles_rules. I'm guessing that table still exists and is pointing to a non-existent entry in the civicrm_group table (with id = 2).

// from civicrm_group_roles.install
function civicrm_group_roles_schema( )
{
    $schema['civicrm_group_roles_rules'] = array(
                                                 'fields' => array(
                                                                   'id' => array(
                                                                                 'type' => 'serial',
                                                                                 'unsigned' => TRUE,
                                                                                 'not null' => TRUE,
                                                                                 ),
                                                                   'role_id' => array(
                                                                                      'type' => 'int',
                                                                                      'unsigned' => TRUE,
                                                                                      'not null' => TRUE,
                                                                                      ),
                                                                   'group_id' => array(
                                                                                       'type' => 'int',
                                                                                       'unsigned' => TRUE,
                                                                                       'not null' => TRUE,
                                                                                       )
                                                                   ),
                                                 'primary key' => array('id'),
                                                 );
   
    return $schema;
}