Last modified: 2011-04-04 21:28:17 UTC

Wikimedia Bugzilla is closed!

Wikimedia has migrated from Bugzilla to Phabricator. Bug reports should be created and updated in Wikimedia Phabricator instead. Please create an account in Phabricator and add your Bugzilla email address to it.
Wikimedia Bugzilla is read-only. If you try to edit or create any bug report in Bugzilla you will be shown an intentional error message.
In order to access the Phabricator task corresponding to a Bugzilla report, just remove "static-" from its URL.
You could still run searches in Bugzilla or access your list of votes but bug reports will obviously not be up-to-date in Bugzilla.
Bug 3518 - Upgrade from 1.4.9 to 1.5rc4 hits Error: 1146 Table 'wikidb.text' doesn't exist
Upgrade from 1.4.9 to 1.5rc4 hits Error: 1146 Table 'wikidb.text' doesn't exist
Product: MediaWiki
Classification: Unclassified
Installer (Other open bugs)
Other Solaris
: Normal normal (vote)
: ---
Assigned To: Nobody - You can work on this!
Depends on:
  Show dependency treegraph
Reported: 2005-09-20 15:00 UTC by Laura Baldwin
Modified: 2011-04-04 21:28 UTC (History)
0 users

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


Description Laura Baldwin 2005-09-20 15:00:59 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 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. 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)

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() line 182 calls Revision::getText() line 72 calls initialiseMessagesReal() line 670 calls initialiseMessages()
index.php line 592 calls do_all_updates()
Comment 1 Brion Vibber 2005-09-20 20:05:47 UTC
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?
Comment 2 Laura Baldwin 2005-09-20 20:37:52 UTC
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).

Comment 3 Laura Baldwin 2005-09-21 18:10:49 UTC
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.
Comment 4 Antoine "hashar" Musso (WMF) 2005-12-22 20:30:54 UTC
Looks like the URL is now running 1.5rc4 (you should upgrade it :p )

Closing the bug.

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