Wikimedia Bugzilla is closed!

Created attachment 3865 [details]
Patch

I created this report because I can't commit to the svn. I trust one of the developpers to do it after testing, but it works for me.

Problem : When you create the table from scrach, the script contains truncation.

maintenance/tables.sql lines 728-729:
  -- oi_archive_name truncated to 14 to avoid key length overflow
  INDEX oi_name_archive_name (oi_name,oi_archive_name(14))

But when you try to upgrade, the script doesn't so it stops, leaving the database in an unusable state.

maintenance/archives/patch-oi_metadata.sql line 11:
   ADD INDEX oi_name_archive_name (oi_name,oi_archive_name),


Solution : Replace maintenance/archives/patch-oi_metadata.sql line 11 by:
   ADD INDEX oi_name_archive_name (oi_name,oi_archive_name(14)),