[Mediawiki-l] patch-backlinkindexes.sql

[Brion Vibber]

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Fred Bauder wrote:
> I received the following error while installing Mediawiki-1.9.3 while updating an existing database:
> 
> Query "ALTER TABLE `imagelinks`
> DROP INDEX il_to,
> ADD INDEX il_to(il_to, il_from)
> " failed with error code "Specified key was too long. Max key length is 500 (mysql.ibiblio.org)".

Sounds like you're running an old version of MySQL without InnoDB
support? In relatively modern installations the limit should be 1000
bytes for MyISAM, 1024 for InnoDB iirc.

Try upgrading / enabling InnoDB and changing the table to InnoDB...

- -- brion vibber (brion @ wikimedia.org)
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.3 (GNU/Linux)
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org

iD8DBQFGAUv+wRnhpk1wk44RAmRYAKCDbja5ZREXxImtON+BUp9Q49/s1gCgy7Bo
TWYEcLknO4K24g2h28UgaeY=
=LPtF
-----END PGP SIGNATURE-----