CiviCRM Community Forums (archive)

*

News:

Have a question about CiviCRM?
Get it answered quickly at the new
CiviCRM Stack Exchange Q+A site
This forum was archived on 25 November 2017. Learn more.
How to get involved.
What to do if you think you've found a bug.



  • CiviCRM Community Forums (archive) »
  • Old sections (read-only, deprecated) »
  • Support »
  • Upgrading CiviCRM (Moderator: Deepak Srivastava) »
  • CiviCRM problem upgrading Drupal
Pages: [1]

Author Topic: CiviCRM problem upgrading Drupal  (Read 1944 times)

hallman

  • I post occasionally
  • **
  • Posts: 87
  • Karma: 10
CiviCRM problem upgrading Drupal
October 09, 2009, 01:29:20 pm
I'm upgrading Drupal from 5.20 to 6.14. I built a Drupal 6 site and tested it at drupal6.nccommunities.org.

On test.nccommunities.org, I disabled civicrm and then copied the database for test.nccommunities.org to drupal6 and got it working at drupal6.nccommunities.org with civicrm disabled and saved that database. I put the Drupal 6 modules on test.nccommunities.org and copied the Drupal 6 version of the database to the database for test.nccommunities.org. The site looks OK.

I enabled CiviCRM and get the following error messages:

Code: [Select]
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

I've got civicrm 2.2 installed.
update.php says it has 0 updates and then gives me the error messages above.

I found http://forum.civicrm.org/index.php?topic=4752.0, but I'm not upgrading CiviCRM. I'm using the same civicrm module that I was using with Drupal 5.

In CRM I copied:
 cp common/fatal.tpl error.tpl
and tried update.php again. But got the same error above.

The reason I disabled civicrm while testing drupal6 -- I originally had it enabled and got the error message above. Rather than trying to move civicrm to  a new site, I disabled it and then copied the database again.[/code]
« Last Edit: October 10, 2009, 08:25:57 am by hallman »
Judy Hallman

hallman

  • I post occasionally
  • **
  • Posts: 87
  • Karma: 10
more information
October 10, 2009, 08:36:23 am
I edited my original post to include the entire error message.

I get this error on every page -- for example http://test.nccommunities.org/admin/build/modules

/sites/default civicrm.settings.php contains:

Code: [Select]
define( 'CIVICRM_UF_DSN'           , 'mysql://drupal2:password@localhost/drupal2?new_link=true' );
define( 'CIVICRM_DSN'          , 'mysql://drupal2:passwordj@localhost/drupal2?new_link=true' );
$civicrm_root = '/home/drupal2/public_html/sites/all/modules/civicrm';
define( 'CIVICRM_TEMPLATE_COMPILEDIR', '/home/drupal2/public_html/files/civicrm/templates_c/' );
define( 'CIVICRM_UF_BASEURL'      , 'http://test.nccommunities.org/' );

/sites/test.nccommunities.org civicrm.settings.php contains:

Code: [Select]
define( 'CIVICRM_UF_DSN'           , 'mysql://drupal2:passwordj@localhost/drupal2?new_link=true' );
define( 'CIVICRM_DSN'          , 'mysql://drupal2:password@localhost/drupal2?new_link=true' );
$civicrm_root = '/home/drupal2/public_html/sites/all/modules/civicrm';
define( 'CIVICRM_TEMPLATE_COMPILEDIR', '/home/drupal2/public_html/files/civicrm/templates_c/' );
define( 'CIVICRM_UF_BASEURL'      , 'http://test.nccommunities.org/' );

select * from civicrm_domain; gives:

Code: [Select]
+----+---------------+-------------+------------+----------------+--------------+-------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+---------+--------------+
| id | name          | description | email_name | email_address  | email_domain | email_return_path | config_backend                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                   | version | loc_block_id |
+----+---------------+-------------+------------+----------------+--------------+-------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+---------+--------------+
|  1 | Domain Name 1 | NULL        | FIXME      | info@FIXME.ORG | FIXME.ORG    | NULL              | a:72:{s:11:"mapProvider";s:6:"Google";s:9:"mapAPIKey";s:86:"ABQIAAAAI7J6cOkN2Xn8fWEF0caRoBRTNs1_q7fP2ikSR7vnZVNklVRYlRSG4lBheljRj0MzjrT2PNBsoVJ--g";s:16:"enableComponents";a:3:{i:0;s:14:"CiviContribute";i:1;s:10:"CiviMember";i:2;s:9:"CiviEvent";}s:13:"userFramework";s:6:"Drupal";s:11:"initialized";i:0;s:15:"DAOFactoryClass";s:23:"CRM_Contact_DAO_Factory";s:17:"componentRegistry";O:18:"CRM_Core_Component":0:{}s:9:"inCiviCRM";b:0;s:8:"daoDebug";i:0;s:5:"debug";i:0;s:9:"backtrace";i:0;s:9:"smartyDir";N;s:10:"pluginsDir";N;s:11:"templateDir";N;s:12:"resourceBase";N;s:9:"uploadDir";s:47:"/home/drupal2/public_html/files/civicrm/upload/";s:14:"imageUploadDir";s:59:"/home/drupal2/public_html/files/civicrm/persist/contribute/";s:19:"customFileUploadDir";s:47:"/home/drupal2/public_html/files/civicrm/custom/";s:14:"imageUploadURL";s:63:"http://test.nccommunities.org/files/civicrm/persist/contribute/";s:12:"countryLimit";a:1:{i:0;s:4:"1228";}s:13:"provinceLimit";a:1:{i:0;s:4:"1228";}s:21:"defaultContactCountry";s:4:"1228";s:15:"defaultCurrency";s:3:"USD";s:10:"lcMessages";s:5:"en_US";s:18:"dateformatDatetime";s:20:"%B %E%f, %Y %l:%M %P";s:14:"dateformatFull";s:11:"%B %E%f, %Y";s:17:"dateformatPartial";s:5:"%B %Y";s:14:"dateformatYear";s:2:"%Y";s:14:"dateformatTime";s:8:"%l:%M %P";s:16:"dateformatQfDate";s:8:"%b %d %Y";s:20:"dateformatQfDatetime";s:20:"%b %d %Y, %I : %M %P";s:18:"dateformatMonthVar";s:1:"M";s:22:"datetimeformatMonthVar";s:1:"M";s:21:"datetimeformatHourVar";s:1:"h";s:15:"fiscalYearStart";a:2:{s:1:"M";i:1;s:1:"d";i:1;}s:11:"moneyformat";s:5:"%c %a";s:10:"lcMonetary";s:5:"en_US";s:15:"currencySymbols";s:0:"";s:21:"defaultCurrencySymbol";N;s:14:"gettextCodeset";s:5:"utf-8";s:13:"gettextDomain";s:7:"civicrm";s:10:"smtpServer";s:9:"localhost";s:8:"smtpPort";i:25;s:8:"smtpAuth";b:0;s:12:"smtpUsername";N;s:12:"smtpPassword";N;s:20:"userFrameworkVersion";d:5.70000000000000017763568394002504646778106689453125;s:27:"userFrameworkUsersTableName";s:5:"users";s:24:"userFrameworkResourceURL";s:56:"http://test.nccommunities.org/sites/all/modules/civicrm/";s:21:"userFrameworkFrontend";b:0;s:9:"mysqlPath";s:9:"/usr/bin/";s:17:"maxImportFileSize";i:1048576;s:13:"geocodeMethod";s:0:"";s:12:"mapGeoCoding";i:1;s:12:"versionCheck";b:1;s:9:"enableSSL";b:0;s:18:"fatalErrorTemplate";s:13:"CRM/error.tpl";s:17:"fatalErrorHandler";N;s:14:"legacyEncoding";s:12:"Windows-1252";s:17:"maxLocationBlocks";i:2;s:15:"captchaFontPath";s:25:"/usr/X11R6/lib/X11/fonts/";s:11:"captchaFont";s:17:"HelveticaBold.ttf";s:24:"includeAlphabeticalPager";i:1;s:20:"includeOrderByClause";i:1;s:15:"includeDomainID";i:1;s:13:"oldInputStyle";i:1;s:11:"includeDojo";i:1;s:14:"formKeyDisable";b:0;s:13:"verpSeparator";s:1:".";s:12:"mailerPeriod";i:180;s:16:"mailerSpoolLimit";i:0;s:16:"mailerBatchLimit";i:0;} | 2.0     |            1 |
+----+---------------+-------------+------------+----------------+--------------+-------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+---------+--------------+
1 row in set (0.03 sec)
« Last Edit: October 10, 2009, 08:38:32 am by hallman »
Judy Hallman

Donald Lobo

  • Administrator
  • I’m (like) Lobo ;)
  • *****
  • Posts: 15963
  • Karma: 470
    • CiviCRM site
  • CiviCRM version: 4.2+
  • CMS version: Drupal 7, Joomla 2.5+
  • MySQL version: 5.5.x
  • PHP version: 5.4.x
Re: CiviCRM problem upgrading Drupal
October 10, 2009, 10:24:39 am

hey judy:

It is a multi step process (since we've reworked the upgrade script)

1. first upgrade to drupal 6

2. download and upgrade to civicrm v2.0

3. download and upgrade to civicrm v2.1.x

4. download and upgrade to civicrm 3.0.x

we made some major improvements to the upgrade scrippts in 2.1.x and enabled incremental upgrades

I'm not sure if step 3 is needed, i just added that to make sure its safe.

Check: http://wiki.civicrm.org/confluence/display/CRMDOC22/Upgrade+Drupal+Sites+to+2.2

lobo
A new CiviCRM Q&A resource needs YOUR help to get started. Visit our StackExchange proposed site, sign up and vote on 5 questions

hallman

  • I post occasionally
  • **
  • Posts: 87
  • Karma: 10
Re: CiviCRM problem upgrading Drupal
October 10, 2009, 11:52:05 am
Ohhhh... I see. I confused myself. I thought I had CiviCRM 2.2 on both sites, but I don't. I have 2.2 on the Drupal 6 installation, but 2.0 on the Drupal 5 installation. So, yes, I do need to upgrade CiviCRM. No wonder. Thanks for your help.
Judy Hallman

freddavis

  • Guest
Re: CiviCRM problem upgrading Drupal
October 12, 2009, 04:17:54 am
Quote from: Donald Lobo on October 10, 2009, 10:24:39 am

hey judy:

It is a multi step process (since we've reworked the upgrade script)

1. first upgrade to drupal 6

2. download and upgrade to civicrm v2.0

3. download and upgrade to civicrm v2.1.x

4. download and upgrade to civicrm 3.0.x

we made some major improvements to the upgrade scrippts in 2.1.x and enabled incremental upgrades

I'm not sure if step 3 is needed, i just added that to make sure its safe.

Check: http://wiki.civicrm.org/confluence/display/CRMDOC22/Upgrade+Drupal+Sites+to+2.2

lobo



Thank you guys for this I have the same upgrade problem as judy. I was so lucky that I stumble on this thred.
Pages: [1]
  • CiviCRM Community Forums (archive) »
  • Old sections (read-only, deprecated) »
  • Support »
  • Upgrading CiviCRM (Moderator: Deepak Srivastava) »
  • CiviCRM problem upgrading Drupal

This forum was archived on 2017-11-26.