[Mediawiki-l] SQL error..
Thomas, Arjun
Arjun.Thomas at ps.net
Tue Apr 17 08:25:58 UTC 2007
Much appreciate this Greg... will see if I can implement this somehow.
- AJ
-----Original Message-----
From: mediawiki-l-bounces at lists.wikimedia.org
[mailto:mediawiki-l-bounces at lists.wikimedia.org] On Behalf Of Greg
Sabino Mullane
Sent: Monday, April 16, 2007 7:02 PM
To: mediawiki-l at lists.wikimedia.org
Subject: Re: [Mediawiki-l] SQL error..
* PGP Signed by an unknown key
> I'm trying to install the new version of mediawiki
> ( 1.9.3 ) on my host. However i get the following error message.
>
> Creating job table...Query "CREATE TABLE `job` (
...
> ) TYPE=InnoDB
> " failed with error code "Specified key was too long; max key
> length is 1024 bytes
>
MySQL has a bug in which it counts bytes, not characters, when
calculating the key length. Thus, something that works fine in
a single-byte-per-character character set suddenly fails when you
switch to a multi-byte character set such as utf-8.
One solution (besides abandoning utf-8 or MySQL) is to redefine the
index in question to use smaller values. A quick google search found
this example:
PRIMARY KEY job_id (job_id),
KEY (job_cmd (160), job_namespace, job_title (160))
HTH,
--
Greg Sabino Mullane greg at turnstep.com
PGP Key: 0x14964AC8 200704160927
http://biglumber.com/x/web?pk=2529DF6AB8F79407E94445B4BC9B906714964AC8
* Unknown Key
* 0x14964AC8(L)
_______________________________________________
MediaWiki-l mailing list
MediaWiki-l at lists.wikimedia.org
http://lists.wikimedia.org/mailman/listinfo/mediawiki-l
More information about the MediaWiki-l
mailing list