[Mediawiki-l] Eror installing: Specified key was too long

Willem W.Koster at rug.nl
Mon Nov 21 15:52:20 UTC 2005


I just tried to do a clean install on a new server and got the following error: 


Quote: 
MediaWiki 1.5.2 installation 
Please include all of the lines below when reporting installation problems. 

Checking environment... 
PHP 5.0.5: ok 
Warning: PHP's register_globals option is enabled. MediaWiki will work correctly, but this setting increases your
exposure to potential security vulnerabilities in PHP-based software running on your server. You should disable it if
you are able. PHP server API is apache2handler; ok, using pretty URLs (index.php/Page_Title) 
Have XML / Latin1-UTF-8 conversion support. 
PHP's memory_limit is 128M. If this is too low, installation may fail! 
Have zlib support; enabling output compression. 
Neither Turck MMCache nor eAccelerator are installed, can't use object caching functions 
Found GNU diff3: /usr/bin/diff3. 
Found GD graphics library built-in, image thumbnailing will be enabled if you enable uploads. 
Installation directory: /home/data/www/willem/mediawiki 
Script URI path: /willem/mediawiki 
Trying to connect to MySQL on localhost as root... 
MySQL error 1045: Access denied for user 'root'@'localhost' (using password: NO) 
Trying regular user... ok. 
Connected to 4.1.14; enabling MySQL 4 enhancements 
Database wikitest exists 
Creating tables... using MySQL 3/4 table defs...Query "CREATE TABLE 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".  



any idea what is wrong ?

Regards,



More information about the MediaWiki-l mailing list