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) »
  • upgrade from 3.4.8 to 4.1.0 fails
Pages: [1]

Author Topic: upgrade from 3.4.8 to 4.1.0 fails  (Read 3380 times)

majovdh

  • I post occasionally
  • **
  • Posts: 58
  • Karma: 2
    • Chautaara VZW
  • CiviCRM version: 4.2.6
  • CMS version: drupal 7.17
  • MySQL version: 5.1.56
  • PHP version: 5.2.17
upgrade from 3.4.8 to 4.1.0 fails
February 16, 2012, 02:27:14 am
whe i try to run the upgrade script i get this message

Array

Then when i go to my site and click on civicrm i get following :

nitialization Error

Array
(
    [callback] => Array
        (
           
  • => CRM_Core_Error
    • [1] => simpleHandler
            )

       
Code: [Select]
=> -18
    [message] => DB Error: no such table
    [mode] => 16
    [debug_info] =>
SELECT name, group_name, value
FROM   civicrm_setting
WHERE  ( group_name = 'Directory Preferences'
OR       group_name = 'URL Preferences' )
 [nativecode=1146 ** Table 'chautaar_chautaaraCRM2.civicrm_setting' doesn't exist]
    [type] => DB_Error
    [user_info] =>
SELECT name, group_name, value
FROM   civicrm_setting
WHERE  ( group_name = 'Directory Preferences'
OR       group_name = 'URL Preferences' )
 [nativecode=1146 ** Table 'chautaar_chautaaraCRM2.civicrm_setting' doesn't exist]
    [to_string] => [db_error: message="DB Error: no such table" code=-18 mode=callback callback=CRM_Core_Error::simpleHandler prefix="" info="
SELECT name, group_name, value
FROM   civicrm_setting
WHERE  ( group_name = 'Directory Preferences'
OR       group_name = 'URL Preferences' )
 [nativecode=1146 ** Table 'chautaar_chautaaraCRM2.civicrm_setting' doesn't exist]"]
)

backTrace

/home/chautaar/public_html/sites/all/modules/civicrm/CRM/Core/Error.php, backtrace, 235
, simpleHandler,
/home/chautaar/public_html/sites/all/modules/civicrm/packages/PEAR.php, call_user_func, 931
/home/chautaar/public_html/sites/all/modules/civicrm/packages/DB.php, PEAR_Error, 968
/home/chautaar/public_html/sites/all/modules/civicrm/packages/PEAR.php, DB_Error, 564
/home/chautaar/public_html/sites/all/modules/civicrm/packages/DB/common.php, raiseError, 1903
/home/chautaar/public_html/sites/all/modules/civicrm/packages/DB/mysql.php, raiseError, 898
/home/chautaar/public_html/sites/all/modules/civicrm/packages/DB/mysql.php, mysqlRaiseError, 327
/home/chautaar/public_html/sites/all/modules/civicrm/packages/DB/common.php, simpleQuery, 1216
/home/chautaar/public_html/sites/all/modules/civicrm/packages/DB/DataObject.php, query, 2428
/home/chautaar/public_html/sites/all/modules/civicrm/packages/DB/DataObject.php, _query, 1614
/home/chautaar/public_html/sites/all/modules/civicrm/CRM/Core/DAO.php, query, 166
/home/chautaar/public_html/sites/all/modules/civicrm/CRM/Core/DAO.php, query, 897
/home/chautaar/public_html/sites/all/modules/civicrm/CRM/Core/BAO/Setting.php, executeQuery, 433
/home/chautaar/public_html/sites/all/modules/civicrm/CRM/Core/BAO/ConfigSetting.php, retrieveDirectoryAndURLPreferences, 334
/home/chautaar/public_html/sites/all/modules/civicrm/CRM/Core/Config.php, retrieve, 406
/home/chautaar/public_html/sites/all/modules/civicrm/CRM/Core/Config.php, _initVariables, 209
/home/chautaar/public_html/sites/all/modules/civicrm/drupal/civicrm.module, singleton, 272
/home/chautaar/public_html/sites/all/modules/civicrm_theme/civicrmtheme.module, civicrm_initialize, 7
, civicrmtheme_init,
/home/chautaar/public_html/includes/module.inc, call_user_func_array, 497
/home/chautaar/public_html/includes/common.inc, module_invoke_all, 2715
/home/chautaar/public_html/includes/bootstrap.inc, _drupal_bootstrap_full, 1206
/home/chautaar/public_html/includes/bootstrap.inc, _drupal_bootstrap, 1113
/home/chautaar/public_html/index.php, drupal_bootstrap, 15

any idea?

Kurund Jalmi

  • Administrator
  • I’m (like) Lobo ;)
  • *****
  • Posts: 4169
  • Karma: 128
    • CiviCRM
  • CiviCRM version: 4.x, future
  • CMS version: Drupal 7, Joomla 3.x
  • MySQL version: 5.5.x
  • PHP version: 5.4.x
Re: upgrade from 3.4.8 to 4.1.0 fails
February 16, 2012, 03:08:33 am
Are you following steps mentioned here: http://wiki.civicrm.org/confluence/display/CRMDOC41/Installation+and+Upgrades

Kurund
Found this reply helpful? Support CiviCRM

majovdh

  • I post occasionally
  • **
  • Posts: 58
  • Karma: 2
    • Chautaara VZW
  • CiviCRM version: 4.2.6
  • CMS version: drupal 7.17
  • MySQL version: 5.1.56
  • PHP version: 5.2.17
Re: upgrade from 3.4.8 to 4.1.0 fails
February 16, 2012, 04:08:27 am
Hey Krurund,

I'm following all steps in that file, i followed the link for the announcement page.

Majo

Kurund Jalmi

  • Administrator
  • I’m (like) Lobo ;)
  • *****
  • Posts: 4169
  • Karma: 128
    • CiviCRM
  • CiviCRM version: 4.x, future
  • CMS version: Drupal 7, Joomla 3.x
  • MySQL version: 5.5.x
  • PHP version: 5.4.x
Re: upgrade from 3.4.8 to 4.1.0 fails
February 16, 2012, 04:40:36 am
On which url do you get above error? 

Do you get upgrade screen when you go to <site_url>/civicrm/upgrade?reset=1 ?

Kurund
Found this reply helpful? Support CiviCRM

majovdh

  • I post occasionally
  • **
  • Posts: 58
  • Karma: 2
    • Chautaara VZW
  • CiviCRM version: 4.2.6
  • CMS version: drupal 7.17
  • MySQL version: 5.1.56
  • PHP version: 5.2.17
Re: upgrade from 3.4.8 to 4.1.0 fails
February 16, 2012, 07:14:39 am
Kurund,

First if i run the upgrade script i see the normal template wich only says ' array '

Then when i ho on the site again and want to go to civicrm i get a blank screen with allthe text above

MajO
« Last Edit: February 16, 2012, 09:44:41 am by majovdh »

CatorgHans

  • I post frequently
  • ***
  • Posts: 157
  • Karma: 5
  • CiviCRM version: 4.4
  • CMS version: drupal
Re: upgrade from 3.4.8 to 4.1.0 fails
February 16, 2012, 10:00:19 am
yep, I have exactly the same

majovdh

  • I post occasionally
  • **
  • Posts: 58
  • Karma: 2
    • Chautaara VZW
  • CiviCRM version: 4.2.6
  • CMS version: drupal 7.17
  • MySQL version: 5.1.56
  • PHP version: 5.2.17
Re: upgrade from 3.4.8 to 4.1.0 fails
February 16, 2012, 10:01:41 am
ok found it apprently i forgot to change the

define( 'CIVICRM_UF'               , 'Drupal'        );

to

define( 'CIVICRM_UF'               , 'Drupal6'        );

majo

CatorgHans

  • I post frequently
  • ***
  • Posts: 157
  • Karma: 5
  • CiviCRM version: 4.4
  • CMS version: drupal
Re: upgrade from 3.4.8 to 4.1.0 fails
February 16, 2012, 10:09:19 am
thanks.

I propose to place this in the red "warning" box, because it is so different from all other upgrades.

Kurund Jalmi

  • Administrator
  • I’m (like) Lobo ;)
  • *****
  • Posts: 4169
  • Karma: 128
    • CiviCRM
  • CiviCRM version: 4.x, future
  • CMS version: Drupal 7, Joomla 3.x
  • MySQL version: 5.5.x
  • PHP version: 5.4.x
Re: upgrade from 3.4.8 to 4.1.0 fails
February 16, 2012, 11:02:26 am
It is mentioned here: http://wiki.civicrm.org/confluence/display/CRMDOC41/Upgrade+Drupal+Sites+to+4.1+-+Drupal+6

Kurund
Found this reply helpful? Support CiviCRM

CatorgHans

  • I post frequently
  • ***
  • Posts: 157
  • Karma: 5
  • CiviCRM version: 4.4
  • CMS version: drupal
Re: upgrade from 3.4.8 to 4.1.0 fails
February 16, 2012, 11:16:39 am
yep, that should be noticed

fen

  • I post frequently
  • ***
  • Posts: 216
  • Karma: 13
    • CivicActions
  • CiviCRM version: 3.3-4.3
  • CMS version: Drupal 6/7
  • MySQL version: 5.1/5.5
  • PHP version: 5.3/5.4
Re: upgrade from 3.4.8 to 4.1.0 fails
February 19, 2012, 04:18:22 pm
I had this issue (no such table: civicrm_settings) on upgrade from v3.3.6 -> v4.1.0 on Drupal 6 (following all instructions).  So I patched my CiviCRM v4.1.0 with changesets 38863 and 38864 (from CRM-9690) and get more of the same:
Code: [Select]
(
    [callback] =&gt; Array
        (
            [0] =&gt; CRM_Core_Error
            [1] =&gt; handle
        )
    [code] =&gt; -18
    [message] =&gt; DB Error: no such table
    [mode] =&gt; 16
    [debug_info] =&gt; SELECT *
 FROM civicrm_setting
 WHERE (  civicrm_setting.group_name  = 'Multi Site Preferences' )  AND (  civicrm_setting.domain_id = 1 ) AND (  civicrm_setting.is_domain = 1 )
 
 [nativecode=1146 ** Table 'example_civicrm.civicrm_setting' doesn't exist]
This is from a working, D6 version with all CiviCRM related modules disabled, define('CIVICRM_UF', 'Drupal6'); and all other upgrade instructions followed.

fen

  • I post frequently
  • ***
  • Posts: 216
  • Karma: 13
    • CivicActions
  • CiviCRM version: 3.3-4.3
  • CMS version: Drupal 6/7
  • MySQL version: 5.1/5.5
  • PHP version: 5.3/5.4
Re: upgrade from 3.4.8 to 4.1.0 fails [SOLVED]
February 19, 2012, 05:58:05 pm
I haven't got a patch, but I managed to get the upgrade to work by disabling the Drupal 'adminrole' module.  Here's the hint from the output of drush civicrm-upgrade-db:
Code: [Select]
> drush civicrm-upgrade-db
Starting with v3.3.6 -> v4.1.0 upgrade ..
Drush command terminated abnormally due to an unrecoverable error.                                                                [error]
<p>backTrace</p><p><pre>/home/fen/workspace/civicrm/v4.1.0-d6-sedona/CRM/Core/Error.php, backtrace, 159
, handle,
/home/fen/workspace/civicrm/v4.1.0-d6-sedona/packages/PEAR.php, call_user_func, 931
/home/fen/workspace/civicrm/v4.1.0-d6-sedona/packages/DB.php, PEAR_Error, 968
/home/fen/workspace/civicrm/v4.1.0-d6-sedona/packages/PEAR.php, DB_Error, 564
/home/fen/workspace/civicrm/v4.1.0-d6-sedona/packages/DB/common.php, raiseError, 1903
/home/fen/workspace/civicrm/v4.1.0-d6-sedona/packages/DB/mysql.php, raiseError, 898
/home/fen/workspace/civicrm/v4.1.0-d6-sedona/packages/DB/mysql.php, mysqlRaiseError, 327
/home/fen/workspace/civicrm/v4.1.0-d6-sedona/packages/DB/common.php, simpleQuery, 1216
/home/fen/workspace/civicrm/v4.1.0-d6-sedona/packages/DB/DataObject.php, query, 2428
/home/fen/workspace/civicrm/v4.1.0-d6-sedona/packages/DB/DataObject.php, _query, 442
/home/fen/workspace/civicrm/v4.1.0-d6-sedona/CRM/Core/BAO/Setting.php, find, 173
/home/fen/workspace/civicrm/v4.1.0-d6-sedona/CRM/Core/Permission.php, getItem, 575
/home/fen/workspace/civicrm/v4.1.0-d6-sedona/CRM/Core/Permission.php, isMultisiteEnabled, 403
/home/fen/workspace/civicrm/v4.1.0-d6-sedona/drupal/civicrm.module, basicPermissions, 142
, civicrm_perm,
/home/fen/workspace/drupal-6/includes/module.inc, call_user_func_array, 482
/home/fen/workspace/sedona.6/modules/contrib-stable/adminrole/adminrole.module, module_invoke_all, 80
/home/fen/workspace/sedona.6/modules/contrib-stable/adminrole/adminrole.module, adminrole_update_permissions, 65
, adminrole_node_type,
/home/fen/workspace/drupal-6/includes/module.inc, call_user_func_array, 482
/home/fen/workspace/drupal-6/modules/node/node.module, module_invoke_all, 500
/home/fen/workspace/drupal-6/modules/node/node.module, node_type_save, 464
/home/fen/workspace/drupal-6/includes/common.inc, node_types_rebuild, 3771
/home/fen/workspace/civicrm/v4.1.0-d6-sedona/CRM/Upgrade/Incremental/php/ThreeFour.php, drupal_flush_all_caches, 343
/home/fen/workspace/civicrm/v4.1.0-d6-sedona/CRM/Upgrade/Page/Upgrade.php, upgrade_3_4_7, 265
/home/fen/workspace/civicrm/v4.1.0-d6-sedona/drupal/drush/civicrm.drush.inc, run, 411
, civicrm_upgrade_db,
/home/fen/src/drush-4.4/includes/command.inc, call_user_func_array, 204
/home/fen/src/drush-4.4/drush.php, drush_dispatch, 101My hypothesis is that as the CiviCRM upgrade progresses, it adds some Drupal permissions that trigger the adminrole module to do its thing, but since the civicrm_settings table hasn't been created yet, it fails.

mirrorstage

  • I post occasionally
  • **
  • Posts: 57
  • Karma: 1
  • CiviCRM version: 4.6.7
  • CMS version: Drupal 6.37
  • MySQL version: 5.6.23
  • PHP version: 5.4.42
Re: upgrade from 3.4.8 to 4.1.0 fails
March 17, 2012, 11:28:28 am
I followed all the upgrade instructions and am also receiving the "Fatal DB error, exiting, seems like your schema does not have civicrm_setting table" error.

I am not sure how to disable the Drupal 'adminrole' module, as fen mentions above. Please advise how to proceed.

Thanks!

Kurund Jalmi

  • Administrator
  • I’m (like) Lobo ;)
  • *****
  • Posts: 4169
  • Karma: 128
    • CiviCRM
  • CiviCRM version: 4.x, future
  • CMS version: Drupal 7, Joomla 3.x
  • MySQL version: 5.5.x
  • PHP version: 5.4.x
Re: upgrade from 3.4.8 to 4.1.0 fails
March 20, 2012, 10:23:34 am
Quote
I am not sure how to disable the Drupal 'adminrole' module, as fen mentions above. Please advise how to proceed.
Go to <your site>admin/modules/list  and disable ( uncheck )  'adminrole' module

Hth
Kurund
Found this reply helpful? Support CiviCRM

mirrorstage

  • I post occasionally
  • **
  • Posts: 57
  • Karma: 1
  • CiviCRM version: 4.6.7
  • CMS version: Drupal 6.37
  • MySQL version: 5.6.23
  • PHP version: 5.4.42
Re: upgrade from 3.4.8 to 4.1.0 fails
March 20, 2012, 10:29:54 am
Seems I do not have an Adminrole module.
Pages: [1]
  • CiviCRM Community Forums (archive) »
  • Old sections (read-only, deprecated) »
  • Support »
  • Upgrading CiviCRM (Moderator: Deepak Srivastava) »
  • upgrade from 3.4.8 to 4.1.0 fails

This forum was archived on 2017-11-26.