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