CiviCRM Community Forums (archive)

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

    DB Error: a515ac9c2796ca0e23adbe92c68fc9fc

    Database Error Code: Duplicate column name 'label_en_US', 1060

    Palaa kotisivulle.

Code: [Select]

Error Details:

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

    [code] => a515ac9c2796ca0e23adbe92c68fc9fc
    [message] => DB Error: a515ac9c2796ca0e23adbe92c68fc9fc
    [mode] => 16
    [debug_info] => ALTER TABLE civicrm_option_group ADD label_en_US varchar(255) [nativecode=1060 ** Duplicate column name 'label_en_US']
    [type] => DB_Error
    [user_info] => ALTER TABLE civicrm_option_group ADD label_en_US varchar(255) [nativecode=1060 ** Duplicate column name 'label_en_US']
    [to_string] => [db_error: message="DB Error: a515ac9c2796ca0e23adbe92c68fc9fc" code=0 mode=callback callback=CRM_Core_Error::handle prefix="" info="ALTER TABLE civicrm_option_group ADD label_en_US varchar(255) [nativecode=1060 ** Duplicate column name 'label_en_US']"])

giving a few more details will help:

1. what was the state of DB before u got the error (was it already multi-lingual)

2. what sequence of operations led to this error

thanx

lobo

did u have it enabled previously?

This is very strange (and shouldn’t happen). Can you check whether the *_en_US columns exist for other cases?

If so, can you check the contents of the civicrm_domain.locales column? (It should have all available locales, but it seems your schema supports en_US while it’s missing from the locales column).