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 (Moderator: Dave Greenberg) »
  • Error using Synchronize Users to Contacts tool (Drupal 5.4 and CiviCRM 1.9)
Pages: [1]

Author Topic: Error using Synchronize Users to Contacts tool (Drupal 5.4 and CiviCRM 1.9)  (Read 1681 times)

posco

  • I post occasionally
  • **
  • Posts: 49
  • Karma: 8
Error using Synchronize Users to Contacts tool (Drupal 5.4 and CiviCRM 1.9)
February 18, 2008, 07:59:29 am
When we run the Synchronize Users to Contacts tool we get this error:

Code: [Select]
Synchronize Users to Contacts

unrecoverable error

Sorry. A non-recoverable error has occurred.

Return to home page.

Error Details:

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 (uf_id , contact_id , domain_id , email ) VALUES ( 122 ,  253 ,  1 , 'email@email.email' )  [nativecode=1062 ** Duplicate entry '253' for key 3]

    [type] => DB_Error

    [user_info] => INSERT INTO civicrm_uf_match (uf_id , contact_id , domain_id , email ) VALUES ( 122 ,  253 ,  1 , 'email@email.email' )  [nativecode=1062 ** Duplicate entry '253' 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 (uf_id , contact_id , domain_id , email ) VALUES ( 122 ,  253 ,  1 , 'email@email.email' )  [nativecode=1062 ** Duplicate entry '253' for key 3]"]

)
I've obfuscated the email address for privacy reasons. Does anyone know what is causing this error?[/code]

Donald Lobo

  • Administrator
  • I’m (like) Lobo ;)
  • *****
  • Posts: 15963
  • Karma: 470
    • CiviCRM site
  • CiviCRM version: 4.2+
  • CMS version: Drupal 7, Joomla 2.5+
  • MySQL version: 5.5.x
  • PHP version: 5.4.x
Re: Error using Synchronize Users to Contacts tool (Drupal 5.4 and CiviCRM 1.9)
February 18, 2008, 09:12:45 am

1. most likely it is causing that error because there 2 drupal id' matching contact 253.

Can u check the email address of uid = 122 and see if there is another user with the same email.

2. can you delete that record from civicrm_uf_match and see if the script proceeds further

thanx

lobo
A new CiviCRM Q&A resource needs YOUR help to get started. Visit our StackExchange proposed site, sign up and vote on 5 questions
Pages: [1]
  • CiviCRM Community Forums (archive) »
  • Old sections (read-only, deprecated) »
  • Support »
  • Using CiviCRM (Moderator: Dave Greenberg) »
  • Error using Synchronize Users to Contacts tool (Drupal 5.4 and CiviCRM 1.9)

This forum was archived on 2017-11-26.