Database errors when updating to 4.7.3

By Dubber Dan on 22 Aug 2006 at 10:58 UTC
I've just followed the process to upgrade from 4.6.x to 4.7.x and I get a load of errors after running the databse update script (see below).
any suggestions on what to do to sort this out or am I just best off reverting to 4.6.x and forgetting it!?
* user warning: Table 'contact' already exists query: CREATE TABLE contact ( subject varchar(255) NOT NULL default '', recipients longtext NOT NULL default '', reply longtext NOT NULL default '' ) in /home/westpco1/public_html/includes/database.mysql.inc on line 120.
    * user warning: Unknown column 'subject' in 'contact' query: ALTER TABLE contact CHANGE subject category VARCHAR(255) NOT NULL in /home/westpco1/public_html/includes/database.mysql.inc on line 120.
    * user warning: Multiple primary key defined query: ALTER TABLE contact ADD PRIMARY KEY (category) in /home/westpco1/public_html/includes/database.mysql.inc on line 120.
    * user warning: Table 'node_revisions' already exists query: CREATE TABLE node_revisions SELECT nid, nid AS vid, uid, type, title, body, teaser, changed AS timestamp, format FROM node in /home/westpco1/public_html/includes/database.mysql.inc on line 120.
    * user warning: Duplicate column name 'log' query: ALTER TABLE node_revisions ADD log longtext in /home/westpco1/public_html/includes/database.mysql.inc on line 120.
    * user warning: Multiple primary key defined query: ALTER TABLE node_revisions ADD PRIMARY KEY vid (vid) in /home/westpco1/public_html/includes/database.mysql.inc on line 120.
    * user warning: Duplicate key name 'nid' query: ALTER TABLE node_revisions ADD KEY nid (nid) in /home/westpco1/public_html/includes/database.mysql.inc on line 120.
    * user warning: Duplicate key name 'uid' query: ALTER TABLE node_revisions ADD KEY uid (uid) in /home/westpco1/public_html/includes/database.mysql.inc on line 120.
    * user warning: Table 'old_revisions' already exists query: CREATE TABLE old_revisions SELECT nid, type, revisions FROM node WHERE revisions != '' in /home/westpco1/public_html/includes/database.mysql.inc on line 120.
    * user warning: Can't DROP 'type'; check that column/key exists query: ALTER TABLE node_revisions DROP type in /home/westpco1/public_html/includes/database.mysql.inc on line 120.
    * user warning: Table 'search_dataset' already exists query: CREATE TABLE search_dataset ( sid int(10) unsigned NOT NULL default '0', type varchar(16) default NULL, data longtext NOT NULL, KEY sid_type (sid, type) ) in /home/westpco1/public_html/includes/database.mysql.inc on line 120.
    * user warning: Incorrect table definition; there can be only one auto column and it must be defined as a key query: ALTER TABLE contact DROP PRIMARY KEY in /home/westpco1/public_html/includes/database.mysql.inc on line 120.
    * user warning: Duplicate column name 'cid' query: ALTER TABLE contact ADD COLUMN cid int(11) NOT NULL PRIMARY KEY auto_increment in /home/westpco1/public_html/includes/database.mysql.inc on line 120.
    * user warning: Duplicate key name 'category' query: ALTER TABLE contact ADD UNIQUE KEY category (category) in /home/westpco1/public_html/includes/database.mysql.inc on line 120.
    * user warning: Duplicate column name 'weight' query: ALTER TABLE contact ADD COLUMN weight tinyint(3) NOT NULL DEFAULT 0 in /home/westpco1/public_html/includes/database.mysql.inc on line 120.
    * user warning: Duplicate column name 'selected' query: ALTER TABLE contact ADD COLUMN selected tinyint(1) NOT NULL DEFAULT 0 in /home/westpco1/public_html/includes/database.mysql.inc on line 120.
    * user warning: Table 'poll_votes' already exists query: 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) ) in /home/westpco1/public_html/includes/database.mysql.inc on line 120.
    * user warning: Table 'client' already exists query: 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) ) in /home/westpco1/public_html/includes/database.mysql.inc on line 120.
    * user warning: Table 'client_system' already exists query: 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) ) in /home/westpco1/public_html/includes/database.mysql.inc on line 120.
    * user warning: Table 'file_revisions' already exists query: CREATE TABLE file_revisions ( fid int(10) unsigned NOT NULL default 0, vid int(10) unsigned NOT NULL default 0, description varchar(255) NOT NULL default '', list tinyint(1) unsigned NOT NULL default 0, PRIMARY KEY (fid, vid) ) /*!40100 DEFAULT CHARACTER SET utf8 */ in /home/westpco1/public_html/includes/database.mysql.inc on line 120.

Update #129

    * ALTER TABLE {vocabulary} ADD tags tinyint(3) unsigned default '0' NOT NULL

Update #130

    * No queries

Update #131

    * ALTER TABLE {boxes} DROP INDEX title

Update #132

    * No queries

Update #133

    * Failed: CREATE TABLE {contact} ( subject varchar(255) NOT NULL default '', recipients longtext NOT NULL default '', reply longtext NOT NULL default '' )
    * ALTER TABLE {users} ADD login int(11) NOT NULL default '0'

Update #134

    * ALTER TABLE {blocks} DROP types

Update #135

    * No queries

Update #136

    * ALTER TABLE {users} CHANGE COLUMN changed access int(11) NOT NULL default '0'
    * UPDATE {users} SET access = login WHERE login > created
    * UPDATE {users} SET access = created WHERE access = 0

Update #137

    * ALTER TABLE {locales_source} CHANGE location location varchar(255) NOT NULL default ''

Update #138

    * INSERT INTO {url_alias} (src, dst) VALUES ('node/feed', 'rss.xml')

Update #139

    * ALTER TABLE {accesslog} ADD timer int(10) unsigned NOT NULL default '0'

Update #140

    * ALTER TABLE {url_alias} ADD INDEX (src)

Update #141

    * No queries

Update #142

    * No queries

Update #143

    * Failed: ALTER TABLE {contact} CHANGE subject category VARCHAR(255) NOT NULL
    * Failed: ALTER TABLE {contact} ADD PRIMARY KEY (category)

Update #144

    * ALTER TABLE {node} CHANGE type type VARCHAR(32) NOT NULL

Update #145

    * ALTER TABLE {blocks} CHANGE region region varchar(64) default 'left' NOT NULL
    * ALTER TABLE {blocks} ADD theme varchar(255) NOT NULL default ''
    * UPDATE {blocks} SET region = 'left' WHERE region = '0'
    * UPDATE {blocks} SET region = 'right' WHERE region = '1'

Update #146

    * Failed: CREATE TABLE {node_revisions} SELECT nid, nid AS vid, uid, type, title, body, teaser, changed AS timestamp, format FROM {node}
    * ALTER TABLE {node_revisions} CHANGE nid nid int(10) unsigned NOT NULL default '0'
    * Failed: ALTER TABLE {node_revisions} ADD log longtext
    * ALTER TABLE {node} ADD vid int(10) unsigned NOT NULL default '0'
    * ALTER TABLE {files} ADD vid int(10) unsigned NOT NULL default '0'
    * ALTER TABLE {book} ADD vid int(10) unsigned NOT NULL default '0'
    * ALTER TABLE {forum} ADD vid int(10) unsigned NOT NULL default '0'
    * ALTER TABLE {book} DROP PRIMARY KEY
    * ALTER TABLE {forum} DROP PRIMARY KEY
    * ALTER TABLE {files} DROP PRIMARY KEY
    * UPDATE {node} SET vid = nid
    * UPDATE {forum} SET vid = nid
    * UPDATE {book} SET vid = nid
    * UPDATE {files} SET vid = nid
    * ALTER TABLE {book} ADD PRIMARY KEY vid (vid)
    * ALTER TABLE {forum} ADD PRIMARY KEY vid (vid)
    * Failed: ALTER TABLE {node_revisions} ADD PRIMARY KEY vid (vid)
    * Failed: ALTER TABLE {node_revisions} ADD KEY nid (nid)
    * Failed: ALTER TABLE {node_revisions} ADD KEY uid (uid)
    * Failed: CREATE TABLE {old_revisions} SELECT nid, type, revisions FROM {node} WHERE revisions != ''
    * ALTER TABLE {book} ADD KEY nid (nid)
    * ALTER TABLE {forum} ADD KEY nid (nid)
    * ALTER TABLE {files} ADD KEY fid (fid)
    * ALTER TABLE {files} ADD KEY vid (vid)
    * INSERT INTO {sequences} (name, id) VALUES ('{node_revisions}_vid', 123)
    * ALTER TABLE {book} DROP log
    * ALTER TABLE {node} DROP teaser
    * ALTER TABLE {node} DROP body
    * ALTER TABLE {node} DROP format
    * ALTER TABLE {node} DROP revisions

Update #147

    * Failed: ALTER TABLE {node_revisions} DROP type

Update #148

    * ALTER TABLE {accesslog} ADD sid varchar(32) NOT NULL default ''

Update #149

    * ALTER TABLE {files} ADD COLUMN description VARCHAR(255) NOT NULL DEFAULT ''

Update #150

    * DELETE FROM {variable} WHERE name = 'node_cron_last'
    * DELETE FROM {variable} WHERE name = 'minimum_word_size'
    * DELETE FROM {variable} WHERE name = 'remove_short'
    * DELETE FROM {node_counter} WHERE nid = 0
    * DROP TABLE {search_index}
    * DROP TABLE {search_total}
    * Failed: CREATE TABLE {search_dataset} ( sid int(10) unsigned NOT NULL default '0', type varchar(16) default NULL, data longtext NOT NULL, KEY sid_type (sid, type) )
    * CREATE TABLE {search_index} ( word varchar(50) NOT NULL default '', sid int(10) unsigned NOT NULL default '0', type varchar(16) default NULL, fromsid int(10) unsigned NOT NULL default '0', fromtype varchar(16) default NULL, score float default NULL, KEY sid_type (sid, type), KEY from_sid_type (fromsid, fromtype), KEY word (word) )
    * CREATE TABLE {search_total} ( word varchar(50) NOT NULL default '', count float default NULL, PRIMARY KEY word (word) )

Update #151

    * INSERT INTO {menu} (mid, pid, path, title, description, weight, type) VALUES (221, 0, '', 'Primary links', '', 0, 115)
    * INSERT INTO {menu} (mid, pid, path, title, description, weight, type) VALUES (222, 221, 'node/55', 'Eastleigh Surgery', '', 0, 118)
    * INSERT INTO {menu} (mid, pid, path, title, description, weight, type) VALUES (223, 221, 'node/56', 'Bratton Surgery', '', 0, 118)
    * INSERT INTO {menu} (mid, pid, path, title, description, weight, type) VALUES (224, 221, 'node/57', 'White Horse Surgery', '', 0, 118)
    * INSERT INTO {menu} (mid, pid, path, title, description, weight, type) VALUES (225, 221, 'admin/themes/settings\" class=\"active', 'edit primary links', '', 0, 118)
    * INSERT INTO {menu} (mid, pid, path, title, description, weight, type) VALUES (226, 0, '', 'Secondary links', '', 0, 115)
    * INSERT INTO {menu} (mid, pid, path, title, description, weight, type) VALUES (227, 226, 'admin/themes/settings\" class=\"active', 'edit secondary links', '', 0, 118)
    * UPDATE {system} SET status = 1 WHERE name = 'menu'

Update #152

    * No queries

Update #153

    * Failed: ALTER TABLE {contact} DROP PRIMARY KEY
    * Failed: ALTER TABLE {contact} ADD COLUMN cid int(11) NOT NULL PRIMARY KEY auto_increment
    * Failed: ALTER TABLE {contact} ADD UNIQUE KEY category (category)

Update #154

    * Failed: ALTER TABLE {contact} ADD COLUMN weight tinyint(3) NOT NULL DEFAULT 0
    * Failed: ALTER TABLE {contact} ADD COLUMN selected tinyint(1) NOT NULL DEFAULT 0

Update #155

    * No queries

Update #156

    * DELETE FROM {cache}

Update #157

    * DELETE FROM {url_alias} WHERE src = 'node/feed' AND dst = 'rss.xml'
    * INSERT INTO {url_alias} (src, dst) VALUES ('rss.xml', 'node/feed')

Update #158

    * ALTER TABLE {old_revisions} ADD done tinyint(1) NOT NULL DEFAULT 0
    * ALTER TABLE {old_revisions} ADD INDEX (done)

Update #159

    * 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

    * Failed: 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}
    * Failed: 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) )
    * Failed: 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) )

Update #167

    * ALTER TABLE {vocabulary_node_types} CHANGE type type varchar(32) NOT NULL default ''

Update #168

    * ALTER TABLE {term_hierarchy} ADD PRIMARY KEY (tid, parent)

Update #169

    * ALTER TABLE {accesslog} DEFAULT CHARACTER SET utf8
    * ALTER TABLE {accesslog} CHANGE `title` `title` varbinary(255) DEFAULT '' NULL, CHANGE `path` `path` varbinary(255) DEFAULT '' NULL, CHANGE `url` `url` varbinary(255) DEFAULT '' NULL, CHANGE `hostname` `hostname` varbinary(128) DEFAULT '' NULL, CHANGE `sid` `sid` varbinary(32) DEFAULT '' NOT NULL
    * ALTER TABLE {accesslog} CHANGE `title` `title` varchar(255) CHARACTER SET utf8 DEFAULT '' NULL, CHANGE `path` `path` varchar(255) CHARACTER SET utf8 DEFAULT '' NULL, CHANGE `url` `url` varchar(255) CHARACTER SET utf8 DEFAULT '' NULL, CHANGE `hostname` `hostname` varchar(128) CHARACTER SET utf8 DEFAULT '' NULL, CHANGE `sid` `sid` varchar(32) CHARACTER SET utf8 DEFAULT '' NOT NULL
    * ALTER TABLE {aggregator_category} DEFAULT CHARACTER SET utf8
    * ALTER TABLE {aggregator_category} CHANGE `title` `title` varbinary(255) DEFAULT '' NOT NULL, CHANGE `description` `description` longblob DEFAULT '' NOT NULL
    * ALTER TABLE {aggregator_category} CHANGE `title` `title` varchar(255) CHARACTER SET utf8 DEFAULT '' NOT NULL, CHANGE `description` `description` longtext CHARACTER SET utf8 DEFAULT '' NOT NULL
    * ALTER TABLE {aggregator_category_feed} DEFAULT CHARACTER SET utf8
    * ALTER TABLE {aggregator_category_item} DEFAULT CHARACTER SET utf8
    * ALTER TABLE {aggregator_feed} DEFAULT CHARACTER SET utf8
    * ALTER TABLE {aggregator_feed} CHANGE `title` `title` varbinary(255) DEFAULT '' NOT NULL, CHANGE `url` `url` varbinary(255) DEFAULT '' NOT NULL, CHANGE `link` `link` varbinary(255) DEFAULT '' NOT NULL, CHANGE `description` `description` longblob DEFAULT '' NOT NULL, CHANGE `image` `image` longblob DEFAULT '' NOT NULL, CHANGE `etag` `etag` varbinary(255) DEFAULT '' NOT NULL
    * ALTER TABLE {aggregator_feed} CHANGE `title` `title` varchar(255) CHARACTER SET utf8 DEFAULT '' NOT NULL, CHANGE `url` `url` varchar(255) CHARACTER SET utf8 DEFAULT '' NOT NULL, CHANGE `link` `link` varchar(255) CHARACTER SET utf8 DEFAULT '' NOT NULL, CHANGE `description` `description` longtext CHARACTER SET utf8 DEFAULT '' NOT NULL, CHANGE `image` `image` longtext CHARACTER SET utf8 DEFAULT '' NOT NULL, CHANGE `etag` `etag` varchar(255) CHARACTER SET utf8 DEFAULT '' NOT NULL
    * ALTER TABLE {aggregator_item} DEFAULT CHARACTER SET utf8
    * ALTER TABLE {aggregator_item} CHANGE `title` `title` varbinary(255) DEFAULT '' NOT NULL, CHANGE `link` `link` varbinary(255) DEFAULT '' NOT NULL, CHANGE `author` `author` varbinary(255) DEFAULT '' NOT NULL, CHANGE `description` `description` longblob DEFAULT '' NOT NULL
    * ALTER TABLE {aggregator_item} CHANGE `title` `title` varchar(255) CHARACTER SET utf8 DEFAULT '' NOT NULL, CHANGE `link` `link` varchar(255) CHARACTER SET utf8 DEFAULT '' NOT NULL, CHANGE `author` `author` varchar(255) CHARACTER SET utf8 DEFAULT '' NOT NULL, CHANGE `description` `description` longtext CHARACTER SET utf8 DEFAULT '' NOT NULL
    * ALTER TABLE {authmap} DEFAULT CHARACTER SET utf8
    * ALTER TABLE {authmap} CHANGE `authname` `authname` varbinary(128) DEFAULT '' NOT NULL, CHANGE `module` `module` varbinary(128) DEFAULT '' NOT NULL
    * ALTER TABLE {authmap} CHANGE `authname` `authname` varchar(128) CHARACTER SET utf8 DEFAULT '' NOT NULL, CHANGE `module` `module` varchar(128) CHARACTER SET utf8 DEFAULT '' NOT NULL
    * ALTER TABLE {blocks} DEFAULT CHARACTER SET utf8
    * ALTER TABLE {blocks} CHANGE `module` `module` varbinary(64) DEFAULT '' NOT NULL, CHANGE `delta` `delta` varbinary(32) DEFAULT '0' NOT NULL, CHANGE `region` `region` varbinary(64) DEFAULT 'left' NOT NULL, CHANGE `pages` `pages` blob DEFAULT '' NOT NULL, CHANGE `theme` `theme` varbinary(255) DEFAULT '' NOT NULL
    * ALTER TABLE {blocks} CHANGE `module` `module` varchar(64) CHARACTER SET utf8 DEFAULT '' NOT NULL, CHANGE `delta` `delta` varchar(32) CHARACTER SET utf8 DEFAULT '0' NOT NULL, CHANGE `region` `region` varchar(64) CHARACTER SET utf8 DEFAULT 'left' NOT NULL, CHANGE `pages` `pages` text CHARACTER SET utf8 DEFAULT '' NOT NULL, CHANGE `theme` `theme` varchar(255) CHARACTER SET utf8 DEFAULT '' NOT NULL
    * ALTER TABLE {book} DEFAULT CHARACTER SET utf8
    * ALTER TABLE {boxes} DEFAULT CHARACTER SET utf8
    * ALTER TABLE {boxes} CHANGE `title` `title` varbinary(64) DEFAULT '' NOT NULL, CHANGE `body` `body` longblob DEFAULT '' NULL, CHANGE `info` `info` varbinary(128) DEFAULT '' NOT NULL
    * ALTER TABLE {boxes} CHANGE `title` `title` varchar(64) CHARACTER SET utf8 DEFAULT '' NOT NULL, CHANGE `body` `body` longtext CHARACTER SET utf8 DEFAULT '' NULL, CHANGE `info` `info` varchar(128) CHARACTER SET utf8 DEFAULT '' NOT NULL
    * ALTER TABLE {cache} DEFAULT CHARACTER SET utf8
    * ALTER TABLE {cache} CHANGE `cid` `cid` varbinary(255) DEFAULT '' NOT NULL, CHANGE `headers` `headers` blob DEFAULT '' NULL
    * ALTER TABLE {cache} CHANGE `cid` `cid` varchar(255) CHARACTER SET utf8 DEFAULT '' NOT NULL, CHANGE `headers` `headers` text CHARACTER SET utf8 DEFAULT '' NULL
    * ALTER TABLE {comments} DEFAULT CHARACTER SET utf8
    * ALTER TABLE {comments} CHANGE `subject` `subject` varbinary(64) DEFAULT '' NOT NULL, CHANGE `comment` `comment` longblob DEFAULT '' NOT NULL, CHANGE `hostname` `hostname` varbinary(128) DEFAULT '' NOT NULL, CHANGE `thread` `thread` varbinary(255) DEFAULT '' NOT NULL, CHANGE `users` `users` longblob DEFAULT '' NULL, CHANGE `name` `name` varbinary(60) DEFAULT '' NULL, CHANGE `mail` `mail` varbinary(64) DEFAULT '' NULL, CHANGE `homepage` `homepage` varbinary(255) DEFAULT '' NULL
    * ALTER TABLE {comments} CHANGE `subject` `subject` varchar(64) CHARACTER SET utf8 DEFAULT '' NOT NULL, CHANGE `comment` `comment` longtext CHARACTER SET utf8 DEFAULT '' NOT NULL, CHANGE `hostname` `hostname` varchar(128) CHARACTER SET utf8 DEFAULT '' NOT NULL, CHANGE `thread` `thread` varchar(255) CHARACTER SET utf8 DEFAULT '' NOT NULL, CHANGE `users` `users` longtext CHARACTER SET utf8 DEFAULT '' NULL, CHANGE `name` `name` varchar(60) CHARACTER SET utf8 DEFAULT '' NULL, CHANGE `mail` `mail` varchar(64) CHARACTER SET utf8 DEFAULT '' NULL, CHANGE `homepage` `homepage` varchar(255) CHARACTER SET utf8 DEFAULT '' NULL
    * ALTER TABLE {contact} DEFAULT CHARACTER SET utf8
    * ALTER TABLE {contact} CHANGE `category` `category` varbinary(255) DEFAULT '' NOT NULL, CHANGE `recipients` `recipients` longblob DEFAULT '' NOT NULL, CHANGE `reply` `reply` longblob DEFAULT '' NOT NULL
    * ALTER TABLE {contact} CHANGE `category` `category` varchar(255) CHARACTER SET utf8 DEFAULT '' NOT NULL, CHANGE `recipients` `recipients` longtext CHARACTER SET utf8 DEFAULT '' NOT NULL, CHANGE `reply` `reply` longtext CHARACTER SET utf8 DEFAULT '' NOT NULL
    * ALTER TABLE {node_comment_statistics} DEFAULT CHARACTER SET utf8
    * ALTER TABLE {node_comment_statistics} CHANGE `last_comment_name` `last_comment_name` varbinary(60) DEFAULT '' NULL
    * ALTER TABLE {node_comment_statistics} CHANGE `last_comment_name` `last_comment_name` varchar(60) CHARACTER SET utf8 DEFAULT '' NULL
    * ALTER TABLE {client} DEFAULT CHARACTER SET utf8
    * ALTER TABLE {client} CHANGE `link` `link` varbinary(255) DEFAULT '' NOT NULL, CHANGE `name` `name` varbinary(128) DEFAULT '' NOT NULL, CHANGE `mail` `mail` varbinary(128) DEFAULT '' NOT NULL, CHANGE `slogan` `slogan` longblob DEFAULT '' NOT NULL, CHANGE `mission` `mission` longblob DEFAULT '' NOT NULL, CHANGE `version` `version` varbinary(35) DEFAULT '' NOT NULL
    * ALTER TABLE {client} CHANGE `link` `link` varchar(255) CHARACTER SET utf8 DEFAULT '' NOT NULL, CHANGE `name` `name` varchar(128) CHARACTER SET utf8 DEFAULT '' NOT NULL, CHANGE `mail` `mail` varchar(128) CHARACTER SET utf8 DEFAULT '' NOT NULL, CHANGE `slogan` `slogan` longtext CHARACTER SET utf8 DEFAULT '' NOT NULL, CHANGE `mission` `mission` longtext CHARACTER SET utf8 DEFAULT '' NOT NULL, CHANGE `version` `version` varchar(35) CHARACTER SET utf8 DEFAULT '' NOT NULL
    * ALTER TABLE {client_system} DEFAULT CHARACTER SET utf8
    * ALTER TABLE {client_system} CHANGE `name` `name` varbinary(255) DEFAULT '' NOT NULL, CHANGE `type` `type` varbinary(255) DEFAULT '' NOT NULL
    * ALTER TABLE {client_system} CHANGE `name` `name` varchar(255) CHARACTER SET utf8 DEFAULT '' NOT NULL, CHANGE `type` `type` varchar(255) CHARACTER SET utf8 DEFAULT '' NOT NULL
    * ALTER TABLE {files} DEFAULT CHARACTER SET utf8
    * ALTER TABLE {files} CHANGE `filename` `filename` varbinary(255) DEFAULT '' NOT NULL, CHANGE `filepath` `filepath` varbinary(255) DEFAULT '' NOT NULL, CHANGE `filemime` `filemime` varbinary(255) DEFAULT '' NOT NULL, CHANGE `description` `description` varbinary(255) DEFAULT '' NOT NULL
    * ALTER TABLE {files} CHANGE `filename` `filename` varchar(255) CHARACTER SET utf8 DEFAULT '' NOT NULL, CHANGE `filepath` `filepath` varchar(255) CHARACTER SET utf8 DEFAULT '' NOT NULL, CHANGE `filemime` `filemime` varchar(255) CHARACTER SET utf8 DEFAULT '' NOT NULL, CHANGE `description` `description` varchar(255) CHARACTER SET utf8 DEFAULT '' NOT NULL
    * ALTER TABLE {filter_formats} DEFAULT CHARACTER SET utf8
    * ALTER TABLE {filter_formats} CHANGE `name` `name` varbinary(255) DEFAULT '' NOT NULL, CHANGE `roles` `roles` varbinary(255) DEFAULT '' NOT NULL
    * ALTER TABLE {filter_formats} CHANGE `name` `name` varchar(255) CHARACTER SET utf8 DEFAULT '' NOT NULL, CHANGE `roles` `roles` varchar(255) CHARACTER SET utf8 DEFAULT '' NOT NULL
    * ALTER TABLE {filters} DEFAULT CHARACTER SET utf8
    * ALTER TABLE {filters} CHANGE `module` `module` varbinary(64) DEFAULT '' NOT NULL
    * ALTER TABLE {filters} CHANGE `module` `module` varchar(64) CHARACTER SET utf8 DEFAULT '' NOT NULL
    * ALTER TABLE {flood} DEFAULT CHARACTER SET utf8
    * ALTER TABLE {flood} CHANGE `event` `event` varbinary(64) DEFAULT '' NOT NULL, CHANGE `hostname` `hostname` varbinary(128) DEFAULT '' NOT NULL
    * ALTER TABLE {flood} CHANGE `event` `event` varchar(64) CHARACTER SET utf8 DEFAULT '' NOT NULL, CHANGE `hostname` `hostname` varchar(128) CHARACTER SET utf8 DEFAULT '' NOT NULL
    * ALTER TABLE {forum} DEFAULT CHARACTER SET utf8
    * ALTER TABLE {history} DEFAULT CHARACTER SET utf8
    * ALTER TABLE {locales_meta} DEFAULT CHARACTER SET utf8
    * ALTER TABLE {locales_meta} CHANGE `locale` `locale` varbinary(12) DEFAULT '' NOT NULL, CHANGE `name` `name` varbinary(64) DEFAULT '' NOT NULL, CHANGE `formula` `formula` varbinary(128) DEFAULT '' NOT NULL
    * ALTER TABLE {locales_meta} CHANGE `locale` `locale` varchar(12) CHARACTER SET utf8 DEFAULT '' NOT NULL, CHANGE `name` `name` varchar(64) CHARACTER SET utf8 DEFAULT '' NOT NULL, CHANGE `formula` `formula` varchar(128) CHARACTER SET utf8 DEFAULT '' NOT NULL
    * ALTER TABLE {locales_source} DEFAULT CHARACTER SET utf8
    * ALTER TABLE {locales_source} CHANGE `location` `location` varbinary(255) DEFAULT '' NOT NULL
    * ALTER TABLE {locales_source} CHANGE `location` `location` varchar(255) CHARACTER SET utf8 DEFAULT '' NOT NULL
    * ALTER TABLE {locales_target} DEFAULT CHARACTER SET utf8
    * ALTER TABLE {locales_target} CHANGE `locale` `locale` varbinary(12) DEFAULT '' NOT NULL
    * ALTER TABLE {locales_target} CHANGE `locale` `locale` varchar(12) CHARACTER SET utf8 DEFAULT '' NOT NULL
    * ALTER TABLE {menu} DEFAULT CHARACTER SET utf8
    * ALTER TABLE {menu} CHANGE `path` `path` varbinary(255) DEFAULT '' NOT NULL, CHANGE `title` `title` varbinary(255) DEFAULT '' NOT NULL, CHANGE `description` `description` varbinary(255) DEFAULT '' NOT NULL
    * ALTER TABLE {menu} CHANGE `path` `path` varchar(255) CHARACTER SET utf8 DEFAULT '' NOT NULL, CHANGE `title` `title` varchar(255) CHARACTER SET utf8 DEFAULT '' NOT NULL, CHANGE `description` `description` varchar(255) CHARACTER SET utf8 DEFAULT '' NOT NULL
    * ALTER TABLE {node} DEFAULT CHARACTER SET utf8
    * ALTER TABLE {node} CHANGE `type` `type` varbinary(32) DEFAULT '' NOT NULL, CHANGE `title` `title` varbinary(128) DEFAULT '' NOT NULL
    * ALTER TABLE {node} CHANGE `type` `type` varchar(32) CHARACTER SET utf8 DEFAULT '' NOT NULL, CHANGE `title` `title` varchar(128) CHARACTER SET utf8 DEFAULT '' NOT NULL
    * ALTER TABLE {node_access} DEFAULT CHARACTER SET utf8
    * ALTER TABLE {node_access} CHANGE `realm` `realm` varbinary(255) DEFAULT '' NOT NULL
    * ALTER TABLE {node_access} CHANGE `realm` `realm` varchar(255) CHARACTER SET utf8 DEFAULT '' NOT NULL
    * ALTER TABLE {node_revisions} DEFAULT CHARACTER SET utf8
    * ALTER TABLE {node_revisions} CHANGE `title` `title` varbinary(128) DEFAULT '' NOT NULL, CHANGE `body` `body` longblob DEFAULT '' NOT NULL, CHANGE `teaser` `teaser` longblob DEFAULT '' NOT NULL, CHANGE `log` `log` longblob DEFAULT '' NULL
    * ALTER TABLE {node_revisions} CHANGE `title` `title` varchar(128) CHARACTER SET utf8 DEFAULT '' NOT NULL, CHANGE `body` `body` longtext CHARACTER SET utf8 DEFAULT '' NOT NULL, CHANGE `teaser` `teaser` longtext CHARACTER SET utf8 DEFAULT '' NOT NULL, CHANGE `log` `log` longtext CHARACTER SET utf8 DEFAULT '' NULL
    * ALTER TABLE {profile_fields} DEFAULT CHARACTER SET utf8
    * ALTER TABLE {profile_fields} CHANGE `title` `title` varbinary(255) DEFAULT '' NULL, CHANGE `name` `name` varbinary(128) DEFAULT '' NULL, CHANGE `explanation` `explanation` blob DEFAULT '' NULL, CHANGE `category` `category` varbinary(255) DEFAULT '' NULL, CHANGE `page` `page` varbinary(255) DEFAULT '' NULL, CHANGE `type` `type` varbinary(128) DEFAULT '' NULL, CHANGE `options` `options` blob DEFAULT '' NULL
    * ALTER TABLE {profile_fields} CHANGE `title` `title` varchar(255) CHARACTER SET utf8 DEFAULT '' NULL, CHANGE `name` `name` varchar(128) CHARACTER SET utf8 DEFAULT '' NULL, CHANGE `explanation` `explanation` text CHARACTER SET utf8 DEFAULT '' NULL, CHANGE `category` `category` varchar(255) CHARACTER SET utf8 DEFAULT '' NULL, CHANGE `page` `page` varchar(255) CHARACTER SET utf8 DEFAULT '' NULL, CHANGE `type` `type` varchar(128) CHARACTER SET utf8 DEFAULT '' NULL, CHANGE `options` `options` text CHARACTER SET utf8 DEFAULT '' NULL
    * ALTER TABLE {profile_values} DEFAULT CHARACTER SET utf8
    * ALTER TABLE {profile_values} CHANGE `value` `value` blob DEFAULT '' NULL
    * ALTER TABLE {profile_values} CHANGE `value` `value` text CHARACTER SET utf8 DEFAULT '' NULL
    * ALTER TABLE {url_alias} DEFAULT CHARACTER SET utf8
    * ALTER TABLE {url_alias} CHANGE `src` `src` varbinary(128) DEFAULT '' NOT NULL, CHANGE `dst` `dst` varbinary(128) DEFAULT '' NOT NULL
    * ALTER TABLE {url_alias} CHANGE `src` `src` varchar(128) CHARACTER SET utf8 DEFAULT '' NOT NULL, CHANGE `dst` `dst` varchar(128) CHARACTER SET utf8 DEFAULT '' NOT NULL
    * ALTER TABLE {permission} DEFAULT CHARACTER SET utf8
    * ALTER TABLE {permission} CHANGE `perm` `perm` longblob DEFAULT '' NULL
    * ALTER TABLE {permission} CHANGE `perm` `perm` longtext CHARACTER SET utf8 DEFAULT '' NULL
    * ALTER TABLE {poll} DEFAULT CHARACTER SET utf8
    * ALTER TABLE {poll_votes} DEFAULT CHARACTER SET utf8
    * ALTER TABLE {poll_votes} CHANGE `hostname` `hostname` varbinary(128) DEFAULT '' NOT NULL
    * ALTER TABLE {poll_votes} CHANGE `hostname` `hostname` varchar(128) CHARACTER SET utf8 DEFAULT '' NOT NULL
    * ALTER TABLE {poll_choices} DEFAULT CHARACTER SET utf8
    * ALTER TABLE {poll_choices} CHANGE `chtext` `chtext` varbinary(128) DEFAULT '' NOT NULL
    * ALTER TABLE {poll_choices} CHANGE `chtext` `chtext` varchar(128) CHARACTER SET utf8 DEFAULT '' NOT NULL
    * ALTER TABLE {role} DEFAULT CHARACTER SET utf8
    * ALTER TABLE {role} CHANGE `name` `name` varbinary(32) DEFAULT '' NOT NULL
    * ALTER TABLE {role} CHANGE `name` `name` varchar(32) CHARACTER SET utf8 DEFAULT '' NOT NULL
    * ALTER TABLE {search_dataset} DEFAULT CHARACTER SET utf8
    * ALTER TABLE {search_dataset} CHANGE `type` `type` varbinary(16) DEFAULT '' NULL, CHANGE `data` `data` longblob DEFAULT '' NOT NULL
    * ALTER TABLE {search_dataset} CHANGE `type` `type` varchar(16) CHARACTER SET utf8 DEFAULT '' NULL, CHANGE `data` `data` longtext CHARACTER SET utf8 DEFAULT '' NOT NULL
    * ALTER TABLE {search_index} DEFAULT CHARACTER SET utf8
    * ALTER TABLE {search_index} CHANGE `word` `word` varbinary(50) DEFAULT '' NOT NULL, CHANGE `type` `type` varbinary(16) DEFAULT '' NULL, CHANGE `fromtype` `fromtype` varbinary(16) DEFAULT '' NULL
    * ALTER TABLE {search_index} CHANGE `word` `word` varchar(50) CHARACTER SET utf8 DEFAULT '' NOT NULL, CHANGE `type` `type` varchar(16) CHARACTER SET utf8 DEFAULT '' NULL, CHANGE `fromtype` `fromtype` varchar(16) CHARACTER SET utf8 DEFAULT '' NULL
    * ALTER TABLE {search_total} DEFAULT CHARACTER SET utf8
    * ALTER TABLE {search_total} CHANGE `word` `word` varbinary(50) DEFAULT '' NOT NULL
    * ALTER TABLE {search_total} CHANGE `word` `word` varchar(50) CHARACTER SET utf8 DEFAULT '' NOT NULL
    * ALTER TABLE {sessions} DEFAULT CHARACTER SET utf8
    * ALTER TABLE {sessions} CHANGE `sid` `sid` varbinary(32) DEFAULT '' NOT NULL, CHANGE `hostname` `hostname` varbinary(128) DEFAULT '' NOT NULL, CHANGE `session` `session` longblob DEFAULT '' NULL
    * ALTER TABLE {sessions} CHANGE `sid` `sid` varchar(32) CHARACTER SET utf8 DEFAULT '' NOT NULL, CHANGE `hostname` `hostname` varchar(128) CHARACTER SET utf8 DEFAULT '' NOT NULL, CHANGE `session` `session` longtext CHARACTER SET utf8 DEFAULT '' NULL
    * ALTER TABLE {sequences} DEFAULT CHARACTER SET utf8
    * ALTER TABLE {sequences} CHANGE `name` `name` varbinary(255) DEFAULT '' NOT NULL
    * ALTER TABLE {sequences} CHANGE `name` `name` varchar(255) CHARACTER SET utf8 DEFAULT '' NOT NULL
    * ALTER TABLE {node_counter} DEFAULT CHARACTER SET utf8
    * ALTER TABLE {system} DEFAULT CHARACTER SET utf8
    * ALTER TABLE {system} CHANGE `filename` `filename` varbinary(255) DEFAULT '' NOT NULL, CHANGE `name` `name` varbinary(255) DEFAULT '' NOT NULL, CHANGE `type` `type` varbinary(255) DEFAULT '' NOT NULL, CHANGE `description` `description` varbinary(255) DEFAULT '' NOT NULL
    * ALTER TABLE {system} CHANGE `filename` `filename` varchar(255) CHARACTER SET utf8 DEFAULT '' NOT NULL, CHANGE `name` `name` varchar(255) CHARACTER SET utf8 DEFAULT '' NOT NULL, CHANGE `type` `type` varchar(255) CHARACTER SET utf8 DEFAULT '' NOT NULL, CHANGE `description` `description` varchar(255) CHARACTER SET utf8 DEFAULT '' NOT NULL
    * ALTER TABLE {term_data} DEFAULT CHARACTER SET utf8
    * ALTER TABLE {term_data} CHANGE `name` `name` varbinary(255) DEFAULT '' NOT NULL, CHANGE `description` `description` longblob DEFAULT '' NULL
    * ALTER TABLE {term_data} CHANGE `name` `name` varchar(255) CHARACTER SET utf8 DEFAULT '' NOT NULL, CHANGE `description` `description` longtext CHARACTER SET utf8 DEFAULT '' NULL
    * ALTER TABLE {term_hierarchy} DEFAULT CHARACTER SET utf8
    * ALTER TABLE {term_node} DEFAULT CHARACTER SET utf8
    * ALTER TABLE {term_relation} DEFAULT CHARACTER SET utf8
    * ALTER TABLE {term_synonym} DEFAULT CHARACTER SET utf8
    * ALTER TABLE {term_synonym} CHANGE `name` `name` varbinary(255) DEFAULT '' NOT NULL
    * ALTER TABLE {term_synonym} CHANGE `name` `name` varchar(255) CHARACTER SET utf8 DEFAULT '' NOT NULL
    * ALTER TABLE {users} DEFAULT CHARACTER SET utf8
    * ALTER TABLE {users} CHANGE `name` `name` varbinary(60) DEFAULT '' NOT NULL, CHANGE `pass` `pass` varbinary(32) DEFAULT '' NOT NULL, CHANGE `mail` `mail` varbinary(64) DEFAULT '' NULL, CHANGE `theme` `theme` varbinary(255) DEFAULT '' NOT NULL, CHANGE `signature` `signature` varbinary(255) DEFAULT '' NOT NULL, CHANGE `timezone` `timezone` varbinary(8) DEFAULT '' NULL, CHANGE `language` `language` varbinary(12) DEFAULT '' NOT NULL, CHANGE `picture` `picture` varbinary(255) DEFAULT '' NOT NULL, CHANGE `init` `init` varbinary(64) DEFAULT '' NULL, CHANGE `data` `data` longblob DEFAULT '' NULL
    * ALTER TABLE {users} CHANGE `name` `name` varchar(60) CHARACTER SET utf8 DEFAULT '' NOT NULL, CHANGE `pass` `pass` varchar(32) CHARACTER SET utf8 DEFAULT '' NOT NULL, CHANGE `mail` `mail` varchar(64) CHARACTER SET utf8 DEFAULT '' NULL, CHANGE `theme` `theme` varchar(255) CHARACTER SET utf8 DEFAULT '' NOT NULL, CHANGE `signature` `signature` varchar(255) CHARACTER SET utf8 DEFAULT '' NOT NULL, CHANGE `timezone` `timezone` varchar(8) CHARACTER SET utf8 DEFAULT '' NULL, CHANGE `language` `language` varchar(12) CHARACTER SET utf8 DEFAULT '' NOT NULL, CHANGE `picture` `picture` varchar(255) CHARACTER SET utf8 DEFAULT '' NOT NULL, CHANGE `init` `init` varchar(64) CHARACTER SET utf8 DEFAULT '' NULL, CHANGE `data` `data` longtext CHARACTER SET utf8 DEFAULT '' NULL
    * ALTER TABLE {users_roles} DEFAULT CHARACTER SET utf8
    * ALTER TABLE {variable} DEFAULT CHARACTER SET utf8
    * ALTER TABLE {variable} CHANGE `name` `name` varbinary(48) DEFAULT '' NOT NULL, CHANGE `value` `value` longblob DEFAULT '' NOT NULL
    * ALTER TABLE {variable} CHANGE `name` `name` varchar(48) CHARACTER SET utf8 DEFAULT '' NOT NULL, CHANGE `value` `value` longtext CHARACTER SET utf8 DEFAULT '' NOT NULL
    * ALTER TABLE {vocabulary} DEFAULT CHARACTER SET utf8
    * ALTER TABLE {vocabulary} CHANGE `name` `name` varbinary(255) DEFAULT '' NOT NULL, CHANGE `description` `description` longblob DEFAULT '' NULL, CHANGE `help` `help` varbinary(255) DEFAULT '' NOT NULL, CHANGE `module` `module` varbinary(255) DEFAULT '' NOT NULL
    * ALTER TABLE {vocabulary} CHANGE `name` `name` varchar(255) CHARACTER SET utf8 DEFAULT '' NOT NULL, CHANGE `description` `description` longtext CHARACTER SET utf8 DEFAULT '' NULL, CHANGE `help` `help` varchar(255) CHARACTER SET utf8 DEFAULT '' NOT NULL, CHANGE `module` `module` varchar(255) CHARACTER SET utf8 DEFAULT '' NOT NULL
    * ALTER TABLE {vocabulary_node_types} DEFAULT CHARACTER SET utf8
    * ALTER TABLE {vocabulary_node_types} CHANGE `type` `type` varbinary(32) DEFAULT '' NOT NULL
    * ALTER TABLE {vocabulary_node_types} CHANGE `type` `type` varchar(32) CHARACTER SET utf8 DEFAULT '' NOT NULL
    * ALTER TABLE {watchdog} DEFAULT CHARACTER SET utf8
    * ALTER TABLE {watchdog} CHANGE `type` `type` varbinary(16) DEFAULT '' NOT NULL, CHANGE `message` `message` longblob DEFAULT '' NOT NULL, CHANGE `link` `link` varbinary(255) DEFAULT '' NOT NULL, CHANGE `location` `location` varbinary(128) DEFAULT '' NOT NULL, CHANGE `hostname` `hostname` varbinary(128) DEFAULT '' NOT NULL, CHANGE `referer` `referer` varbinary(128) DEFAULT '' NOT NULL
    * ALTER TABLE {watchdog} CHANGE `type` `type` varchar(16) CHARACTER SET utf8 DEFAULT '' NOT NULL, CHANGE `message` `message` longtext CHARACTER SET utf8 DEFAULT '' NOT NULL, CHANGE `link` `link` varchar(255) CHARACTER SET utf8 DEFAULT '' NOT NULL, CHANGE `location` `location` varchar(128) CHARACTER SET utf8 DEFAULT '' NOT NULL, CHANGE `hostname` `hostname` varchar(128) CHARACTER SET utf8 DEFAULT '' NOT NULL, CHANGE `referer` `referer` varchar(128) CHARACTER SET utf8 DEFAULT '' NOT NULL

Update #170

    * No queries

Update #171

    * DELETE FROM {users_roles} WHERE rid IN (1, 2)

Update #172

    * No queries

Update #173

    * CREATE TABLE {files_backup} SELECT * FROM {files}
    * DELETE FROM {files} WHERE fid = 0
    * UPDATE {files} SET vid = nid WHERE vid = 0
    * CREATE TABLE {files_tmp} SELECT * FROM {files}
    * DROP TABLE {files}
    * Failed: CREATE TABLE {file_revisions} ( fid int(10) unsigned NOT NULL default 0, vid int(10) unsigned NOT NULL default 0, description varchar(255) NOT NULL default '', list tinyint(1) unsigned NOT NULL default 0, PRIMARY KEY (fid, vid) ) /*!40100 DEFAULT CHARACTER SET utf8 */
    * INSERT INTO {file_revisions} SELECT DISTINCT fid , vid, description, list FROM {files_tmp}
    * CREATE TABLE {files} ( fid int(10) unsigned NOT NULL default 0, nid int(10) unsigned NOT NULL default 0, filename varchar(255) NOT NULL default '', filepath varchar(255) NOT NULL default '', filemime varchar(255) NOT NULL default '', filesize int(10) unsigned NOT NULL default 0, PRIMARY KEY (fid) ) /*!40100 DEFAULT CHARACTER SET utf8 */
    * INSERT INTO {files} SELECT DISTINCT fid, nid, filename, filepath, filemime, filesize FROM {files_tmp}
    * DROP TABLE {files_tmp}
    * DROP TABLE {files_backup}

Update #174

    * No queries

Update #175

    * No queries

Update #176

    * ALTER TABLE {filter_formats} ADD UNIQUE (name)

Update #177

    * No queries

Update #178

    * No queries

Update #179

    * No queries

Update #180

    * ALTER TABLE {node} DROP PRIMARY KEY
    * ALTER TABLE {node} ADD PRIMARY KEY (nid, vid)
    * ALTER TABLE {node} ADD UNIQUE (vid)
    * ALTER TABLE {node} ADD INDEX (nid)
    * ALTER TABLE {node_counter} CHANGE nid nid INT(10) NOT NULL DEFAULT '0'

Update #181

    * ALTER TABLE {profile_fields} ADD autocomplete TINYINT(1) NOT NULL AFTER visibility ;

Update #182

    * No queries
Comments

This is really unnecessary -

Muslim guy commented 23 August 2006 at 13:19
This is really unnecessary - no need to post the entire error message
Some Drupal.org maintainers should warn not to post long error msgs anymore
Cheers
In fairness, you posted

Dubber Dan commented 23 August 2006 at 13:45
In fairness, you posted pretty much the whole error message part way down this thread so maybe that applies to you too!!!
That's fair enough because

Muslim guy commented 24 August 2006 at 05:55
That's fair enough because we are helping users tro consider or expect things to happen if they want to go with Ft upgrade :)
BTW how have you solved the problem?
The first part of the error message is from Ft, and the second part is from Drupal upgrading script - so Drupal.org maintainers can take a look at what happened from the user experience (not a good one )
Never solved it, so have

Dubber Dan commented 24 August 2006 at 08:16
Never solved it, so have restored from backup :(
I'm considering saving the content of my site then scrubbing it all, doing a fresh 4.7.x install and then recreating my site from scratch as it seems easier to do that than upgrade. Now if there was a way to do a fresh 4.7.x install and then to dump the nodes from a 4.6.x site into that, I'd be a happy man!