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: agarr...@wikimedia.org
        ReportedBy: urbanvint...@gmail.com
                CC: bhar...@wikimedia.org


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
Wikibugs-l@lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/wikibugs-l

Reply via email to