CiviCRM Community Forums (archive)

Hello there,
I have exactly the same symptoms as an issue raised during the testing for the 2.1 release (http://forum.civicrm.org/index.php/topic,4752.0.html)with missing "locales" and "config_backend" fields in the table "civicrm_domain", but mine is on an upgrade from 2.0.3 to 2.1.1. I have verified in phpmyadmin that the table exists but that the fields do not, either in the version that crashed mid update (and that now outputs the backtrace below to the screen) or in my working backup of the database from civicrm 2.0.3.
The previous solution stated that the database version needs to be changed, but looking at the version number in the table itself (civicrm_domain) it is already set to 2.0. Any ideas how I can fix this. Backtrace output attached below.

Many, many thanks for any advice that you might have,
Cheers,
durruti

backTrace

/data01/mrsn/public_html/directory/sites/all/modules/civicrm/CRM/Core/Error.php, backtrace, 138
, handle,
/data01/mrsn/public_html/directory/sites/all/modules/civicrm/packages/PEAR.php, call_user_func, 912
/data01/mrsn/public_html/directory/sites/all/modules/civicrm/packages/DB.php, PEAR_Error, 966
/data01/mrsn/public_html/directory/sites/all/modules/civicrm/packages/PEAR.php, DB_Error, 574
/data01/mrsn/public_html/directory/sites/all/modules/civicrm/packages/DB/common.php, raiseError, 1903
/data01/mrsn/public_html/directory/sites/all/modules/civicrm/packages/DB/mysql.php, raiseError, 898
/data01/mrsn/public_html/directory/sites/all/modules/civicrm/packages/DB/mysql.php, mysqlRaiseError, 327
/data01/mrsn/public_html/directory/sites/all/modules/civicrm/packages/DB/common.php, simpleQuery, 1216
/data01/mrsn/public_html/directory/sites/all/modules/civicrm/packages/DB/DataObject.php, query, 2394
/data01/mrsn/public_html/directory/sites/all/modules/civicrm/packages/DB/DataObject.php, _query, 442
/data01/mrsn/public_html/directory/sites/all/modules/civicrm/CRM/Core/BAO/Setting.php, find, 153
/data01/mrsn/public_html/directory/sites/all/modules/civicrm/CRM/Core/Config.php, retrieve, 345
/data01/mrsn/public_html/directory/sites/all/modules/civicrm/CRM/Core/Config.php, _initVariables, 183
/data01/mrsn/public_html/directory/sites/all/modules/civicrm/drupal/civicrm.module, singleton, 245
/data01/mrsn/public_html/directory/sites/all/modules/civicrm/drupal/civicrm.module, civicrm_initialize, 150
, civicrm_block,
/data01/mrsn/public_html/directory/includes/module.inc, call_user_func_array, 450
/data01/mrsn/public_html/directory/modules/block/block.module, module_invoke, 473
/data01/mrsn/public_html/directory/includes/theme.inc, block_list, 1530
/data01/mrsn/public_html/directory/themes/chameleon/chameleon.theme, theme_blocks, 27
, chameleon_page,
/data01/mrsn/public_html/directory/includes/theme.inc, call_user_func_array, 597
/data01/mrsn/public_html/directory/includes/common.inc, theme, 365
/data01/mrsn/public_html/directory/index.php, drupal_not_found, 24

Sorry. A non-recoverable error has occurred. The error trace below might help to resolve the issue

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

    [code] => -19
    [message] => DB Error: no such field
    [mode] => 16
    [debug_info] => SELECT  config_backend, locales 
 FROM civicrm_domain
 
 
 
 
 
 [nativecode=1054 ** Unknown column 'locales' in 'field list']
    [type] => DB_Error
    [user_info] => SELECT  config_backend, locales 
 FROM civicrm_domain
 
 
 
 
 
 [nativecode=1054 ** Unknown column 'locales' in 'field list']
    [to_string] => [db_error: message="DB Error: no such field" code=-19 mode=callback callback=CRM_Core_Error::handle prefix="" info="SELECT  config_backend, locales 
 FROM civicrm_domain
 
 
 
 
 
 [nativecode=1054 ** Unknown column 'locales' in 'field list']"]
)

[/code]