https://bugzilla.wikimedia.org/show_bug.cgi?id=26517
Summary: On install - Database returned error 1071: Specified
key was too long;
Product: MediaWiki extensions
Version: any
Platform: All
OS/Version: All
Status: NEW
Severity: critical
Priority: Normal
Component: LiquidThreads
AssignedTo: [email protected]
ReportedBy: [email protected]
CC: [email protected]
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)"
--
Configure bugmail: https://bugzilla.wikimedia.org/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are on the CC list for the bug.
_______________________________________________
Wikibugs-l mailing list
[email protected]
https://lists.wikimedia.org/mailman/listinfo/wikibugs-l
