Upgrade error Drupal / WAMP install

[Eileen]

I got an error on trying to re-enable after upgrading - it quite correctly told me there was not locales field in the civicrm_domain table

When I ran the upgrade script I got this error:

Warning: Smarty error: unable to read resource: "CRM/error.tpl" in C:\wamp\www\html\sites\all\modules\civicrm\packages\Smarty\Smarty.class.php on line 1092

This seems not so surprising as the path to error.tpl is templates\CRM\form\error.tpl

I have just upgraded to Drupal 6.4 and here's my server config:

Server Configuration
Apache version :
Apache/2.0.59 (Win32)
 
PHP version :
5.2.0
 
Loaded extensions :
bcmath, calendar, com_dotnet, ctype, session, filter, ftp, hash, iconv, json, odbc, pcre, Reflection, date, libxml, standard, tokenizer, zlib, SimpleXML, dom, SPL, wddx, xml, xmlreader, xmlwriter, apache2handler, mbstring, mysql, mysqli, PDO, pdo_sqlite, SQLite
 
MySQL version :
5.0.27-community-nt

After upgrading I get the following:

backTrace

C:\wamp\www\html\sites\all\modules\civicrm\CRM\Core\Error.php, backtrace, 138
, handle,
C:\wamp\www\html\sites\all\modules\civicrm\packages\PEAR.php, call_user_func, 912
C:\wamp\www\html\sites\all\modules\civicrm\packages\DB.php, PEAR_Error, 966
C:\wamp\www\html\sites\all\modules\civicrm\packages\PEAR.php, DB_Error, 574
C:\wamp\www\html\sites\all\modules\civicrm\packages\DB\common.php, raiseError, 1903
C:\wamp\www\html\sites\all\modules\civicrm\packages\DB\mysql.php, raiseError, 898
C:\wamp\www\html\sites\all\modules\civicrm\packages\DB\mysql.php, mysqlRaiseError, 327
C:\wamp\www\html\sites\all\modules\civicrm\packages\DB\common.php, simpleQuery, 1216
C:\wamp\www\html\sites\all\modules\civicrm\packages\DB\DataObject.php, query, 2394
C:\wamp\www\html\sites\all\modules\civicrm\packages\DB\DataObject.php, _query, 442
C:\wamp\www\html\sites\all\modules\civicrm\CRM\Core\BAO\Setting.php, find, 153
C:\wamp\www\html\sites\all\modules\civicrm\CRM\Core\Config.php, retrieve, 337
C:\wamp\www\html\sites\all\modules\civicrm\CRM\Core\Config.php, _initVariables, 183
C:\wamp\www\html\sites\all\modules\civicrm\drupal\civicrm.module, singleton, 245
C:\wamp\www\html\includes\common.inc(1547) : eval()'d code, civicrm_initialize, 15
C:\wamp\www\html\includes\common.inc, eval, 1547
C:\wamp\www\html\modules\php\php.module, drupal_eval, 82
, php_filter,
C:\wamp\www\html\includes\module.inc, call_user_func_array, 450
C:\wamp\www\html\modules\filter\filter.module, module_invoke, 450
C:\wamp\www\html\modules\node\node.module, check_markup, 1040
C:\wamp\www\html\modules\node\node.module, node_prepare, 1081
C:\wamp\www\html\modules\node\node.module, node_build_content, 1002
C:\wamp\www\html\modules\node\node.module, node_view, 1739
, node_page_default,
C:\wamp\www\html\includes\menu.inc, call_user_func_array, 346
C:\wamp\www\html\index.php, menu_execute_active_handler, 18

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

Array
(
    [callback] => Array
        (
           

• => CRM_Core_Error
[1] => handle
        )

   

Code: [Select]

=> -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']"]


[Deepak Srivastava]

Warning: Smarty error: unable to read resource: "CRM/error.tpl" in C:\wamp\www\html\sites\all\modules\civicrm\packages\Smarty\Smarty.class.php on line 1092

The reason could be that upgrade script noticed some problem while doing the upgrade and wanted to display that error using the error-template which is templates/CRM/error.tpl in CiviCRM v2.0 and templates/CRM/common/fatal.tpl in CiviCRM v2.1.

While/before upgrading, your code-base is 2.1 but config still has old values. And when an error is encountered during/before upgrade it tries to display it using "templates/CRM/error.tpl" file which in v2.1 has actually changed to "templates/CRM/common/fatal.tpl".

Upgrade script does try to update config values at the end of upgrade script, which looks too late for this case. We 'll fix it as soon as possible.

Your temporary solution could be copy templates/CRM/common/fatal.tpl as templates/CRM/error.tpl and re-run the upgrade script to check for errors upgrade-script wanted to notify you.

it quite correctly told me there was not locales field in the civicrm_domain table

May be because upgrade didn't run successfully, you noticed this error.

[Eileen]

Thank you - it is complaining about the database version - where is this held?

Sorry. A non-recoverable error has occurred.

Database check failed - the current database is not v2.0.

[Eileen]

Here's a dump of the civicrm_domain table:

<?xml version="1.0" encoding="utf-8" ?>
<!--
-
- phpMyAdmin XML Dump
- version 2.9.0.3
- http://www.phpmyadmin.net
-
- Host: localhost
- Generation Time: Sep 11, 2008 at 08:04 PM
- Server version: 5.0.27
- PHP Version: 5.2.0
-->

<!--
- Database: 'dbname'
-->
<dbname>
  <!-- Table civicrm_domain -->
    <civicrm_domain>
        <id>1</id>
        <name>Wellington Circus Trust</name>
        <email_name>Wellington Circus Trust</email_name>
        <email_address>email@emailaddress</email_address>
        <email_domain>**Removed**<email_domain>
        <email_return_path>**Removed**</email_return_path>
        <config_backend>**Removed**<config_backend>
        <version>2</version>
        <loc_block_id>1</loc_block_id>
    </civicrm_domain>
</DB name>

[Eileen]

Ok - edited the version per about from '2' to '2.0' and the upgrade succeeded (nb I'm running 2.0.4)

[Durruti]

Hello there,
I have exactly the same problem with missing "locales" and "config_backend" fields in the table "civicrm_domain" on an upgrade from 2.0.3 to 2.1.1. I have verified in phpmyadmin that they are not there, either in the version that crashed mid update (and that now outputs the backtrace to the screen) or in my working backup of the database from civicrm 2.0.3.
I am unsure about where the database version needs to be changed, looking at the version number in the table itself (civicrm_domain) it is already set to 2.0. My backtrace output is identical to your issue as far as I can see, but I attach it anyway, in case I'm missing something. Any ideas how I can fix this.

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

Code: [Select]

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]

[Eileen]

Your temporary solution could be copy templates/CRM/common/fatal.tpl as templates/CRM/error.tpl and re-run the upgrade script to check for errors upgrade-script wanted to notify you.

Doing the above step meant that I was able to see the error causing the script to fail. The problem we had in common was the error reporting. The underlying problem may be different.

[kyle.vh]

I have this same problem. Not using WAMP setup, though.
I'm upgrading Drupal 5.x to 6.x and trying to take Civicrm with me from 2.0 to 2.1.
I get the same error. I'm going to try Deepak's solution.

[kyle.vh]

for what it's worth, I updated my base url, that was wrong. That fixed the fatal error. now I'm getting the civicrm failure:
"Database consistency check failed. FK constraint names not in the required format..." I'm going to look into that now.