Synchronising Joomla user into CiviCRM - Error [Solved]

[fre]

I'm experiencing an error when I try to use 'Synchronise users-to-contacts'

Code: [Select]

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

I figured this out just as I was posting here

It is caused by having more than one user registered with the same email address. As I was installing this on a test site, I had a number of users with the same email address (Joomla default is that email addresses must be unique but I turned it off for the test site). To fix this I just gave the clashing users other email addresses.


[/code]