Everything was going well until update.php finished... It listed many many Failed Queries. Following are the first few sections... I can access my DB with PHPMyAdmin and when I attempted to run the failed queries manually through the PHPMyAdmin interface, I received errors like:
#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '{blocks} DROP path' at line 1
I feel weak and afraid. Help.
+++++++++++++
Update #110
* DROP TABLE {search_index}
* CREATE TABLE {search_index} ( word varchar(50) NOT NULL default '', sid int unsigned NOT NULL default '0', type varchar(16) default NULL, fromsid int unsigned NOT NULL default '0', fromtype varchar(16) default NULL, score int unsigned default NULL, KEY sid (sid), KEY fromsid (fromsid), KEY word (word) )
* Failed: CREATE TABLE {search_total} ( word varchar(50) NOT NULL default '', count int unsigned default NULL, PRIMARY KEY word (word) )
* Failed: ALTER TABLE {blocks} DROP path
* Failed: ALTER TABLE {blocks} ADD visibility tinyint NOT NULL
* Failed: ALTER TABLE {blocks} ADD pages text NOT NULL
* DELETE FROM {variable} WHERE name = 'node_cron_last'
* UPDATE {blocks} SET status = 1, custom = 2 WHERE status = 0 AND custom = 1
Update #111
* DELETE FROM {variable} WHERE name LIKE 'throttle_%'
* Failed: ALTER TABLE {sessions} ADD PRIMARY KEY sid (sid)
Update #112
* Failed: CREATE TABLE {flood} ( event varchar(64) NOT NULL default '', hostname varchar(128) NOT NULL default '', timestamp int NOT NULL default '0' );
Update #113
* Failed: ALTER TABLE {accesslog} ADD aid int NOT NULL auto_increment, ADD PRIMARY KEY (aid)
Update #114
* CREATE TABLE {queue} ( nid int unsigned NOT NULL, uid int unsigned NOT NULL, vote int NOT NULL default '0', PRIMARY KEY (nid, uid) )
* Failed: ALTER TABLE {node} DROP votes
* Failed: ALTER TABLE {node} DROP score
* Failed: ALTER TABLE {node} DROP users
Update #115
* No queries
Comments
OK, so a little follow up,
OK, so a little follow up, in case anyone is interested.
One thing I didn't mention in the original post was that I was running CCK, Contemplate, and Views modules.
It turns out that the CCK version I was running was not the most recent, and because of this, there were (I belive) conflicts in the database which caused my many errors. Apparently the most recent version(s) of CCK for 4.7 rename(s) a table in the DB.
In any case, I reverted back to 4.7 by emptying my database, importing by backup .sql file and reverting my drupal folder to the way it was before I began the upgrade. The first thing I did was update CCK. Then I upgraded drupal to 5.0 according to the instructions -- except I did not update those 3 extra modules before running update.php as the instructions say. The update produced nor errors (no pink!). I then updated the modules 1 by 1 and in each case there were no errors each time I ran update.php.
So my advice to future upgraders: make sure you know what's going on with your non-core modules. You might need to bring them up to speed or at least check the module project pages to see if there are any notes re: upgrading.