CiviCRM Community Forums (archive)

While following instructions here to upgrade from 3.0.1

http://wiki.civicrm.org/confluence/display/CRMDOC/Upgrade+Drupal+Sites+to+3.0


I started to run the upgrade:

http://mysite/civicrm/upgrade?reset=1

I clicked the Upgrade Now button, and soon got the following debug dump.

The main error appeared to be

        Duplicate column name 'name_en_US'


FYI, a few days ago in Drupal I enabled the multilanguage setting. However I didn't change anything after that in CiviCRM Admin.

/var/svn/htdocs-6.14/sites/mysite/modules/civicrm/CRM/Core/Error.php, backtrace, 146, handle,
/var/svn/htdocs-6.14/sites/mysite/modules/civicrm/packages/PEAR.php, call_user_func, 912
/var/svn/htdocs-6.14/sites/mysite/modules/civicrm/packages/DB.php, PEAR_Error, 969
/var/svn/htdocs-6.14/sites/mysite/modules/civicrm/packages/PEAR.php, DB_Error, 574
/var/svn/htdocs-6.14/sites/mysite/modules/civicrm/packages/DB/common.php, raiseError, 1903
/var/svn/htdocs-6.14/sites/mysite/modules/civicrm/packages/DB/mysql.php, raiseError, 898
/var/svn/htdocs-6.14/sites/mysite/modules/civicrm/packages/DB/mysql.php, mysqlRaiseError, 327
/var/svn/htdocs-6.14/sites/mysite/modules/civicrm/packages/DB/common.php, simpleQuery, 1216
/var/svn/htdocs-6.14/sites/mysite/modules/civicrm/CRM/Utils/File.php, query, 236
/var/svn/htdocs-6.14/sites/mysite/modules/civicrm/CRM/Upgrade/Form.php, sourceSQLFile, 75
/var/svn/htdocs-6.14/sites/mysite/modules/civicrm/CRM/Upgrade/Form.php, source, 212
/var/svn/htdocs-6.14/sites/mysite/modules/civicrm/CRM/Upgrade/Form.php, processLocales, 229
/var/svn/htdocs-6.14/sites/mysite/modules/civicrm/CRM/Upgrade/Page/Upgrade.php, processSQL, 120
/var/svn/htdocs-6.14/sites/mysite/modules/civicrm/CRM/Core/Invoke.php, run, 209
/var/svn/htdocs-6.14/sites/mysite/modules/civicrm/drupal/civicrm.module, invoke, 333, civicrm_invoke,
/var/svn/htdocs-6.14/includes/menu.inc, call_user_func_array, 348
/var/svn/htdocs-6.14/index.php, menu_execute_active_handler, 22


Error Details:

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

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