CiviCRM Community Forums (archive)

Hi,

For some reason it keeps trying to insert contact_id '3' when I already have 8 contacts in the system. the highest contact_id is '8' in both civicrm_contact and civicrm_uf_match so I'm not sure if there is another table the function looks at to determine the contact_id

For some reason, when users create accounts themselves it works just fine. This only happens when an admin creates a user account (or tries to synchronize users to contacts)

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 , contact_id , domain_id ) VALUES ( 10 ,  3 ,  1 )  [nativecode=1062 ** Duplicate entry '3' for key 4]
    [type] => DB_Error
    [user_info] => INSERT INTO civicrm_uf_match (uf_id , contact_id , domain_id ) VALUES ( 10 ,  3 ,  1 )  [nativecode=1062 ** Duplicate entry '3' 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 , contact_id , domain_id ) VALUES ( 10 ,  3 ,  1 )  [nativecode=1062 ** Duplicate entry '3' for key 4]"]
)


truncated the table

same issue

ok, that initially worked (I was able to synchronize)

However, the next time I tried to add an user via administration interface..I got the same error

It does still work if a user creates a new account using drupal's 'create a new account' feature (both drupal user and civicrm contact is created). The website also has facebook authentication. If a user opts to login using their facebook account, a drupal user and civicrm contact is created. Only problem seems to be while adding user using 'add user'