Maniphest T21164

AntiSpoof index exceeds 1000 byte limit
Closed, DuplicatePublic
Actions

Assigned To

None

Authored By

	• bzimport
	Jun 11 2009, 5:54 PM

Tags

Referenced Files

	F5808: mediawiki-bug.png
	May 22 2018, 6:24 PM

Subscribers

Description

Author: omega13a

Description:
Screen shot of the error

When I tried to run the upgrade script I got, after an alert the script tried to increase memory_limit to above the allowed limit, something about REMOTE_ADDR not being set, and an unexpected REMOTE_USER authentication failure, an SQL error 1071 when creating the table fedtrek_wiki_spoofuser. Attached is a screen shot of the error. If it helps, the server the wiki is on runs CentOS 5, MySQL 5.1.35, and PHP 5.2.9 with Suhosin-patch 0.9.7, APD 1.0.1, XDebug 2.0.4, and Sushosin 0.9.27.

Attached:

mediawiki-bug.png (900×1 px, 160 KB)

Details

Reference: bz19164

Related Objects

Mentioned In: T193532: [AntiSpoof] sql/patch-antispoof.mysql.sql : Error: 1071 Specified key was too long; max key length is 767 bytes

Event Timeline

• bzimport raised the priority of this task from to Low.Nov 21 2014, 10:41 PM

• bzimport added a project: AntiSpoof.

• bzimport set Reference to bz19164.

• bzimport added a subscriber: Unknown Object (MLST).

• bzimport created this task.Jun 11 2009, 5:54 PM

Updated summary per screenshot. When the charset is UTF-8, the su_normalized index is 255*3*2 = 1530 bytes, exceeding the common 1000 byte limit.

Umherirrender mentioned this in T193532: [AntiSpoof] sql/patch-antispoof.mysql.sql : Error: 1071 Specified key was too long; max key length is 767 bytes.May 19 2018, 10:26 AM

MarcoAurelio updated the task description. (Show Details)May 22 2018, 6:24 PM

MarcoAurelio removed a subscriber: • wikibugs-l-list.

MarcoAurelio added subscribers: Aklapper, MarcoAurelio.

Liuxinyu970226 closed this task as a duplicate of T193532: [AntiSpoof] sql/patch-antispoof.mysql.sql : Error: 1071 Specified key was too long; max key length is 767 bytes.Feb 22 2019, 6:15 AM