CiviCRM Community Forums (archive)

So I upgraded from Joomla 1.5.2 to Joomla 1.5.9... that went well, and it didn't break my civicrm install.

I had been running Civicrm 2.0.2 (well, on my real site, I still am...)
I'm excited about upgrading to 2.2... so I started following the directions to upgrade to 2.1, and the installation seems to work fine... only the database does not upgrade (this step fails).  I've tried refreshing this and that, and running the upgrade script again. The database doesn't seem to want to upgrade. Is there, perhaps some simple thing I can do to make it easier for the database upgrade script to succeed ?

Rebuilding my database doesn't sound simple.... can you guys shed some light on this ?


Warning: Smarty error: unable to read resource: "CRM/error.tpl" in ***joomla root***/administrator/components/com_civicrm/civicrm/packages/Smarty/Smarty.class.php on line 1092

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

Database consistency check failed. FK constraint names not in the required format. Please rebuild your 2.0 database to ensure schema integrity.

Return to home pag

backTrace

**joomla root**/administrator/components/com_civicrm/civicrm/CRM/Core/Error.php, backtrace, 138
, handle,
**joomla root**/administrator/components/com_civicrm/civicrm/packages/PEAR.php, call_user_func, 912
**joomla root**/administrator/components/com_civicrm/civicrm/packages/DB.php, PEAR_Error, 966
**joomla root**/administrator/components/com_civicrm/civicrm/packages/PEAR.php, DB_Error, 574
**joomla root**/administrator/components/com_civicrm/civicrm/packages/DB/common.php, raiseError, 1903
**joomla root**/administrator/components/com_civicrm/civicrm/packages/DB/mysql.php, raiseError, 898
**joomla root**/administrator/components/com_civicrm/civicrm/packages/DB/mysql.php, mysqlRaiseError, 327
**joomla root**/administrator/components/com_civicrm/civicrm/packages/DB/common.php, simpleQuery, 1216
**joomla root**/administrator/components/com_civicrm/civicrm/packages/DB/DataObject.php, query, 2394
**joomla root**/administrator/components/com_civicrm/civicrm/packages/DB/DataObject.php, _query, 442
**joomla root**/administrator/components/com_civicrm/civicrm/CRM/Core/BAO/Setting.php, find, 153
**joomla root**/administrator/components/com_civicrm/civicrm/CRM/Core/Config.php, retrieve, 345
**joomla root**/administrator/components/com_civicrm/civicrm/CRM/Core/Config.php, _initVariables, 183
**joomla root**/administrator/components/com_civicrm/admin.civicrm.php, singleton, 25
**joomla root**/administrator/components/com_civicrm/admin.civicrm.php, civicrm_init, 37
**joomla root**/administrator/components/com_civicrm/admin.civicrm.php, civicrm_invoke, 22
**joomla root**/libraries/joomla/application/component/helper.php, require_once, 162
**joomla root**/administrator/includes/application.php, renderComponent, 136
**joomla root**/administrator/index.php, dispatch, 67
**joomla root**/administrator/index2.php, include, 14

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]

mrnoah,

Database consistency check failed. FK constraint names not in the required format. Please rebuild your 2.0 database to ensure schema integrity.

The error indicates that something is wrong with the structure of db (specially constraint format).
The solution is to rebuild your 2.0 db -
1. create a new database with the structure from the file "civicrm_20_codebase/sql/civicrm.mysql".
2. Import ONLY data FROM your 2.0db TO newly created database in previous step.