Page MenuHomePhabricator

codereview.sql not utf-8 clean
Closed, DeclinedPublic


Author: ewetoo

Running MySQL 5.051a-24 configured for utf8 on a Debian Linux box. Mediawiki 1.16alpha r58426.

Get the following error on loading codereview.sql:

ERROR 1071 (42000) at line 79: Specified key was too long; max key length is 1000 bytes

The culprit is:

unique key (ca_user_text, ca_repo_id, ca_author); in table code_authors

which appears to be too long for my utf8 installation.

Tested the table without the key and the extension will run with broken functionality.

Version: unspecified
Severity: critical
OS: Linux
Platform: PC
See Also: T11350: update.php -> SQL error, T6445: Specified key was too long



Event Timeline

bzimport raised the priority of this task from to Low.Nov 21 2014, 10:49 PM
bzimport set Reference to bz21407.
bzimport added a subscriber: Unknown Object (MLST).

ewetoo wrote:

By removing it in initial import and then adding it alternatively in phpmyadmin with collate latin1_bin and utf8_bin i can confirm that utf8 encoding breaks the unique key.

Is this fixed since its been 6 years since this bug was reported with no discussion for 6 years.

Aklapper claimed this task.
Aklapper updated the task description. (Show Details)
Aklapper set Security to None.

We don't know but let's assume it is, seeing T11350 and T6445.