-----BEGIN PGP SIGNED MESSAGE----- Hash: RIPEMD160
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@turnstep.com PGP Key: 0x14964AC8 200704160927 http://biglumber.com/x/web?pk=2529DF6AB8F79407E94445B4BC9B906714964AC8