Last modified: 2011-04-04 21:28:17 UTC
I'm attempting to upgrade from 1.4.9 to 1.5rc4 to get around the PHP trouble with passing variables. Starting in a clean directory and attempting to run the installer, I get: MediaWiki is Copyright (C) 2001-2005 by Magnus Manske, Brion Vibber, Lee Daniel Crocker, Tim Starling, Erik Möller, Gabriel Wicke and others. * Readme * Release notes * doc/ * User's Guide This program is free software; you can redistribute it and/or modify it under the terms of the GNU General Public License as published by the Free Software Foundation; either version 2 of the License, or (at your option) any later version. This program is distributed in the hope that it will be useful, but WITHOUT ANY WARRANTY; without even the implied warranty of MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the GNU General Public License for more details. You should have received a copy of the GNU General Public License along with this program; if not, write to the Free Software Foundation, Inc., 59 Temple Place - Suite 330, Boston, MA 02111-1307, USA. or read it online MediaWiki 1.5rc4 installation Please include all of the lines below when reporting installation problems. Checking environment... * PHP 5.0.5: ok * PHP server API is apache2handler; ok, using pretty URLs (index.php/Page_Title) * Have XML / Latin1-UTF-8 conversion support. * PHP is configured with no memory_limit. * No zlib support. * Neither Turck MMCache nor eAccelerator are installed, can't use object caching functions * GNU diff3 not found. * Couldn't find GD library or ImageMagick; image thumbnailing disabled. * Installation directory: /usr/local/wiki * Script URI path: /wiki * PHP is linked with old MySQL client libraries. If you are using a MySQL 4.1 server and have problems connecting to the database, see http://dev.mysql.com/doc/mysql/en/old-client.html for help. * Trying to connect to MySQL on localhost as root... o MySQL error 1045: Access denied for user: 'root@localhost' (Using password: NO) * Trying regular user... ok. * Connected to 4.0.26-standard; enabling MySQL 4 enhancements * Database wikidb exists * There are already MediaWiki tables in this database. Checking if updates are needed... ...hitcounter table already exists. ...querycache table already exists. ...objectcache table already exists. ...categorylinks table already exists. ...logging table already exists. ...validate table already exists. ...user_newtalk table already exists. ...transcache table already exists. ...trackbacks table already exists. ...have ipb_id field in ipblocks table. ...have ipb_expiry field in ipblocks table. ...have rc_type field in recentchanges table. ...have rc_ip field in recentchanges table. ...have rc_id field in recentchanges table. ...have rc_patrolled field in recentchanges table. ...have user_real_name field in user table. ...have user_token field in user table. ...have user_email_token field in user table. ...have log_params field in logging table. ...have ar_rev_id field in archive table. ...have ar_text_id field in archive table. ...have page_len field in page table. ...have rev_deleted field in revision table. ...have img_width field in image table. ...have img_metadata field in image table. ...have img_media_type field in image table. ...have val_ip field in validate table. ...have ss_total_pages field in site_stats table. ...have iw_trans field in interwiki table. ...already have interwiki table ...indexes seem up to 20031107 standards Already have pagelinks; skipping old links table updates. ...image primary key already set. The watchlist table is already set up for email notification. ...user table does not contain old email authentication field. Logging table has correct title encoding. ...page table already exists. revision timestamp indexes already up to 2005-03-13 ...rev_text_id already in place. ...page_namespace is already a full int (int(11)). ...ar_namespace is already a full int (int(11)). ...rc_namespace is already a full int (int(11)). ...wl_namespace is already a full int (int(11)). ...qc_namespace is already a full int (int(11)). ...log_namespace is already a full int (int(11)). ...already have pagelinks table. No img_type field in image table; Good. Already have unique user_name index. ...user_groups table already exists. ...user_groups is in current format. Initialising "MediaWiki" namespace... A database error has occurred Query: SELECT old_text,old_flags FROM `text` WHERE old_id = '67' LIMIT 1 Function: Revision::loadText Error: 1146 Table 'wikidb.text' doesn't exist (localhost) Backtrace: GlobalFunctions.php line 451 calls wfBacktrace() Database.php line 400 calls wfDebugDieBacktrace() Database.php line 350 calls Database::reportQueryError() Database.php line 726 calls Database::query() Database.php line 745 calls Database::select() Revision.php line 574 calls Database::selectRow() Revision.php line 370 calls Revision::loadText() InitialiseMessages.inc line 182 calls Revision::getText() InitialiseMessages.inc line 72 calls initialiseMessagesReal() updaters.inc line 670 calls initialiseMessages() index.php line 592 calls do_all_updates()
The above output indicates you already had the tables for 1.5 in your database, but for some reason you're missing the text table. Did your upgrade originally fail, and this output is from a *later* attempt? Can you provide the original output if so? Can you confirm how much of the upgrade took place? Are the page and revision tables already filled out? If you rename the old table to text, does it work?
My intial attempts to upgrade failed for more foolish reasons ("oops, that wasn't the right password", "oops, that directory wasn't readable"). This was the first error message that I didn't figure out how to fix, but I'm afraid I don't have the previous outputs. There are page.frm and revision.frm files in mysql/wikidb, but no MYI or MYD files with data in them. (and no text.frm). (I'm still trying to teach myself all this stuff, so I'm sorry if I answered the wrong question).
Removing the .frm files for which there was no accompanying MYI and MYD file and trying to re-upgrade got a lot farther, but in the end I've ended up reinstalling mysql and wikimedia from scratch and it's now working.
Looks like the URL is now running 1.5rc4 (you should upgrade it :p ) Closing the bug.