Bureaucrats, emailconfirmed, Administrators
436
edits
Changes
add upgrade notice
==New installations==
The current MediaWiki install, 1.7.1 · 2006-07-08, will run into two problems upon trying to initialize all the initial MySQL tables if those tables are encoded in UTF8. The reason this happens is that KEY fields are limited to 1000 bytes, and each character takes up 3 bytes in UTF. When the key fields contain a combination of columns whose combined number of bytes exceeds 1000, the installation will bail.
This guarantees that they keys are short enough so that the install won't bail.
==Upgrades==
Upgrades are plagued by the same problem and require a similar workaround. However, the files to patch are '''/maintenance/archives/patch-categorylinks.sql''' and '''/maintenance/archives/patch-job.sql''', respectively.
==References==
