By Peterjabz on

Hi all

Please help. Had to update Drupal for one of our customers and had a developer working on it. He walked away and left the database not updated to drupal 7.

I ran a database update and got the following errors, any help with fixing this?

comment module
Update #7007
• Failed: DatabaseSchemaObjectExistsException: Cannot add index comment_created to table comment: index already exists. in DatabaseSchema_mysql->addIndex() (line 437 of/home/naszeess/public_html/documentboss.com/includes/database/mysql/schema.inc).
field_sql_storage module
Update #7001
• Failed: PDOException: SQLSTATE[42S02]: Base table or view not found: 1146 Table 'naszeess_docboss3.field_config_entity_type' doesn't exist: SELECT etid, type FROM {field_config_entity_type}; Array ( ) in field_sql_storage_update_7001() (line 108 of/home/naszeess/public_html/documentboss.com/modules/field/modules/field_sql_storage/field_sql_storage.install).

Please help asap.

Thanks
Peter

⋅ Categories: Drupal 7.x

Comments

vm’s picture

vm commented

The problem is that modules were left enabled when the update was ran. Much has changed from D6 to D7. To correct, you must roll back to a D6 database and D6 file system, as you have a partially updated database.

Modules that are in use that don't have a D7 version can be disabled, then uninstalled.

Disable other modules

D6 -> D7 is not a minor update. You should not be performing this task on the production server.

Peterjabz’s picture

Peterjabz commented

Thanks for that. The bloody developer who updated to D7 is so fustrating.

How do I roll back to D6? I have looked at downgrading to D6 and it looks very complicated and a lot of manual work which may cause even more problems then I have

Thanks
Pete

vm’s picture

vm commented

drop all tables in the current database
import the D6 backed up database
remove D7 files and folders
upload backed up D6 files and folders

The above only works if you have back ups of the D6 database and D6 files/folders from before the upgrade was attempted. If you do not, then you're in a bit of a pickle and will likely have to reproduce the site.

Peterjabz’s picture

Peterjabz commented

AHHHHHHH.. lol

Is this the only way to solve this problem? WHy is Drupal so complicated to upgrade

THanks again for you response

vm’s picture

vm commented

It's the only way that I can see to solve the problem based on researching the errors with google.

Part of the complexity of upgrading drupal from one major version to the next is that there is no backward compatibility. There were massive changes in API's between Drupal 6 and Drupal 7. As such there were specific steps that needed to be taken and the UPGRADE.txt file was to be used as it should be in every UPGRADE/UPDATE.