Last modified: 2010-05-15 15:38:25 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 T5952, the corresponding Phabricator task for complete and up-to-date bug report information.
Bug 3952 - Update 1.3.7 to 1.5.2 fails
Update 1.3.7 to 1.5.2 fails
Status: RESOLVED INVALID
Product: MediaWiki
Classification: Unclassified
Installer (Other open bugs)
1.5.x
PC Linux
: Normal major (vote)
: ---
Assigned To: Nobody - You can work on this!
:
Depends on:
Blocks:
  Show dependency treegraph
 
Reported: 2005-11-13 11:32 UTC by Thommie Rother
Modified: 2010-05-15 15:38 UTC (History)
0 users

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


Attachments

Description Thommie Rother 2005-11-13 11:32:52 UTC
The upgrade process does not work as smooth as described in UPGRADE text. I used
the following upgrade procedure and had reproducible errors :

1. Create database dump: mysqldump --default-character-set=latin1
gaia_wikintern>gaia_wikintern_latin1.sql -p

2. Make copy of that database: mysql gaia_wikintern15<gaia_wikintern_latin1.sql -p

3. On the commandline run maintenance/upgrade1_5.php. It shows the following
error msg:

....
Checking for duplicate accounts...
Found 0 accounts with duplicate records on gaia_wikintern15.

It is now safe to apply the unique index on user_name.
2005-11-13 10:52:12: Migrating user table to user_temp...
A database error has occurred
Query: SELECT
user_id,user_name,user_real_name,user_password,user_newpassword,user_email,user_options,user_token
 FROM `user`
Function: FiveUpgrade::copyTable
Error: 1054 Unknown column 'user_token' in 'field list' (localhost)

Backtrace:
GlobalFunctions.php line 451 calls wfbacktrace()
Database.php line 408 calls wfdebugdiebacktrace()
Database.php line 358 calls database::reportqueryerror()
Database.php line 734 calls database::query()
FiveUpgrade.inc line 295 calls database::select()
FiveUpgrade.inc line 626 calls fiveupgrade::copytable()
FiveUpgrade.inc line 49 calls fiveupgrade::upgradeuser()
upgrade1_5.php line 22 calls fiveupgrade::upgrade() 
....

4. Run mainetance/update.php. Error msg:

Initialising "MediaWiki" namespace...
A database error has occurred
Query: SELECT old_text,old_flags  FROM `text`  WHERE old_id = '4399'  LIMIT 1
Function: Revision::loadText
Error: 1146 Table 'gaia_wikintern15.text' doesn't exist (localhost)

Backtrace:
GlobalFunctions.php line 451 calls wfbacktrace()
Database.php line 408 calls wfdebugdiebacktrace()
Database.php line 358 calls databasemysql::reportqueryerror()
Database.php line 734 calls databasemysql::query()
Database.php line 753 calls databasemysql::select()
Revision.php line 574 calls databasemysql::selectrow()
Revision.php line 370 calls revision::loadtext()
InitialiseMessages.inc line 185 calls revision::gettext()
InitialiseMessages.inc line 72 calls initialisemessagesreal()
updaters.inc line 670 calls initialisemessages()
index.php line 609 calls do_all_updates()

If I add this table manually from the tables.sql (
CREATE TABLE `text` (
  `old_id` int(8) unsigned NOT NULL auto_increment,
  `old_text` mediumblob NOT NULL,
  `old_flags` tinyblob NOT NULL,
  PRIMARY KEY  (`old_id`)
) TYPE=InnoDB AUTO_INCREMENT=1 ;)

and run update.php afterwards, I get no errors during that script. But finally I
have a wiki with empty pages.

Environment data:
- mysqld Ver 4.0.15 for suse-linux on i686
- PHP 4.3.3 linux

Note: http://bugzilla.wikipedia.org/show_bug.cgi?id=3518 describes more or less
the same problems with an upgrade 1.4.9 >> 1.5rc4. 

For debugging: I have some time today for IRC.
Comment 1 Brion Vibber 2005-11-16 22:34:01 UTC
Run update.php for general upgrades.

upgrade1_5.php is a special-purpose *partial* migrator for 1.4->1.5 only. It will not work with1.3 
It may not work with early 1.4.

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


Navigation
Links