Author: tps
Description:
I have tried to migrate my mediawiki from MySQL 4.0.26 to MySQL
5.0.19. But this fails at two tables. I can import these to
MySQL 4.0.26, but not to MySQL 5.0.19:
DROP TABLE IF EXISTS wiki-adm.cur;
CREATE TABLE wiki-adm.cur (
`cur_id` INT(8) NOT NULL, `cur_namespace` TINYINT(2) NOT NULL DEFAULT '0', `cur_title` VARCHAR(255) NOT NULL, `cur_text` MEDIUMTEXT NOT NULL, `cur_comment` TINYBLOB NOT NULL, `cur_user` INT(5) NOT NULL DEFAULT '0', `cur_user_text` VARCHAR(255) NOT NULL, `cur_timestamp` VARCHAR(14) NOT NULL, `cur_restrictions` TINYBLOB NOT NULL, `cur_counter` BIGINT(20) NOT NULL DEFAULT '0', `cur_is_redirect` TINYINT(1) NOT NULL DEFAULT '0', `cur_minor_edit` TINYINT(1) NOT NULL DEFAULT '0', `cur_is_new` TINYINT(1) NOT NULL DEFAULT '0', `cur_random` DOUBLE(0, 0) NOT NULL DEFAULT '0', `cur_touched` VARCHAR(14) NOT NULL, `inverse_timestamp` VARCHAR(14) NOT NULL, PRIMARY KEY (`cur_id`), UNIQUE INDEX `name_title` (`cur_namespace`, `cur_title`), INDEX `cur_title` (`cur_title`(20)), INDEX `cur_timestamp` (`cur_timestamp`), INDEX `cur_random` (`cur_random`), INDEX `name_title_timestamp` (`cur_namespace`, `cur_title`,
inverse_timestamp),
INDEX `user_timestamp` (`cur_user`, `inverse_timestamp`), INDEX `usertext_timestamp` (`cur_user_text`, `inverse_timestamp`), INDEX `namespace_redirect_timestamp` (`cur_namespace`,
cur_is_redirect, cur_timestamp)
)
ENGINE = INNODB;
Leads to "Display width out of range for column 'cur_random'
(max=255)". In tune the table is only partly created (the column
"cur_random" is missing). The Table is useless for mediamiki.
Trying to access this database leads to various errors
about missing data or incorrect SQL statements (unknown column).
At the moment this makes it impossible to migrate from MySQL 4.0.x to 5.0.x
whithout breaking the whole existing wiki at my site.
Version: 1.5.x
Severity: major
OS: Windows Server 2003
Platform: PC