CiviCRM Community Forums (archive)

We are using CiviMember Roles Sync to correctly establish Drupal group perms for Member Drupal user accounts.

We have another portion of contacts in CiviCRM that are Organization records, not site members. Thus no Drupal ID exists for these contacts.

We are running into the following error while trying to update an Organization record:

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

Seems that people have encountered such with CiviMember Roles Sync enabled. "Ja, we need it!"

I quickly checked the CiviMember Roles Sync settings, an no where does it specify what type of record to perform the sync upon. So I would guess that it is trying to sync for both Member and Organization records.

Is there some way to stipulate that it must be a "Member" contact in order to qualify for a sync and/or exclude "Organization" records?

Digging a bit further... Why would this code get run while editing / making an update to a organization contact?

In CRM/Contact/BAO/Contact.php
        // make a civicrm_subscription_history entry only on contact create (CRM-777)
        if ( ! CRM_Utils_Array::value( 'contact_id', $params ) ) {
            $subscriptionParams = array('contact_id' => $contact->id,
                                        'status' => 'Added',
                                        'method' => 'Admin');
            CRM_Contact_BAO_SubscriptionHistory::create($subscriptionParams);
        }

Per the comment, should only execute at creation? But this is being executed when updating an existing Civi record. Thus confused...

issue here:

http://issues.civicrm.org/jira/browse/CRM-7925

lboo

Hi Lobo,
I think I've run into the same issue with a civiCRM 3.1 site so I didn't want to post a duplicate issue.

We are updating to civiCRM 3.4.5 and I wonder will the updated version have some way of consolidating or detecting and reporting the duplicate problem rather than throwing the error. I found one this afternoon and I have a feeling that there will be others.

In the case of the one I found today, the user logged into the Drupal site just fine but when they tried to gain access to the civi side of their account, the "already exists" error was thrown with the following details (I've obfuscated the email address):
Array
(
    [callback] => Array
        (
            [0] => CRM_Core_Error
            [1] => handle
        )

    [code] => -5
    [message] => DB Error: already exists
    [mode] => 16
    [debug_info] => INSERT INTO civicrm_uf_match (domain_id , uf_id , uf_name , contact_id ) VALUES ( 1 ,  859 , 'email-address@provider.com' ,  983 )  [nativecode=1062 ** Duplicate entry '983-1' for key 3]
    [type] => DB_Error
    [user_info] => INSERT INTO civicrm_uf_match (domain_id , uf_id , uf_name , contact_id ) VALUES ( 1 ,  859 , 'email-address@provider.com' ,  983 )  [nativecode=1062 ** Duplicate entry '983-1' for key 3]
    [to_string] => [db_error: message="DB Error: already exists" code=-5 mode=callback callback=CRM_Core_Error::handle prefix="" info="INSERT INTO civicrm_uf_match (domain_id , uf_id , uf_name , contact_id ) VALUES ( 1 ,  859 , 'email-address@provider.com' ,  983 )  [nativecode=1062 ** Duplicate entry '983-1' for key 3]"]
)
 

As it turned out the member had two Drupal accounts (with two different email addresses) and my guess is that they were both pointing to the same civiCRM contact record. Does that sound about right?

At any rate, I deleted the one that was throwing the errors and asked the member to use the one that works.

I think I will find a number of these duplicates in the system because I get a similar error when I try to synch users to contacts. Is there anyway to run a report so that I can find all the duplicates?

Thanks,
Andrew

@mdlueck: Thanks for clarifying that. I'll start a new thread then.

Cheers,
Andrew