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
On Wed, 9 Mar 2005 23:03:52 +0300, Nick Zhokhov zhokhov@intersystems.ru wrote:
-> 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>
What's your default charset for MySQL tables? With "default-character-set=utf8" I experienced the same problem:
http://mail.wikipedia.org/pipermail/mediawiki-l/2005-February/003370.html
Hi,
Exactly, I had "default-character-set=utf8" because I need unicode. Thank! Will try something simplier like pure english.
--Nick Zhokhov
----- Original Message ----- From: "Juanma Barranquero" lekktu@gmail.com To: "Nick Zhokhov" zhokhov@intersystems.ru; "MediaWiki announcements and site admin list" mediawiki-l@wikimedia.org Sent: Wednesday, March 09, 2005 11:17 PM Subject: Re: [Mediawiki-l] conifg script failed on creating categorylinks table
On Wed, 9 Mar 2005 23:03:52 +0300, Nick Zhokhov zhokhov@intersystems.ru wrote:
-> 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>
What's your default charset for MySQL tables? With "default-character-set=utf8" I experienced the same problem:
http://mail.wikipedia.org/pipermail/mediawiki-l/2005-February/003370.html
-- /L/e/k/t/u
Nick Zhokhov wrote:
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.
Set default charset to latin1 instead of utf8.
-- brion vibber (brion @ pobox.com)
Hi,
I get the same error, max key is 500. In which files are these changes necessary to make it work with an old version of mysql (3.23.58)? Actually, while I could install 1.4.4 on this same machine, I couldn't install 1.5alpha1. It says max key length is 500 chars. Although I don't admin this machine, I can get the admin to make a couple changes. Would it work this way?
Brion Vibber wrote:
Nick Zhokhov wrote:
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.
Set default charset to latin1 instead of utf8.
-- brion vibber (brion @ pobox.com)
MediaWiki-l mailing list MediaWiki-l@Wikimedia.org http://mail.wikipedia.org/mailman/listinfo/mediawiki-l
mediawiki-l@lists.wikimedia.org