CiviCRM Community Forums (archive)

In a case where there is a CiviCRM contact for a member, but no corresponding Drupal user, users get the following error trying to create a Drupal user account:

Sorry. A non-recoverable error has occurred.

Database Error Code: Duplicate entry 'useremail@verizon.net-1' for key 4, 1062

Return to home page.

Error Details:


Array
(
    [callback] => Array
        (
           

• => CRM_Core_Error
[1] => handle
        )

   

=> -5
    [message] => DB Error: already exists
    [mode] => 16
    [debug_info] => INSERT INTO civicrm_uf_match (uf_id , uf_name , contact_id , domain_id ) VALUES ( 471 , 'useremail@verizon.net' ,  1181 ,  1 )  [nativecode=1062 ** Duplicate entry 'useremail@verizon.net-1' for key 4]
    [type] => DB_Error
    [user_info] => INSERT INTO civicrm_uf_match (uf_id , uf_name , contact_id , domain_id ) VALUES ( 471 , 'useremail@verizon.net' ,  1181 ,  1 )  [nativecode=1062 ** Duplicate entry 'useremail@verizon.net-1' for key 4]
    [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 (uf_id , uf_name , contact_id , domain_id ) VALUES ( 471 , 'useremail@verizon.net' ,  1181 ,  1 )  [nativecode=1062 ** Duplicate entry 'useremail@verizon.net-1' for key 4]"]
)

Some additional background...

The site is running Drupal 5.7 and CiviCRM 2.03.

There are two custom profiles for capturing additional information.

The behavior I am expecting is for Drupal to create the user account, then associate it with the appropriate CiviCRM contact based on matching e-mail addresses.

Can anyone help me out?

Thanks,
Alex.

Dave, I appreciate your help...

I checked the Drupal users table and there is just one user with the e-mail address in question.

However, there is a record with that e-mail address in CiviCRM's civicrm_uf_match table. I'm not sure if I am interpreting the meaning of the columns correctly, but the uf_id value is different from the Drupal user ID. For other accounts, this field matches.

Is my interpretation correct? Is there any harm in deleting the offending record in civicrm_uf_match?

Alex.

i'm not sure of the full sequence of events either. The end user tried to create the account a few times, then other administrators deleted the account and also attempted to re-create it.

So I guess the follow-on question is: What happens when Drupal users are deleted if they are linked to CiviCRM contacts?  Is the link automatically deleted too?