CiviCRM Community Forums (archive)

I'm trying to update records via Batch Profile.  After I have updated the records in the batch and click save I get the following error:

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

Eek!  The batch appears to be squeaky clean with no known duplicates in sight. It occurs whether I am updating 2, 4 or 50 records at a time.
My duplicate settings are: Email, FirstName, LastName

Any help you could provide on this is greatly appreciated. 

Below is the full error code:
  => -5
    [message] => DB Error: already exists
    [mode] => 16
    [debug_info] => INSERT INTO civicrm_value_1_supplemental  SET `interests` = '', domain_id = 1, entity_id = 1760  [nativecode=1062 ** Duplicate entry '1-1760' for key 2]
    [type] => DB_Error
    [user_info] => INSERT INTO civicrm_value_1_supplemental  SET `interests` = '', domain_id = 1, entity_id = 1760  [nativecode=1062 ** Duplicate entry '1-1760' for key 2]
    [to_string] => [db_error: message="DB Error: already exists" code=-5 mode=callback callback=CRM_Core_Error::handle prefix="" info="INSERT INTO civicrm_value_1_supplemental  SET `interests` = '', domain_id = 1, entity_id = 1760  [nativecode=1062 ** Duplicate entry '1-1760' for key 2]"]
)



I was able to successfully upload the contacts into the sandbox site. The file I was trying to upload had both organizational and individual records.  I will segment my file and try to upload again. Thanks for checking into this.