Wikimedia Bugzilla is closed!

The site uses MySQL MyISAM tables with utf8_general_ci collation.

MySQL settings in LocalSettings.php:

# MySQL table options to use during installation or update
$wgDBTableOptions   = "ENGINE=MyISAM, DEFAULT CHARSET=utf8";

# Experimental charset support for MySQL 4.1/5.0.
$wgDBmysql5 = false;

While running php update.php I get the following error:
Creating globaltemplatelinks table...A database query syntax error has occurred.

The last attempted database query was:
"CREATE UNIQUE INDEX gtl_to_from ON `wiki_globaltemplatelinks` (gtl_to_prefix, g
tl_to_namespace, gtl_to_title, gtl_from_wiki, gtl_from_page)
"
from within function "DatabaseBase::sourceFile( E:\www\phase3/maintenance/archiv
es/patch-globaltemplatelinks.sql )".
Database returned error "1071: Specified key was too long; max key length is 100
0 bytes (localhost)"

Fixed it by changing the indexs to:
CREATE UNIQUE INDEX /*i*/gtl_to_from ON /*_*/globaltemplatelinks (gtl_to_prefix, gtl_to_namespace, gtl_to_title(196), gtl_from_wiki, gtl_from_page);
CREATE UNIQUE INDEX /*i*/gtl_from_to ON /*_*/globaltemplatelinks (gtl_from_wiki, gtl_from_page, gtl_to_prefix, gtl_to_namespace, gtl_to_title(196));

However I feel it is not good, because the index is unique.