Upgrade error repository

MySQL 4.1.15-nt

---------------------------------------------------------------------------------------------
Drupal database update

* user error: 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 'TO types_old' at line 1 query: ALTER TABLE blocks RENAME types TO types_old in C:\Program Files\Apache Group\Apache2\htdocs\includes\database.mysqli.inc on line 116.
* user error: Unknown column 'changed' in 'users' query: ALTER TABLE users CHANGE COLUMN changed access int(11) NOT NULL default '0' in C:\Program Files\Apache Group\Apache2\htdocs\includes\database.mysqli.inc on line 116.
* user error: Duplicate entry 'rss.xml' for key 2 query: INSERT INTO url_alias (src, dst) VALUES ('node/feed', 'rss.xml') in C:\Program Files\Apache Group\Apache2\htdocs\includes\database.mysqli.inc on line 116.
* user error: Duplicate column name 'timer' query: ALTER TABLE accesslog ADD timer int(10) unsigned NOT NULL default '0' in C:\Program Files\Apache Group\Apache2\htdocs\includes\database.mysqli.inc on line 116.
* user error: Duplicate column name 'referer' query: ALTER TABLE watchdog ADD COLUMN referer varchar(128) NOT NULL in C:\Program Files\Apache Group\Apache2\htdocs\includes\database.mysqli.inc on line 116.
* user error: Duplicate column name 'theme' query: ALTER TABLE blocks ADD theme varchar(255) NOT NULL default '' in C:\Program Files\Apache Group\Apache2\htdocs\includes\database.mysqli.inc on line 116.
* user error: Table 'node_revisions' already exists query: CREATE TABLE node_revisions ( nid integer NOT NULL default '0', vid integer NOT NULL default '0', uid integer NOT NULL default '0', title varchar(128) NOT NULL default '', body text NOT NULL default '', teaser text NOT NULL default '', log text NOT NULL default '', timestamp integer NOT NULL default '0', format int NOT NULL default '0', PRIMARY KEY (nid,vid)) in C:\Program Files\Apache Group\Apache2\htdocs\includes\database.mysqli.inc on line 116.
* user error: Unknown column 'body' in 'field list' query: INSERT INTO node_revisions SELECT nid, nid AS vid, uid, title, body, teaser, changed AS timestamp, format FROM node in C:\Program Files\Apache Group\Apache2\htdocs\includes\database.mysqli.inc on line 116.
* user error: 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 'SEQUENCE node_revisions_vid_seq INCREMENT 1 START 17' at line 1 query: CREATE SEQUENCE node_revisions_vid_seq INCREMENT 1 START 17 in C:\Program Files\Apache Group\Apache2\htdocs\includes\database.mysqli.inc on line 116.
* user error: Duplicate column name 'vid' query: ALTER TABLE node ADD vid int in C:\Program Files\Apache Group\Apache2\htdocs\includes\database.mysqli.inc on line 116.
* user error: 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 'NOT NULL' at line 1 query: ALTER TABLE node ALTER vid SET NOT NULL in C:\Program Files\Apache Group\Apache2\htdocs\includes\database.mysqli.inc on line 116.
* user error: Duplicate column name 'vid' query: ALTER TABLE files ADD vid int in C:\Program Files\Apache Group\Apache2\htdocs\includes\database.mysqli.inc on line 116.
* user error: 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 'NOT NULL' at line 1 query: ALTER TABLE files ALTER vid SET NOT NULL in C:\Program Files\Apache Group\Apache2\htdocs\includes\database.mysqli.inc on line 116.
* user error: Duplicate column name 'vid' query: ALTER TABLE book ADD vid int in C:\Program Files\Apache Group\Apache2\htdocs\includes\database.mysqli.inc on line 116.
* user error: Duplicate entry '0' for key 1 query: UPDATE book SET vid = 0 in C:\Program Files\Apache Group\Apache2\htdocs\includes\database.mysqli.inc on line 116.
* user error: 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 'NOT NULL' at line 1 query: ALTER TABLE book ALTER vid SET NOT NULL in C:\Program Files\Apache Group\Apache2\htdocs\includes\database.mysqli.inc on line 116.
* user error: Duplicate column name 'vid' query: ALTER TABLE forum ADD vid int in C:\Program Files\Apache Group\Apache2\htdocs\includes\database.mysqli.inc on line 116.
* user error: 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 'NOT NULL' at line 1 query: ALTER TABLE forum ALTER vid SET NOT NULL in C:\Program Files\Apache Group\Apache2\htdocs\includes\database.mysqli.inc on line 116.
* user error: 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 'CONSTRAINT book_pkey' at line 1 query: ALTER TABLE book DROP CONSTRAINT book_pkey in C:\Program Files\Apache Group\Apache2\htdocs\includes\database.mysqli.inc on line 116.
* user error: 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 'CONSTRAINT forum_pkey' at line 1 query: ALTER TABLE forum DROP CONSTRAINT forum_pkey in C:\Program Files\Apache Group\Apache2\htdocs\includes\database.mysqli.inc on line 116.
* user error: 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 'CONSTRAINT files_pkey' at line 1 query: ALTER TABLE files DROP CONSTRAINT files_pkey in C:\Program Files\Apache Group\Apache2\htdocs\includes\database.mysqli.inc on line 116.
* user error: Multiple primary key defined query: ALTER TABLE book ADD PRIMARY KEY (vid) in C:\Program Files\Apache Group\Apache2\htdocs\includes\database.mysqli.inc on line 116.
* user error: Multiple primary key defined query: ALTER TABLE forum ADD PRIMARY KEY (nid) in C:\Program Files\Apache Group\Apache2\htdocs\includes\database.mysqli.inc on line 116.
* user error: Unknown column 'revisions' in 'field list' query: CREATE TABLE old_revisions AS SELECT nid, type, revisions FROM node WHERE revisions != '' in C:\Program Files\Apache Group\Apache2\htdocs\includes\database.mysqli.inc on line 116.
* user error: Unknown column 'log' in 'field list' query: SELECT nid, log FROM book WHERE log != '' in C:\Program Files\Apache Group\Apache2\htdocs\includes\database.mysqli.inc on line 116.
* user error: 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 'TO log_old' at line 1 query: ALTER TABLE book RENAME log TO log_old in C:\Program Files\Apache Group\Apache2\htdocs\includes\database.mysqli.inc on line 116.
* user error: 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 'TO teaser_old' at line 1 query: ALTER TABLE node RENAME teaser TO teaser_old in C:\Program Files\Apache Group\Apache2\htdocs\includes\database.mysqli.inc on line 116.
* user error: 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 'TO body_old' at line 1 query: ALTER TABLE node RENAME body TO body_old in C:\Program Files\Apache Group\Apache2\htdocs\includes\database.mysqli.inc on line 116.
* user error: 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 'TO format_old' at line 1 query: ALTER TABLE node RENAME format TO format_old in C:\Program Files\Apache Group\Apache2\htdocs\includes\database.mysqli.inc on line 116.
* user error: 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 'TO revisions_old' at line 1 query: ALTER TABLE node RENAME revisions TO revisions_old in C:\Program Files\Apache Group\Apache2\htdocs\includes\database.mysqli.inc on line 116.
* user error: Duplicate column name 'sid' query: ALTER TABLE accesslog ADD sid varchar(32) NOT NULL default '' in C:\Program Files\Apache Group\Apache2\htdocs\includes\database.mysqli.inc on line 116.
* user error: Duplicate column name 'description' query: ALTER TABLE files ADD COLUMN description VARCHAR(255) NOT NULL DEFAULT '' in C:\Program Files\Apache Group\Apache2\htdocs\includes\database.mysqli.inc on line 116.
* user error: 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 C:\Program Files\Apache Group\Apache2\htdocs\includes\database.mysqli.inc on line 116.

* main page
* administration pages

2005-04-08: first update since Drupal 4.6.0 release

2005-04-10

2005-04-11

2005-04-14

2005-04-24

2005-04-30

ALTER TABLE {blocks} RENAME types TO types_old
FAILED

2005-05-06

2005-05-08

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

2005-05-09

2005-05-10

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

2005-05-11

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

2005-05-12

2005-05-22

2005-07-29

ALTER TABLE {watchdog} ADD COLUMN referer varchar(128) NOT NULL
FAILED

2005-07-30

2005-08-08

2005-08-15

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

2005-08-25

CREATE TABLE {node_revisions} (
nid integer NOT NULL default '0',
vid integer NOT NULL default '0',
uid integer NOT NULL default '0',
title varchar(128) NOT NULL default '',
body text NOT NULL default '',
teaser text NOT NULL default '',
log text NOT NULL default '',
timestamp integer NOT NULL default '0',
format int NOT NULL default '0',
PRIMARY KEY (nid,vid))
FAILED
INSERT INTO {node_revisions}
SELECT nid, nid AS vid, uid, title, body, teaser, changed AS timestamp, format
FROM {node}
FAILED
CREATE INDEX {node_revisions}_uid_idx ON {node_revisions}(uid)
OK
CREATE SEQUENCE {node_revisions}_vid_seq INCREMENT 1 START 17
FAILED
ALTER TABLE {node} ADD vid int
FAILED
ALTER TABLE {node} ALTER vid SET default 0
OK
UPDATE {node} SET vid = 0
OK
ALTER TABLE {node} ALTER vid SET NOT NULL
FAILED
ALTER TABLE {files} ADD vid int
FAILED
ALTER TABLE {files} ALTER vid SET default 0
OK
UPDATE {files} SET vid = 0
OK
ALTER TABLE {files} ALTER vid SET NOT NULL
FAILED
ALTER TABLE {book} ADD vid int
FAILED
ALTER TABLE {book} ALTER vid SET default 0
OK
UPDATE {book} SET vid = 0
FAILED
ALTER TABLE {book} ALTER vid SET NOT NULL
FAILED
ALTER TABLE {forum} ADD vid int
FAILED
ALTER TABLE {forum} ALTER vid SET default 0
OK
UPDATE {forum} SET vid = 0
OK
ALTER TABLE {forum} ALTER vid SET NOT NULL
FAILED
ALTER TABLE {book} DROP CONSTRAINT {book}_pkey
FAILED
ALTER TABLE {forum} DROP CONSTRAINT {forum}_pkey
FAILED
ALTER TABLE {files} DROP CONSTRAINT {files}_pkey
FAILED
UPDATE {node} SET vid = nid
OK
UPDATE {forum} SET vid = nid
OK
UPDATE {book} SET vid = nid
OK
UPDATE {files} SET vid = nid
OK
ALTER TABLE {book} ADD PRIMARY KEY (vid)
FAILED
ALTER TABLE {forum} ADD PRIMARY KEY (nid)
FAILED
CREATE TABLE {old_revisions} AS SELECT nid, type, revisions FROM {node} WHERE revisions != ''
FAILED
CREATE INDEX {node}_vid_idx ON {node}(vid)
OK
CREATE INDEX {forum}_vid_idx ON {forum}(vid)
OK
CREATE INDEX {files}_fid_idx ON {files}(fid)
OK
CREATE INDEX {files}_vid_idx ON {files}(vid)
OK
ALTER TABLE {book} RENAME log TO log_old
FAILED
ALTER TABLE {node} RENAME teaser TO teaser_old
FAILED
ALTER TABLE {node} RENAME body TO body_old
FAILED
ALTER TABLE {node} RENAME format TO format_old
FAILED
ALTER TABLE {node} RENAME revisions TO revisions_old
FAILED

2005-09-07

2005-09-18

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

2005-09-27

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

2005-10-15

DELETE FROM {variable} WHERE name = 'node_cron_last'
OK
DELETE FROM {variable} WHERE name = 'minimum_word_size'
OK
DELETE FROM {variable} WHERE name = 'remove_short'
OK
DELETE FROM {node_counter} WHERE nid = 0
OK
DROP TABLE {search_index}
OK
DROP TABLE {search_total}
OK
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)
)
FAILED
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)
)
OK
CREATE TABLE {search_total} (
word varchar(50) NOT NULL default '',
count float default NULL,
PRIMARY KEY word (word)
)
OK

2005-10-23

INSERT INTO {menu} (mid, pid, path, title, description, weight, type) VALUES (177, 0, '', 'Primära länkar', '', 0, 115)
OK
INSERT INTO {menu} (mid, pid, path, title, description, weight, type) VALUES (178, 0, '', 'Sekundära länkar', '', 0, 115)
OK
UPDATE {system} SET status = 1 WHERE name = 'menu'
OK

2005-10-28

2005-11-03

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

2005-11-14

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

2005-11-27

Updates were attempted. If you see no failures above, you may proceed happily to the administration pages. Otherwise, you may need to update your database manually.

if someone has access he or she might want to remove the above flooded post and watch it on this external link: http://www.klydd.se/.drupal.update

Sorry for the inconvenience.

Since 4.7 is out and all that, this issue is obsolete.