Last modified: 2010-05-15 15:42:44 UTC
I install MediaWiki v1.8.2 on MySQL v5.0.27 with option "Experimental MySQL 4.1/5.0 UTF-8" enabled and have error: ERROR 1089 (HY000): Incorrect sub part key; the used key part isn't a string, the used length is longer than the key part, or the storage engine doesn't support unique sub keys on query: CREATE TABLE ipblocks ( ... ipb_address varchar(40) binary NOT NULL default '', ... UNIQUE INDEX ipb_address (ipb_address(255), ipb_user, ipb_auto, ipb_anon_only), ... ) Fix: change maintenance/mysql5/tables.sql from UNIQUE INDEX ipb_address (ipb_address(255), ipb_user, ipb_auto, ipb_anon_only), to UNIQUE INDEX ipb_address (ipb_address(40), ipb_user, ipb_auto, ipb_anon_only),
*** This bug has been marked as a duplicate of 6737 ***