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) »
  • A non-recoverable error has occurred. DB Error: no such table 'civicrm_setting'
Pages: [1]

Author Topic: A non-recoverable error has occurred. DB Error: no such table 'civicrm_setting'  (Read 2297 times)

shashikant

  • I post occasionally
  • **
  • Posts: 30
  • Karma: 0
  • CiviCRM version: civicrm 4.1.3
  • CMS version: Drupal 6.26
  • MySQL version: Mysql 5.1.56
  • PHP version: PHP Version 5.3.6
A non-recoverable error has occurred. DB Error: no such table 'civicrm_setting'
July 05, 2012, 11:04:26 pm
Hi,
I am having website on civicrm 3.2.5 and drupal 6.26 and i am trying to upgrade website from civicrm 3.2.5 to civicrm 4.1.3
For upgrading website I am following instruction from
URL: http://wiki.civicrm.org/confluence/display/CRMDOC41/Upgrade+Drupal+Sites+to+4.1+-+Drupal+6

Till  step 7. Unpack the latest package and verify permissions (step from url above )
Everything is fine
When i am coming to step 8. Run the Upgrade script (step from url above )
on my site url i.e.  <my_drupal_home> i am getting error " Fatal DB error, exiting, seems like your schema does not have civicrm_setting table "
and when i goto url http://<my_drupal_home>/civicrm/upgrade?reset=1

and If i click on  " Upgrade now " button  I am getting message like

Sorry. A non-recoverable error has occurred.
DB Error: no such table
Return to home page.

Code: [Select]
Additional Details:
Array
(
    [callback] => Array
        (
            [0] => CRM_Core_Error
            [1] => handle
        )

    [code] => -18
    [message] => DB Error: no such table
    [mode] => 16
    [debug_info] => SELECT *
 FROM civicrm_setting
 
 WHERE (  civicrm_setting.group_name  = 'Mailing Preferences' )  AND (  civicrm_setting.domain_id = 1 ) AND (  civicrm_setting.is_domain = 1 )
 
 
 
 [nativecode=1146 ** Table 'civicrmv3.civicrm_setting' doesn't exist]
    [type] => DB_Error
    [user_info] => SELECT *
 FROM civicrm_setting
 
 WHERE (  civicrm_setting.group_name  = 'Mailing Preferences' )  AND (  civicrm_setting.domain_id = 1 ) AND (  civicrm_setting.is_domain = 1 )
 
 
 
 [nativecode=1146 ** Table 'civicrmv3.civicrm_setting' doesn't exist]
    [to_string] => [db_error: message="DB Error: no such table" code=-18 mode=callback callback=CRM_Core_Error::handle prefix="" info="SELECT *
 FROM civicrm_setting
 
 WHERE (  civicrm_setting.group_name  = 'Mailing Preferences' )  AND (  civicrm_setting.domain_id = 1 ) AND (  civicrm_setting.is_domain = 1 )
 
 
 
 [nativecode=1146 ** Table 'civicrmv3.civicrm_setting' doesn't exist]"]
)

Please help me to upgrade from civicrm 3.2.5 to civicrm 4.1.3

Hershel

  • Forum Godess / God
  • I’m (like) Lobo ;)
  • *****
  • Posts: 4640
  • Karma: 176
    • CiviHosting
  • CiviCRM version: Latest
  • CMS version: Mostly WordPress and Drupal
Re: A non-recoverable error has occurred. DB Error: no such table 'civicrm_setting'
July 08, 2012, 05:29:38 am
This issue has been reported and I think you need to try do incremental upgrades. Perhaps first go to CiviCRM 3.3 and then 4.0 and then 4.1.
CiviHosting and CiviOnline -- The CiviCRM hosting experts, since 2007

See here for the official: What to do if you think you've found a bug.

Klyntone

  • I’m new here
  • *
  • Posts: 12
  • Karma: 0
  • is this thing on...
    • clinton.tech
  • CiviCRM version: var 3.2 to 4.3
  • CMS version: drupal 6 and 7
  • MySQL version: 5.1.68-cll
  • PHP version: 5.3.13
Re: A non-recoverable error has occurred. DB Error: no such table 'civicrm_setting'
February 01, 2014, 08:29:25 pm
shashikant, did you work this out, is there a 4.0 version compatible with D6??

any help would be much appreciated am trying update from 3.4 t0 4.1

shashikant

  • I post occasionally
  • **
  • Posts: 30
  • Karma: 0
  • CiviCRM version: civicrm 4.1.3
  • CMS version: Drupal 6.26
  • MySQL version: Mysql 5.1.56
  • PHP version: PHP Version 5.3.6
Re: A non-recoverable error has occurred. DB Error: no such table 'civicrm_setting'
February 17, 2014, 01:09:41 am
Hi Klyntone,
I was able to update my civicrm but i dont remember now.
It was problem with civicrm 4.0 or 4.1
Try upgrading to next version directly.
skip upgrading to 4.0 or 4.1 where you are getting DB Error: no such table 'civicrm_setting'

Eileen

  • Forum Godess / God
  • I’m (like) Lobo ;)
  • *****
  • Posts: 4195
  • Karma: 218
    • Fuzion
Re: A non-recoverable error has occurred. DB Error: no such table 'civicrm_setting'
February 17, 2014, 12:51:15 pm
D6 is compatible with releases up to 3.4 and from 4.1 onwards. 4.0 is the d7 equivalent of 3.4.

The important thing to be aware of is that from 4.1 onwards you need to alter civicrm.settings.php & set the UFNAME to 'Drupal6' once you have 4.1 or greater codebase in place.

So, basicaly

ReleaseD6 UF NAMED7 UF Name
3.4Drupaln/a
4.0n/aDrupal
4.1Drupal6Drupal
4.2Drupal6Drupal
4.3Drupal6Drupal
4.4Drupal6Drupal

So, if you are on 3.4 then you upgrade to 4.1 NOT 4.0 UNLESS you are also upgrading to D7
« Last Edit: February 17, 2014, 12:53:03 pm by Eileen »
Make today the day you step up to support CiviCRM and all the amazing organisations that are using it to improve our world - http://civicrm.org/contribute

Pages: [1]
  • CiviCRM Community Forums (archive) »
  • Old sections (read-only, deprecated) »
  • Support »
  • Upgrading CiviCRM (Moderator: Deepak Srivastava) »
  • A non-recoverable error has occurred. DB Error: no such table 'civicrm_setting'

This forum was archived on 2017-11-26.