[Mediawiki-l] patch-backlinkindexes.sql

[Fred Bauder]

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)".

This coding appears to come from patch-backlinkindexes.sql

ALTER TABLE /*$wgDBprefix*/pagelinks
   DROP INDEX pl_namespace,
   ADD INDEX pl_namespace(pl_namespace, pl_title, pl_from);

ALTER TABLE /*$wgDBprefix*/templatelinks
   DROP INDEX tl_namespace,
   ADD INDEX tl_namespace(tl_namespace, tl_title, tl_from);
   
ALTER TABLE /*$wgDBprefix*/imagelinks
   DROP INDEX il_to,
   ADD INDEX il_to(il_to, il_from);

Any suggestions?

Fred