Author: t.rother
Description:
The upgrade process does not work as smooth as described in UPGRADE text. I used
the following upgrade procedure and had reproducible errors :
- Create database dump: mysqldump --default-character-set=latin1
gaia_wikintern>gaia_wikintern_latin1.sql -p
- Make copy of that database: mysql gaia_wikintern15<gaia_wikintern_latin1.sql -p
- 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()
....
- 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.
Version: 1.5.x
Severity: major
OS: Linux
Platform: PC