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

[Willem Koster]

Wel yes, but since I'm doing nothing specific, just installing the software 
as per the book, why am I getting this error whilest all other installations 
seem to be going as planned.

Could it be a MySQL-5 thing ? (I think we have 5 running on that system, I 
just thought of it).

Willem.


----- Original Message ----- 
From: "Rob Church" <robchur at gmail.com>


Seems InnoDB has some sort of limit on key lengths established which
is preventing MediaWiki from creating part of a table.


Rob Church

On 21/11/05, Willem <W.Koster at rug.nl> wrote:
> 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,
> _______________________________________________
> MediaWiki-l mailing list
> MediaWiki-l at Wikimedia.org
> http://mail.wikipedia.org/mailman/listinfo/mediawiki-l
>
_______________________________________________
MediaWiki-l mailing list
MediaWiki-l at Wikimedia.org
http://mail.wikipedia.org/mailman/listinfo/mediawiki-l