Author: urbanvintner
Description:
Running MediaWiki 1.16.0
MySQL 5.1.50
Collation set to utf8-unicode-ci
Suggestions?
Full error output follows
Creating thread table...A database query syntax error has occurred.
The last attempted database query was:
"CREATE TABLE thread (
thread_id int(8) unsigned NOT NULL auto_increment,
thread_root int(8) unsigned UNIQUE NOT NULL,
thread_ancestor int(8) unsigned NOT NULL,
thread_parent int(8) unsigned NULL,
thread_summary_page int(8) unsigned NULL,
thread_subject varchar(255) NULL,
thread_author_id int unsigned NULL,
thread_author_name varchar(255) NULL,
thread_modified char(14) binary NOT NULL default '',
thread_created char(14) binary NOT NULL default '',
thread_editedness int(1) NOT NULL default 0,
thread_article_namespace int NOT NULL,
thread_article_title varchar(255) binary NOT NULL,
thread_article_id int(8) unsigned NOT NULL,
thread_type int(4) unsigned NOT NULL default 0,
thread_sortkey varchar(255) NOT NULL default '',
thread_replies int(8) DEFAULT -1,
thread_signature TINYBLOB NULL,
PRIMARY KEY thread_id (thread_id),
UNIQUE INDEX thread_root_page (thread_root),
INDEX thread_ancestor (thread_ancestor, thread_parent),
INDEX thread_article_title (thread_article_namespace, thread_article_title, thread_sortkey),
INDEX thread_article (thread_article_id, thread_sortkey),
INDEX thread_modified (thread_modified),
INDEX thread_created (thread_created),
INDEX thread_summary_page (thread_summary_page),
INDEX (thread_author_id,thread_author_name),
INDEX (thread_sortkey)
) ENGINE=InnoDB, DEFAULT CHARSET=utf8
"
from within function "DatabaseBase::sourceStream".
Database returned error "1071: Specified key was too long; max key length is 1000 bytes (localhost)"
Version: REL1_19-branch
Severity: critical