CiviCRM Community Forums (archive)

IMO, duplicates can always exist, and should not generate an unrecoverable error.

http://localhost/j2/administrator/index2.php?option=com_civicrm&task=civicrm/admin/synchUser&

CRM_Admin_Form_CMSUser

unrecoverable error
    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 ,  63 , 'tabletguy@mywebsite.com' ,  102 )  [nativecode=1062 ** Duplicate entry '102-1' for key 'UI_contact_domain_id']
    [type] => DB_Error
    [user_info] => INSERT INTO civicrm_uf_match (domain_id , uf_id , uf_name , contact_id ) VALUES ( 1 ,  63 , 'tabletguy@mywebsite.com' ,  102 )  [nativecode=1062 ** Duplicate entry '102-1' for key 'UI_contact_domain_id']
    [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 ,  63 , 'tabletguy@mywebsite.com' ,  102 )  [nativecode=1062 ** Duplicate entry '102-1' for key 'UI_contact_domain_id']"]
)

[/code]

I sent you a PM yesterday about this.

Basically, I don't think I would know how to do this, as I'm quit new to CiviCRM.

I "could" say it should work similar to import, where errors are collected (along with name of field(s) in error), and then at the end, that list of errors should be offered for download. So, basically emulate (copy) much of that code, or, perhaps, make a common object that collects the sql errors, and then a common object to present the collection for download, etc.