CiviCRM Community Forums (archive)

I got this unrecoverable error when editing a contact...His primary contact info didn't have an e-mail but his additional contact info did.  I copied that e-mail to his primary contact info and saved it only to get the error below.  I deleted the e-mail from his alternative info, then saved.  Then copied it back to his primary info and saved and it worked.  No one else has this e-mail.  This is just weird to me.  Anyone have any ideas?

Sorry. A non-recoverable error has occurred.

    Database Error Code: Duplicate entry 'civicrm_contact-1205-1' for key 2, 1062

    Return to CiviCRM menu.

Error Details:

Array
(
    [callback] => Array
        (
           

• => CRM_Core_Error
[1] => handle
        )

   

=> -5
    [message] => DB Error: already exists
    [mode] => 16
    [debug_info] => UPDATE  civicrm_location  SET entity_table = 'civicrm_contact' , entity_id = 1205 , location_type_id = 1 , is_primary = 1 , name = ''   WHERE (  civicrm_location.id = 1931 )   [nativecode=1062 ** Duplicate entry 'civicrm_contact-1205-1' for key 2]
    [type] => DB_Error
    [user_info] => UPDATE  civicrm_location  SET entity_table = 'civicrm_contact' , entity_id = 1205 , location_type_id = 1 , is_primary = 1 , name = ''   WHERE (  civicrm_location.id = 1931 )   [nativecode=1062 ** Duplicate entry 'civicrm_contact-1205-1' for key 2]
    [to_string] => [db_error: message="DB Error: already exists" code=-5 mode=callback callback=CRM_Core_Error::handle prefix="" info="UPDATE  civicrm_location  SET entity_table = 'civicrm_contact' , entity_id = 1205 , location_type_id = 1 , is_primary = 1 , name = ''   WHERE (  civicrm_location.id = 1931 )   [nativecode=1062 ** Duplicate entry 'civicrm_contact-1205-1' for key 2]"]
)


Okay,

I duplicated it on the demo server.  My steps and error are listed below.  I don't know if all of the steps/items are required (like having two e-mails in the original location info) but I was trying to replicate the original contact I had.

1. Create New individual -- Entered first name, last name, e-mail 1, e-mail 2, 1 tag, save.
2. Edit same individual -- add additional location (I chose billing, but don't think it matters) -- no e-mail, address 1 (street 1, city, state, country), make new location primary, save.
3. Edit individual again, delete e-mail 1 (from original, but now additional location), leave e-mail 2 where it is.  Paste e-mail 1 into new primary location.  Change primary location to Home, change additional location to Other, Save.

ERROR:

     Sorry. A non-recoverable error has occurred.

    Database Error Code: Duplicate entry 'civicrm_contact-1067-1' for key 2, 1062

    Return to CiviCRM menu.

Error Details:

Array
(
    [callback] => Array
        (
            [0] => CRM_Core_Error
            [1] => handle
        )

    [code] => -5
    [message] => DB Error: already exists
    [mode] => 16
    [debug_info] => UPDATE  civicrm_location  SET entity_table = 'civicrm_contact' , entity_id = 1067 , location_type_id = 1 , is_primary = 1 , name = ''   WHERE (  civicrm_location.id = 1080 )   [nativecode=1062 ** Duplicate entry 'civicrm_contact-1067-1' for key 2]
    [type] => DB_Error
    [user_info] => UPDATE  civicrm_location  SET entity_table = 'civicrm_contact' , entity_id = 1067 , location_type_id = 1 , is_primary = 1 , name = ''   WHERE (  civicrm_location.id = 1080 )   [nativecode=1062 ** Duplicate entry 'civicrm_contact-1067-1' for key 2]
    [to_string] => [db_error: message="DB Error: already exists" code=-5 mode=callback callback=CRM_Core_Error::handle prefix="" info="UPDATE  civicrm_location  SET entity_table = 'civicrm_contact' , entity_id = 1067 , location_type_id = 1 , is_primary = 1 , name = ''   WHERE (  civicrm_location.id = 1080 )   [nativecode=1062 ** Duplicate entry 'civicrm_contact-1067-1' for key 2]"]
)

[/code]

Great!  I'll try to remember the swapping thing when I update things in the future.