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) »
  • How to recover from a partially upgraded database
Pages: [1]

Author Topic: How to recover from a partially upgraded database  (Read 738 times)

sraisz

  • I post occasionally
  • **
  • Posts: 52
  • Karma: 0
    • sambandha.net
  • CiviCRM version: 3.3.5
  • CMS version: Drupal 6
How to recover from a partially upgraded database
July 14, 2010, 11:30:44 am
I tried running the drush civicrm utils to upgrade from 3.1.5 to 3.2.beta3

unfortunately the upgrade did not complete and even more unfortunately the promised backup that the drush util claimed to have made did not exist, so I could not restore the db.

now I am stuck with the partial upgrade situation.

I tried running the civicrm_db_integrity.php tool and got the following error:

Code: [Select]
Got version 3.1.4.upgrade from civicrm_domain.version
FATAL: Don't recognize version 3.1.4.upgrade

In a similar post in this forum, it was recommended to unpack the upgrade script and run each step independently. Where do I find this script?

Any other suggestions?

CiviTeacher.com

  • I live on this forum
  • *****
  • Posts: 1282
  • Karma: 118
    • CiviTeacher
  • CiviCRM version: 3.4 - 4.5
  • CMS version: Drupal 6&7, Wordpress
  • MySQL version: 5.1 - 5.5
  • PHP version: 5.2 - 5.4
Re: How to recover from a partially upgraded database
July 14, 2010, 10:54:33 pm
It doesn't make sense to me that if you tried upgrading from 3.1.5 to 3.2.beta that your error would reference 3.1.4.  Are you positive your upgrade to 3.1.5 was completed in the first place?

Tough luck about your drush backup, but I don't trust my backups (or much else) to drush - do backups my hand with mysqldump or phpmyadmin.

For database integrity, get the 3.1.5 (or most recent reliable version that you know was working) schema and load your old data into the schema like this....follow these instructions:
http://wiki.civicrm.org/confluence/display/CRMUPCOMING/Ensuring+Schema+Integrity+on+Upgrades


Try CiviTeacher: the online video tutorial CiviCRM learning library.

sraisz

  • I post occasionally
  • **
  • Posts: 52
  • Karma: 0
    • sambandha.net
  • CiviCRM version: 3.3.5
  • CMS version: Drupal 6
Re: How to recover from a partially upgraded database
July 15, 2010, 09:46:20 am
Yes, I was confused by why it says 3.14 upgrade. As you say, the previous upgrade may not have completed.

I will try rebuilding the DB as you suggested and doing the upgrade again.

Thanks
Pages: [1]
  • CiviCRM Community Forums (archive) »
  • Old sections (read-only, deprecated) »
  • Support »
  • Upgrading CiviCRM (Moderator: Deepak Srivastava) »
  • How to recover from a partially upgraded database

This forum was archived on 2017-11-26.