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) »
  • Database check failed and Fatal DB error
Pages: [1]

Author Topic: Database check failed and Fatal DB error  (Read 4288 times)

TJH43

  • I’m new here
  • *
  • Posts: 24
  • Karma: 0
  • CiviCRM version: 4.4.5
  • CMS version: Drupal 7.27
  • MySQL version: 5.5.37
  • PHP version: 5.3.10
Database check failed and Fatal DB error
May 15, 2012, 06:27:38 pm
Upgrading from Drupal 6.26 to 7.14 and from CiviCRM 3.2 to 4.1

Ran the Upgrade script and got ‘page not found’.  I then followed the ‘page not found’ trouble shooting guide.  When saving the /admin/modules/list/confirm configuration with CiviCRM enabled I got a fatal error.  I tried a second time and was able to rum the Upgrade script.  This resulted in a non-recoverable error ‘Database check failed – the database looks to have been partially upgraded.’  Troubleshooting guidelines suggest ‘Download and run Database Troubleshooting Tools.  The Database Troubleshooting Tools page has a warning: “This tool does not work with the current stable version of CiviCRM”

Also, now enabling the Administration Menu results in

“Fatal DB error, exiting, seems like your schema does not have civicrm_setting table.”

I am looking for any suggestions.

Hershel

  • Forum Godess / God
  • I’m (like) Lobo ;)
  • *****
  • Posts: 4640
  • Karma: 176
    • CiviHosting
  • CiviCRM version: Latest
  • CMS version: Mostly WordPress and Drupal
Re: Database check failed and Fatal DB error
May 16, 2012, 05:35:51 am
I hope you have a backup of your CiviCRM database. Best thing is to:

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.
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.

TJH43

  • I’m new here
  • *
  • Posts: 24
  • Karma: 0
  • CiviCRM version: 4.4.5
  • CMS version: Drupal 7.27
  • MySQL version: 5.5.37
  • PHP version: 5.3.10
Re: Database check failed and Fatal DB error
May 18, 2012, 10:31:51 pm
Thanks.  That worked.  I had some custom field tables I will now also try to recover.

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: Database check failed and Fatal DB error
February 01, 2014, 08:25:02 pm
getting th same error going from 3.4 to 4.1, looks like i'm gonna have to do this also....

where it says,  4. Run the CiviCRM installer ( sites/all/modules/civicrm/install/index.php )

is that an instruction to reinstall 3.4 then drop those tables replace them with th old 3.4 tables then over write 3.4 with 4.1 and run civicrm/upgrade?reset=1

or am i installing 4.1 then drop those tables replace them with th old 3.4 tables then run civicrm/upgrade?reset=1

Thank you for any help.
Pages: [1]
  • CiviCRM Community Forums (archive) »
  • Old sections (read-only, deprecated) »
  • Support »
  • Upgrading CiviCRM (Moderator: Deepak Srivastava) »
  • Database check failed and Fatal DB error

This forum was archived on 2017-11-26.