[Mediawiki-l] conifg script failed on creating categorylinks table

Wed Mar 9 20:03:52 UTC 2005

Hi,

config/index.php has failed on creating table

I tried piece of maintanance/tables.sql
in mysql

mysql> CREATE TABLE /*$wgDBprefix*/categorylinks (
    ->   cl_from int(8) unsigned NOT NULL default '0',
    ->   cl_to varchar(255) binary NOT NULL default '',
    ->   cl_sortkey varchar(255) binary NOT NULL default '',
    ->   cl_timestamp timestamp NOT NULL,
    ->   UNIQUE KEY cl_from(cl_from,cl_to),
    ->   KEY cl_sortkey(cl_to,cl_sortkey(128)),
    ->   KEY cl_timestamp(cl_to,cl_timestamp)
    -> );
ERROR 1071 (42000): Specified key was too long; max key length is 1024 bytes
mysql>

mediawiki version 1.4rc1
mysql version 4.1.10.

What should be changed in mysql config in order not to bump in limitation.

Thank in advance.

--Nick Zhokhov 