Support for Drupal 7 is ending on 5 January 2025—it’s time to migrate to Drupal 10! Learn about the many benefits of Drupal 10 and find migration tools in our resource center.
By kvarnelis on
Any ideas what went wrong? I went into my site afterwards and all the AJAX functionality is broken, so this is a non-trivial error.
* user warning: Table 'kazys_doco.old_revisions' doesn't exist query: ALTER TABLE old_revisions ADD done tinyint(1) NOT NULL DEFAULT 0 in /home/kazys/public_html/docomomo/includes/database.mysql.inc on line 108.
* user warning: Table 'kazys_doco.old_revisions' doesn't exist query: ALTER TABLE old_revisions ADD INDEX (done) in /home/kazys/public_html/docomomo/includes/database.mysql.inc on line 108.
* user warning: Table 'kazys_doco.old_revisions' doesn't exist query: SELECT * FROM old_revisions WHERE done = 0 AND type IN ('page', 'story', 'poll', 'book', 'forum') LIMIT 0, 20 in /home/kazys/public_html/docomomo/includes/database.mysql.inc on line 108.
* user warning: Table 'kazys_doco.old_revisions' doesn't exist query: ALTER TABLE old_revisions DROP done in /home/kazys/public_html/docomomo/includes/database.mysql.inc on line 108.
The following queries were executed
system module
Update #158
* Failed: ALTER TABLE {old_revisions} ADD done tinyint(1) NOT NULL DEFAULT 0
* Failed: ALTER TABLE {old_revisions} ADD INDEX (done)
Update #159
* UPDATE {sequences} SET id = 65 WHERE name = '{node_revisions}_vid'
* Failed: ALTER TABLE {old_revisions} DROP done
Update #160
* No queries
Update #161
* No queries
Update #162
* No queries
Update #163
* ALTER TABLE {cache} CHANGE data data LONGBLOB
Update #164
* CREATE TABLE {poll_votes} ( nid int(10) unsigned NOT NULL, uid int(10) unsigned NOT NULL default 0, hostname varchar(128) NOT NULL default '', INDEX (nid), INDEX (uid), INDEX (hostname) )
* ALTER TABLE {poll} DROP polled
Update #165
* No queries
Update #166
* DROP TABLE {directory}
* CREATE TABLE {client} ( cid int(10) unsigned NOT NULL auto_increment, link varchar(255) NOT NULL default '', name varchar(128) NOT NULL default '', mail varchar(128) NOT NULL default '', slogan longtext NOT NULL, mission longtext NOT NULL, users int(10) NOT NULL default '0', nodes int(10) NOT NULL default '0', version varchar(35) NOT NULL default'', created int(11) NOT NULL default '0', changed int(11) NOT NULL default '0', PRIMARY KEY (cid) ) TYPE=MyISAM
* CREATE TABLE {client_system} ( cid int(10) NOT NULL default '0', name varchar(255) NOT NULL default '', type varchar(255) NOT NULL default '', PRIMARY KEY (cid,name) ) TYPE=MyISAM
Comments
version
I just did an upgrade from b2 to b3 and it started with update #164.
Maybe you didn't have beta 2.
Have fun and check my Drupal Profile: http://drupal.org/user/519
i guess it's an improvement...
as i've complained elsewhere, drupal doesn't tell you what version it is in the changelog, so maybe i'm wrong... i have no idea how i'm supposed to figure it out.
in any event.
ok, let's say i'm wrong. so, i went back and reinstalled the database as it had been prior to the upgrade. i then deleted all the beta 3 drupal stuff and went with beta 2 (surely drupal could go from beta 1 to beta 3, w/o problems, right? don't answer that one!).
much better...
the ajax works. i'll try upgrading to beta 3 next, BUT what about the failures at update #158 and #159???
no dice
ok, ignoring those errors didn't help. when i got to beta 3, there were no update errors, but ajax broke.
i need to know how to solve the problem of update #158 and #159 failing.
http://www.varnelis.net