CiviCRM Community Forums (archive)

I get this error when I attempt to upgrade the database:

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

Database Error Code: Duplicate entry 'report_template' for key 2, 1062

Return to home page.

Error Details:

Array
(
    [callback] => Array
        (
           

• => CRM_Core_Error
[1] => handle
        )

   

=> -5
    [message] => DB Error: already exists
    [mode] => 16
    [debug_info] => INSERT INTO civicrm_option_group
        (name, description, is_reserved, is_active )
    VALUES
        ('report_template', 'Report Template', 0, 1 ) [nativecode=1062 ** Duplicate entry 'report_template' for key 2]
    [type] => DB_Error
    [user_info] => INSERT INTO civicrm_option_group
        (name, description, is_reserved, is_active )
    VALUES
        ('report_template', 'Report Template', 0, 1 ) [nativecode=1062 ** Duplicate entry 'report_template' 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_option_group
        (name, description, is_reserved, is_active )
    VALUES
        ('report_template', 'Report Template', 0, 1 ) [nativecode=1062 ** Duplicate entry 'report_template' for key 2]"]
)

I'm trying to upgrade from 2.2.6 to 2.2.9 and still get the same error when upgrading the database.

i'd roll back to 2.2.6 till we figure this out

lobo

I get this:

50   report_template   NULL   Report Template   0   1

50   report_template   NULL   Report Template   0   1

You should not get above result, since it was added in 2.2.7.  So I would suggest you should try upgrading from your original 2.2.6 database.

Also before your upgrade, can you confirm that in civicrm_domain table civicrm version is "2.2.6".

Kurund