Author: questpc

Description:
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.

Version: 1.20.x
Severity: normal
OS: Windows Server 2003