CiviCRM Community Forums (archive)

Running drupal 5.7.  Upgrading from 1.9 to 2.0.4.  I came into the project a bit late and wanted to get it upgrade.  I got to the last step and got an error regarding history failure.

Since the failure, I only had the files backed up.  Didn't realize that the civicrm db was in another area till it was too late.  So if I put the 2.0.4 files on the drupal site, I get a lot of errors.  If I run the 1.9 files, I get some errors.

With the db tables left in from the failed install and running the 1.9 files, my default civicrm page shows:

Sorry. A non-recoverable error has occurred.

DB Error: no such table

Database Error Code: Table 'jewishi_civicrm.civicrm_component' doesn't exist, 1146


But I'm able to see other areas of the civicrm, like members, etc.

When I put the 2.0.4 files in, I get errors like:

warning: Invalid argument supplied for foreach() in /sites/all/modules/civicrm/CRM/Core/Menu.php on line 347. 

and

DB Error: no such table

Database Error Code: Table 'sitename_civicrm.civicrm_component' doesn't exist, 1146

You are at a stage where its easier to convert your db to 2.0.4 than bringing it back to 1.9.

You will need to follow the steps / process done at last step which is in the file - CiviCRM/CRM/Upgrade/TwoZero/Form/Step6.php. If summarized the steps are -
1. Execute / import  the file - CiviCRM/CRM/Upgrade/TwoZero/sql/others.mysql in your db.
2. Execute the query in the file - CiviCRM/CRM/Upgrade/TwoZero/Form/Step6.php, line - 72 to 88.
3. Execute / import  the file - CiviCRM/CRM/Upgrade/TwoZero/sql/drop.mysql in your db.

If you know / have the error you encountered at last step, you will only need to do the processing from the point of failure.

Note:
1. Make sure you take the backup of db at current stage before trying the above steps.
2. Steps may not be as easy as sounds but possible.
3. If things look difficult, not a bad idea to hire someone.