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 »
  • Post-installation Setup and Configuration (Moderator: Dave Greenberg) »
  • Synchronize users to contacts
Pages: [1]

Author Topic: Synchronize users to contacts  (Read 2949 times)

djtrouten

  • I’m new here
  • *
  • Posts: 29
  • Karma: 1
    • Evangelical Press Association
  • CiviCRM version: 3.4.7
  • CMS version: Joomla 1.5.23
  • MySQL version: 5.0.91
  • PHP version: 5.2.16
Synchronize users to contacts
January 26, 2010, 08:19:30 am
I'm trying to run the "synchronize users to contacts" routine, and I get an error (see below). Any clues? It seems to be telling me that a user already exists, but shouldn't it then connect the Joomla user with their CiviCRM record?

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

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 ,  649 , 'jhannigan@floridabaptistwitness.com' ,  255 )  [nativecode=1062 ** Duplicate entry '255-1' for key 3]
    [type] => DB_Error
    [user_info] => INSERT INTO civicrm_uf_match (domain_id , uf_id , uf_name , contact_id ) VALUES ( 1 ,  649 , 'jhannigan@floridabaptistwitness.com' ,  255 )  [nativecode=1062 ** Duplicate entry '255-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 ,  649 , 'jhannigan@floridabaptistwitness.com' ,  255 )  [nativecode=1062 ** Duplicate entry '255-1' for key 3]"]
)

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: Synchronize users to contacts
January 26, 2010, 09:11:45 am

can u check your civicrm_uf_match table for another instance of 255 in the contact_id column

seems like u have 2 drupal users for the same contact

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

djtrouten

  • I’m new here
  • *
  • Posts: 29
  • Karma: 1
    • Evangelical Press Association
  • CiviCRM version: 3.4.7
  • CMS version: Joomla 1.5.23
  • MySQL version: 5.0.91
  • PHP version: 5.2.16
Re: Synchronize users to contacts
January 26, 2010, 09:03:54 pm
I've searched the civicrm_uf_match table for instances of "255." It appears in one record in the uf_id column, and in another record in the contact_id column. That's it -- it doesn't appear twice in the contact_it column.

petednz

  • Forum Godess / God
  • I’m (like) Lobo ;)
  • *****
  • Posts: 4899
  • Karma: 193
    • Fuzion
  • CiviCRM version: 3.x - 4.x
  • CMS version: Drupal 6 and 7
Re: Synchronize users to contacts
January 26, 2010, 09:48:42 pm
can you update your profile to show joomla ;-) and any other relevant cms - thx
Sign up to StackExchange and get free expert advice: https://civicrm.org/blogs/colemanw/get-exclusive-access-free-expert-help

pete davis : www.fuzion.co.nz : connect + campaign + communicate

Eileen

  • Forum Godess / God
  • I’m (like) Lobo ;)
  • *****
  • Posts: 4195
  • Karma: 218
    • Fuzion
Re: Synchronize users to contacts
January 26, 2010, 11:06:25 pm
Hi,

This is the same problem I was talking about over here:

http://forum.civicrm.org/index.php/topic,11773.msg50548.html#msg50548

I believe it is a bug & I have seen it on a couple of sites but it may affect more as not everyone would be aware of it not working.

Lobo / someone from the core team - can you check my logic in the other thread as to what the patch approach would be?
Make today the day you step up to support CiviCRM and all the amazing organisations that are using it to improve our world - http://civicrm.org/contribute

shunshifu

  • I’m new here
  • *
  • Posts: 10
  • Karma: 0
Re: Synchronize users to contacts
February 13, 2010, 06:34:14 pm
I am also having this same error

Code: [Select]
Synchronize Users to Contacts

Sorry. A non-recoverable error has occurred.
DB Error: already exists

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 (domain_id , uf_id , uf_name , contact_id ) VALUES ( 1 ,  619 , 'dfergusonsped@yahoo.com' ,  2336 )  [nativecode=1062 ** Duplicate entry '2336-1' for key 3]
    [type] => DB_Error
    [user_info] => INSERT INTO civicrm_uf_match (domain_id , uf_id , uf_name , contact_id ) VALUES ( 1 ,  619 , 'dfergusonsped@yahoo.com' ,  2336 )  [nativecode=1062 ** Duplicate entry '2336-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 ,  619 , 'dfergusonsped@yahoo.com' ,  2336 )  [nativecode=1062 ** Duplicate entry '2336-1' for key 3]"][/code]

Kurund Jalmi

  • Administrator
  • I’m (like) Lobo ;)
  • *****
  • Posts: 4169
  • Karma: 128
    • CiviCRM
  • CiviCRM version: 4.x, future
  • CMS version: Drupal 7, Joomla 3.x
  • MySQL version: 5.5.x
  • PHP version: 5.4.x
Re: Synchronize users to contacts
February 13, 2010, 10:31:28 pm
Might be possible that you have 2 or more user in joomla with same email address. You might want to empty "civicrm_uf_match" table and then try sync contacts.

HTh
Kurund
Found this reply helpful? Support CiviCRM

Eileen

  • Forum Godess / God
  • I’m (like) Lobo ;)
  • *****
  • Posts: 4195
  • Karma: 218
    • Fuzion
Re: Synchronize users to contacts
February 13, 2010, 11:13:06 pm
Where I have seen this a lot is where there are two e-mail addresses which match a CiviCRM contact - e.g. there is a user with an e-mail which matches their billing address & another with an e-mail which matches their primary address. In this case even deleting the uf-match entries won't help as the conflict is recreated
Make today the day you step up to support CiviCRM and all the amazing organisations that are using it to improve our world - http://civicrm.org/contribute
Pages: [1]
  • CiviCRM Community Forums (archive) »
  • Old sections (read-only, deprecated) »
  • Support »
  • Using CiviCRM »
  • Post-installation Setup and Configuration (Moderator: Dave Greenberg) »
  • Synchronize users to contacts

This forum was archived on 2017-11-26.