Page MenuHomePhabricator

"Specified key was too long" database error on install
Closed, ResolvedPublic

Description

Author: marcus

Description:
I'm trying to install MediaWiki 1.5.6 within a sourceforge account (which has PHP 4.3.10 and MySQL 4.1.12). I've sorted out configuration, but on
install I get this SQL error:

Creating tables... using MySQL 3/4 table defs...Query "CREATE TABLE mw_categorylinks ( cl_from int(8) unsigned NOT NULL default '0', cl_to varchar
(255) binary NOT NULL default '', cl_sortkey varchar(86) binary NOT NULL default '', cl_timestamp timestamp NOT NULL, UNIQUE KEY cl_from
(cl_from,cl_to), KEY cl_sortkey(cl_to,cl_sortkey), KEY cl_timestamp(cl_to,cl_timestamp) ) TYPE=InnoDB" failed with error code "Specified key was too
long; max key length is 1000 bytes".

Given that this is > MySQL 4.1, I've also tried the 'experimental' 4.1/5 option, but I get the same error.


Version: 1.5.x
Severity: blocker
OS: Linux

Details

Reference
bz5123

Event Timeline

bzimport raised the priority of this task from to Medium.Nov 21 2014, 9:08 PM
bzimport set Reference to bz5123.
bzimport added a subscriber: Unknown Object (MLST).

marcus wrote:

Ah. Dang. This is the same as bug 4445. I tried switching the collation to latin1_general_ci and it worked.

*** This bug has been marked as a duplicate of 4445 ***