CiviCRM Community Forums (archive)

*

News:

Have a question about CiviCRM?
Get it answered quickly at the new
CiviCRM Stack Exchange Q+A site
This forum was archived on 25 November 2017. Learn more.
How to get involved.
What to do if you think you've found a bug.



  • CiviCRM Community Forums (archive) »
  • Old sections (read-only, deprecated) »
  • Support »
  • Using CiviCRM »
  • Using Drupal Modules (Moderator: Donald Lobo) »
  • Sorry. A non-recoverable error has occurred. DB Error: already exists
Pages: [1]

Author Topic: Sorry. A non-recoverable error has occurred. DB Error: already exists  (Read 2454 times)

Alan.Guggenheim

  • Guest
Sorry. A non-recoverable error has occurred. DB Error: already exists
March 03, 2010, 09:41:28 am
When I try to run the Synchronize users to contacts option, I get the following error:

Sorry. A non-recoverable error has occurred.


--------------------------------------------------------------------------------

DB Error: already exists

Return to home page.
Error Details:


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

       
Code: [Select]
=> -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 ,  15 , 'email_of_somebody@aol.com' ,  6899 )  [nativecode=1062 ** Duplicate entry 'email_of_somebody@aol.com-1' for key 2]
    [type] => DB_Error
    [user_info] => INSERT INTO civicrm_uf_match (domain_id , uf_id , uf_name , contact_id ) VALUES ( 1 ,  15 , 'email_of_somebody@aol.com' ,  6899 )  [nativecode=1062 ** Duplicate entry 'email_of_somebody@aol.com-1' for key 2]
    [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 ,  15 , 'email_of_somebody@aol.com' ,  6899 )  [nativecode=1062 ** Duplicate entry 'email_of_somebody@aol.com-1' for key 2]"]
)


« Last Edit: March 03, 2010, 09:46:50 am by Alan.Guggenheim »

jonline

  • Guest
Re: Sorry. A non-recoverable error has occurred. DB Error: already exists
April 01, 2010, 01:47:47 am
Hi Alan

Did you get any solution for that? I am also getting this problem. I am getting this error while going to login other than with  Drupal "admin" user. I am getting this error into my development server but its working fine into my staging server. I think this is related to some other module because I have installed some other module into development server where as my staging server only the fresh installation.

will you please help me on that....

Alan.Guggenheim

  • Guest
Re: Sorry. A non-recoverable error has occurred. DB Error: already exists
April 03, 2010, 09:31:20 am
No, I did not get a reply from anybody.
I was actually working on it today, and i found that the issue here seems to be that we have multiple Drupal users with the same email address.
I am looking at a good tool to list them
Any idea?

EdP

  • I post frequently
  • ***
  • Posts: 260
  • Karma: 7
  • CiviCRM version: 4.4
  • CMS version: Joomla 2.5.x
Re: Sorry. A non-recoverable error has occurred. DB Error: already exists
April 03, 2010, 02:26:26 pm
Quote from: Alan.Guggenheim on April 03, 2010, 09:31:20 am
No, I did not get a reply from anybody.
I was actually working on it today, and i found that the issue here seems to be that we have multiple Drupal users with the same email address.
I am looking at a good tool to list them
Any idea?


When I've had this it was because I had two CMS users with the same email address (actually the same person who lost their account and just created a new one) - I think it  happened where I had merged the two CiviCRM records (since I had identified that they were the same person) but then tried to synchronise and the system got upset because in some way it still thought of both CMS accounts being tied to the CiviCRM contact (or something). Just having two contact with the same email is not fatal - because I have other records that have the same email address (husband, wife, household) and that's fine.

I didn't need to track the problem with a separate tool - the email address given in the error made it pretty clear who the problem was with, and my fix was to delete one of their CRM accounts.

Alan.Guggenheim

  • Guest
Re: Sorry. A non-recoverable error has occurred. DB Error: already exists
April 03, 2010, 04:25:16 pm
Yes, finally it is the same here except I had quite a few of them.
Finished cleaning it up and now the sync works.
I wish the error trapping was better and that there were tools in Drupal to easily find duplicate email addresses.
Pages: [1]
  • CiviCRM Community Forums (archive) »
  • Old sections (read-only, deprecated) »
  • Support »
  • Using CiviCRM »
  • Using Drupal Modules (Moderator: Donald Lobo) »
  • Sorry. A non-recoverable error has occurred. DB Error: already exists

This forum was archived on 2017-11-26.