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) »
  • Fatal DB error, exiting, seems like your schema does not have civicrm_setting
Pages: [1]

Author Topic: Fatal DB error, exiting, seems like your schema does not have civicrm_setting  (Read 1123 times)

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
Fatal DB error, exiting, seems like your schema does not have civicrm_setting
February 05, 2014, 08:27:46 pm
running an update from 3.8 to 4.1 on a drupal 6 site

I have found some instruction courtesy of Hershel to solve this:

1. Disable CiviCRM module
2. Remove old CiviCRM database (or tables)
3. Remove sites/default/civicrm.settings.php
4. Run the CiviCRM installer ( sites/all/modules/civicrm/install/index.php )
5. Remove new CiviCRM database (or tables)
6. Replace CiviCRM database (or tables) with your backup
7. Run the upgrader civicrm/upgrade?reset=1

This will get a clean fresh install and thus a good sites/default/civicrm.settings.php file and then you can run the upgrader using your old [tables.

Can someone clarify for me where th instruction says "4. Run the CiviCRM installer ( sites/all/modules/civicrm/install/index.php )"

Do i run th install for 3.8 or 4.1 then drop th tables and replace with with backup?


Thanks for any help

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: Fatal DB error, exiting, seems like your schema does not have civicrm_setting
February 05, 2014, 10:36:28 pm
Quote
Do i run th install for 3.8 or 4.1 then drop th tables and replace with with backup?
Installer will create new db, so it should be run for 4.1

Kurund
Found this reply helpful? Support CiviCRM

Hershel

  • Forum Godess / God
  • I’m (like) Lobo ;)
  • *****
  • Posts: 4640
  • Karma: 176
    • CiviHosting
  • CiviCRM version: Latest
  • CMS version: Mostly WordPress and Drupal
Re: Fatal DB error, exiting, seems like your schema does not have civicrm_setting
February 06, 2014, 09:24:15 am
Quote from: Klyntone on February 05, 2014, 08:27:46 pm
Do i run th install for 3.8 or 4.1 then drop th tables and replace with with backup?

Yes, run the install with 4.1 and then I would say delete entire DB (not just drop the tables) and then recreate it and then replace with your backup. Then, immediately, run the upgrader to upgrade to 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: Fatal DB error, exiting, seems like your schema does not have civicrm_setting
February 08, 2014, 04:12:08 am
Thanks Kurund and and in particular Hershel, your assistance has been most helpful, even though i was not patient enough to wait for your replies.

I ended up doing this;

Exported CiviCRM 3.8 Database
Disabled CiviCRM module
Dropped old CiviCRM tables
Removed sites/default/civicrm.settings.php
Replaced 3.8 civicrm core with 4.1
Ran the CiviCRM installer for 4.1 ( sites/all/modules/civicrm/install/index.php )
Exported CiviCRM 4.1 Database table civicrm_setting
Dropped CiviCRM 4.1 tables
Imported CiviCRM 3.8 .sql and civicrm_setting table .sql (without th civicrm_setting table i was still getting " Fatal DB error, exiting, seems like your schema does not have civicrm_setting" i could go from working to not working by just adding and removing that table)

At this point things weren't working very well, version on bottom of civi pages was 3.8 module description was 3.8 module check box was 4.1, civi menu was not sowing up dashboard giving error about enabling javascript.

Could not run upgrader it was saying already 4.1

So I deleted th 4.1 core files from th sever and replaced them with 4.2 then run the upgrader civicrm/upgrade?reset=1

Now i have a working version of 4.2

(there seems to be no emoticon to illustrate relief)

Pages: [1]
  • CiviCRM Community Forums (archive) »
  • Old sections (read-only, deprecated) »
  • Support »
  • Upgrading CiviCRM (Moderator: Deepak Srivastava) »
  • Fatal DB error, exiting, seems like your schema does not have civicrm_setting

This forum was archived on 2017-11-26.