Last modified: 2007-07-02 16:34:13 UTC

Wikimedia Bugzilla is closed!

Wikimedia migrated from Bugzilla to Phabricator. Bug reports are handled in Wikimedia Phabricator.
This static website is read-only and for historical purposes. It is not possible to log in and except for displaying bug reports and their history, links might be broken. See T12435, the corresponding Phabricator task for complete and up-to-date bug report information.
Bug 10435 - (utf8 problem+solution) The upgrade process doesn't truncate oi_archive_name
(utf8 problem+solution) The upgrade process doesn't truncate oi_archive_name
Status: RESOLVED FIXED
Product: MediaWiki
Classification: Unclassified
Database (Other open bugs)
1.11.x
All All
: Normal normal (vote)
: ---
Assigned To: Nobody - You can work on this!
: patch, patch-need-review
Depends on:
Blocks:
  Show dependency treegraph
 
Reported: 2007-07-02 14:31 UTC by Joel-Alexis Bialkiewicz
Modified: 2007-07-02 16:34 UTC (History)
1 user (show)

See Also:
Web browser: ---
Mobile Platform: ---
Assignee Huggle Beta Tester: ---


Attachments
Patch (848 bytes, patch)
2007-07-02 14:31 UTC, Joel-Alexis Bialkiewicz
Details

Description Joel-Alexis Bialkiewicz 2007-07-02 14:31:05 UTC
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)),
Comment 1 Tim Starling 2007-07-02 16:34:13 UTC
Fixed in r23650.

Note You need to log in before you can comment on or make changes to this bug.


Navigation
Links