CiviCRM Community Forums (archive)

I received the following error when upgrading:

unrecoverable error
    Sorry. A non-recoverable error has occurred.

    DB Error: already exists

    Database Error Code: Duplicate entry '751-6' for key 2, 1062

    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] => ALTER TABLE civicrm_entity_tag
  ADD UNIQUE UI_contact_id_tag_id ( contact_id, tag_id ) [nativecode=1062 ** Duplicate entry '751-6' for key 2]
    [type] => DB_Error
    [user_info] => ALTER TABLE civicrm_entity_tag
  ADD UNIQUE UI_contact_id_tag_id ( contact_id, tag_id ) [nativecode=1062 ** Duplicate entry '751-6' for key 2]
    [to_string] => [db_error: message="DB Error: already exists" code=-5 mode=callback callback=CRM_Core_Error::handle prefix="" info="ALTER TABLE civicrm_entity_tag
  ADD UNIQUE UI_contact_id_tag_id ( contact_id, tag_id ) [nativecode=1062 ** Duplicate entry '751-6' for key 2]"]
)

To solve the problem:

1) manually deleted tables in the CiviCRM database
2) restored both the CiviCRM 2.1.1 code and database, and verified everything worked
3) went into phpMyAdmin and executed the following SQL statement to identify duplicates in the civicrm_entity_tag table:
SELECT * , count( contact_id ) AS counter
FROM `civicrm_entity_tag`
GROUP BY `contact_id` , tag_id
ORDER BY `counter` DESC
4) still in phpMyAdmin, manually deleted duplicates identified in step above
5) backed up new version of CiviCRM database
6) am repeating upgrade process now

Just documenting here for anybody else who might experience the same problem.  Also, it would be nice to upgrade the install file to do this automatically.[/code]

I have the same problem updating from 2.1 to 2.2.

I tried using 2.2.1 for update but still getting problem with duplicates in the civicrm_entity_tag table. THere are at least 200 dupes so manually identifying and deleting will be very time consuming.

Any suggestions?