CiviCRM Community Forums (archive)

Hi Guys, I get the following error when trying to upgrade from 3.1.3 to 3.3.0... any advice?? thanks.

Sorry. A non-recoverable error has occurred.
DB Error: already exists

Database Error Code: Duplicate entry 'civicrm_participant-357-11-10' for key 'UI_line_item_value', 1062
Additional Details:
Array
(
    [callback] => Array
        (
           

• => CRM_Core_Error
[1] => handle
        )

   

=> -5
    [message] => DB Error: already exists
    [mode] => 16
    [debug_info] => ALTER TABLE `civicrm_line_item` ADD UNIQUE INDEX UI_line_item_value (`entity_table`,`entity_id`,`price_field_value_id`,`price_field_id`) [nativecode=1062 ** Duplicate entry 'civicrm_participant-357-11-10' for key 'UI_line_item_value']
    [type] => DB_Error
    [user_info] => ALTER TABLE `civicrm_line_item` ADD UNIQUE INDEX UI_line_item_value (`entity_table`,`entity_id`,`price_field_value_id`,`price_field_id`) [nativecode=1062 ** Duplicate entry 'civicrm_participant-357-11-10' for key 'UI_line_item_value']
    [to_string] => [db_error: message="DB Error: already exists" code=-5 mode=callback callback=CRM_Core_Error::handle prefix="" info="ALTER TABLE `civicrm_line_item` ADD UNIQUE INDEX UI_line_item_value (`entity_table`,`entity_id`,`price_field_value_id`,`price_field_id`) [nativecode=1062 ** Duplicate entry 'civicrm_participant-357-11-10' for key 'UI_line_item_value']"]
)

bsorgi,

This is fixed and will be a part of next release. You can get the patch from http://fisheye2.atlassian.com/changelog/CiviCRM?cs=31121,
you may need to apply the patch to 3.3.0 stable tar and do the upgrade once again.

HTH,
Rahul