Last modified: 2010-05-15 15:38:03 UTC
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.
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 ***