[Mediawiki-l] SQL error..

[Thomas, Arjun]

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