Last modified: 2012-04-12 13:54:18 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 T22953, the corresponding Phabricator task for complete and up-to-date bug report information.
Bug 20953 - Upgrade from 1.10 to 1.16 broke redirect table
Upgrade from 1.10 to 1.16 broke redirect table
Status: RESOLVED FIXED
Product: MediaWiki
Classification: Unclassified
Database (Other open bugs)
1.16.x
Other Linux
: Normal normal (vote)
: ---
Assigned To: Nobody - You can work on this!
: easy
Depends on:
Blocks:
  Show dependency treegraph
 
Reported: 2009-10-02 15:46 UTC by Pirabu Pathmasenan
Modified: 2012-04-12 13:54 UTC (History)
3 users (show)

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


Attachments

Description Pirabu Pathmasenan 2009-10-02 15:46:11 UTC
We have mediawiki 1.10 and we upgrade straight to 1.16 alpha version and we are missing the last to columns in the redirect table(rd_interwiki,rd_fragment)after the upgrade.

So we are left with the first 3 columns only

CREATE TABLE redirect (
  rd_from       INTEGER  NOT NULL  PRIMARY KEY,
  --REFERENCES page(page_id) ON DELETE CASCADE,
  rd_namespace  SMALLINT NOT NULL  DEFAULT 0,
  rd_title      VARCHAR(255)     NOT NULL DEFAULT '',
  rd_interwiki  varchar(32),
  rd_fragment   VARCHAR(255)<-last 2 rows not in mySQL db );
);

Can somone look into this and fix this .. we need to ensure that all columns + data are moved over when we do the upgrade from 1.10 to 1.16
Comment 1 Roan Kattouw 2009-10-02 17:38:31 UTC
Have you run maintenance/update.php after upgrading? See [[mw:Manual:Upgrading#Run the update script]]
Comment 2 Alexandre Emsenhuber [IAlex] 2009-10-02 17:57:38 UTC
rd_interwiki/rd_fragment aren't in mysql's update list, but since they're not used, it's not a blocker bug.
Comment 3 Chad H. 2009-10-02 18:00:42 UTC
+easy

Patch already exists, needs to be added to mySQL update list.
Comment 4 Pirabu Pathmasenan 2009-10-02 19:35:15 UTC
when will it be added to update list (update.php) ? or can i get a version of that patch file ?
Comment 5 Max Semenik 2009-10-02 19:43:13 UTC
You can run maintenance/archives/patch-rd_interwiki.sql manually.
Comment 6 Chad H. 2009-10-02 22:17:16 UTC
Added to mySQL updaters in r57308.

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


Navigation
Links