With the success of upgrading my first Drupal site so I thought maybe I should do upgrade on my other Drupal site. I was in for a long night and unsuccessful upgrade but I did figure out a way to recover from the failure upgrade and I decide to write this article so other will be able to benefit from my finding.
First of all you will more than likely to get something about “blocked_ips” and that is because you were at one point did the upgrade and your settings.php has this below:
$databases = array (
'driver' => 'mysql',
'database' => ‘’,
'username' => ‘’,
'password' => ‘’,
'host' => 'localhost',
'port' => '',
'prefix' => '',
Don’t panic, remove the above lines from your settings.php then you can continue your upgrade attempt.
That is not all; you might get a ton of other errors! Many of which are related to failing update.php attempt.
Run this MySQL script will clean up most of the basic show stopper on your upgrade attempt.
ALTER TABLE `menu_router` DROP `delivery_callback` ,
DROP `context` ,
DROP `theme_callback` ,
DROP `theme_arguments` ;
ALTER TABLE `url_alias` DROP `source` ,
DROP `alias` ;
DROP TABLE `role_permission`
DROP INDEX system_list ON system;
drop system_list index in system
Once you get past some update you might get some more errors and these are as follow:
Failed: DatabaseSchemaObjectExistsException: Cannot rename node_revisions to node_revision: table node_revision already exists. in DatabaseSchema_mysql->renameTable() (line 307 of /home/user/public_html/d7/includes/database/mysql/schema.inc).
Failed: DatabaseSchemaObjectExistsException: Table tracker_node already exists. in DatabaseSchema->createTable() (line 657 of /home/user/public_html/d7/includes/database/schema.inc).
Go through the list and remove the field or table where it said “already exists” then you should be a step closer in your upgrade attempt.
Now is the big tip: The easiest in the upgrade to Drupal 7 is to have a Drupal 6 install, set your template to be “Garland” and turn off all none core modules and set your “files” to be “default” before you even attempt to upgrade to Drupal 7. Once you are able to get past the Drupal 7 update.php then you can go in and do the configuration to fit your site the way you want.
One other thing, not all your modules might be available or might not work the same way like Drupal 6 so it will take much more time to go through more testing and finding, etc.