Last modified: 2010-05-24 16:57:03 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 T25614, the corresponding Phabricator task for complete and up-to-date bug report information.
Bug 23614 - Update script fails at database updates - incorrect key
Update script fails at database updates - incorrect key
Status: RESOLVED INVALID
Product: MediaWiki
Classification: Unclassified
Database (Other open bugs)
unspecified
All All
: Normal enhancement (vote)
: ---
Assigned To: Nobody - You can work on this!
:
Depends on:
Blocks:
  Show dependency treegraph
 
Reported: 2010-05-21 02:15 UTC by Kym
Modified: 2010-05-24 16:57 UTC (History)
4 users (show)

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


Attachments

Description Kym 2010-05-21 02:15:20 UTC
What happened:
1. Did the updates as instructed.
2. Uploaded the latest version of MediaWiki as at 21 May 2010.
2. Existing AdminSettings.php file.
3. Existing LocalSettings.php file.
4. Ran the update.php command and received the following errors.

# php update.php --aconf ../AdminSettings.php

MediaWiki 1.15.3 Updater

Going to run database updates for hello_wiki-wiki_
Depending on the size of your database this may take a while!
Abort with control-c in the next five seconds...0
...cu_changes already exists.
...cu_log already exists.
...have ipb_id field in ipblocks table.
...have ipb_expiry field in ipblocks table.
...already have interwiki table
...indexes seem up to 20031107 standards
...hitcounter table already exists.
...have rc_type field in recentchanges table.
...have user_real_name field in user table.
...querycache table already exists.
...objectcache table already exists.
...categorylinks table already exists.
Already have pagelinks; skipping old links table updates.
...il_from OK
...have rc_ip field in recentchanges table.
...image primary key already set.
...have rc_id field in recentchanges table.
...have rc_patrolled field in recentchanges table.
...logging table already exists.
...have user_token field in user table.
The watchlist table is already set up for email notification.
...watchlist talk page rows already present
...user table does not contain old email authentication field.
...page table already exists.
...have log_params field in logging table.
logging table has correct log_title encoding.
...have ar_rev_id field in archive table.
...have page_len field in page table.
revision timestamp indexes already up to 2005-03-13
...rev_text_id already in place.
...have rev_deleted field in revision table.
...have img_width field in image table.
...have img_metadata field in image table.
...have user_email_token field in user table.
...have ar_text_id field in archive table.
...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)).
...have img_media_type field in image table.
...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.
...have ss_total_pages field in site_stats table.
...user_newtalk table already exists.
...transcache table already exists.
...have iw_trans field in interwiki table.
...trackbacks table already exists.
...wl_notificationtimestamp is already nullable.
...timestamp key on logging already exists.
...have ipb_range_start field in ipblocks table.
Setting page_random to a random value on rows where it equals 0...changed 0 rows
...have user_registration field in user table.
...templatelinks table already exists
...externallinks table already exists.
...job table already exists.
...have ss_images field in site_stats table.
...langlinks table already exists.
...querycache_info table already exists.
...filearchive table already exists.
...have ipb_anon_only field in ipblocks table.
Checking for additional recent changes indices...
...index `rc_ns_usertext` seems ok.
...index `rc_user_text` seems ok.
...have user_newpass_time field in user table.
...redirect table already exists.
...querycachetwo table already exists.
...have ipb_enable_autoblock field in ipblocks table.
Checking for backlinking indices...
Checking if pagelinks index pl_namespace includes field pl_from...
...index pl_namespace on table pagelinks seems to be ok
Checking if templatelinks index tl_namespace includes field tl_from...
...index tl_namespace on table templatelinks seems to be ok
Checking if imagelinks index il_to includes field il_from...
...index il_to on table imagelinks seems to be ok
...have rc_old_len field in recentchanges table.
...have user_editcount field in user table.
...page_restrictions table already exists.
...have log_id field in logging table.
...have rev_parent_id field in revision table.
...have pr_id field in page_restrictions table.
...have rev_len field in revision table.
...have rc_deleted field in recentchanges table.
...have log_deleted field in logging table.
...have ar_deleted field in archive table.
...have ipb_deleted field in ipblocks table.
...have fa_deleted field in filearchive table.
...have ar_len field in archive table.
...have ipb_block_email field in ipblocks table.
Checking for categorylinks indices...
Checking if categorylinks index cl_sortkey includes field cl_from...
...index cl_sortkey on table categorylinks seems to be ok
...oldimage table does not exist, skipping new field patch
...usertext,timestamp key on archive already exists.
...usertext,timestamp key on image already exists.
A database query syntax error has occurred.
The last attempted database query was:
"SHOW INDEX FROM `neodex_oldimage`"
from within function "Database::indexExists".
MySQL returned error "1034: Incorrect key file for table 'wiki_oldimage'; try to repair it (localhost)"

5. After I received this error I repaired tables for the wiki in phpMyAdmin
6. Tried running the update again, same error.
Comment 1 MZMcBride 2010-05-21 02:22:58 UTC
(In reply to comment #0)
> 2. Uploaded the latest version of MediaWiki as at 21 May 2010.
Can you clarify what you mean by "latest version" here? Is there a specific MW release number or a specific revision?
Comment 2 Kym 2010-05-21 02:33:18 UTC
Downloaded version - Download MediaWiki 1.15.3
Tried to update from version 1.15.3
Comment 3 Kym 2010-05-21 02:34:56 UTC
Apologies, clarification to the above.

Downloaded version - MediaWiki 1.15.3
I have backups of the physical files and the database. Trying to determine what my previos mediawiki version was.
Comment 4 OverlordQ 2010-05-21 02:41:24 UTC
Did you upgrade mysql as well?
Comment 5 Kym 2010-05-21 02:55:57 UTC
If you're asking about the server MySQL version: Current running MySQL version - 5.1.45

If you're asking about the updating process, I did the directions listed here: http://www.mediawiki.org/wiki/Manual:Upgrading

1. Back up existing files and the database
2. Unpack the new files
3. Run the update script/Run the installer

That's where I tripped up unfortunatly. Currently googling fixes etc. but running into some dead ends.
Comment 6 Roan Kattouw 2010-05-21 16:01:07 UTC
MySQL returned error "1034: Incorrect key file for table 'wiki_oldimage'; try
to repair it (localhost)"

This is an error with your MySQL setup. MediaWiki isn't doing anything wrong and can't do anything to help you. I followed the same steps you did and didn't get any errors.
Comment 7 Kym 2010-05-22 05:07:00 UTC
I'll restore the MySQL and physical files backup and try the update process again.

Wiki was running fine on an older version of MySQL - I  upgraded to the latest version of MySQL recently and that's when the wiki stopped working. So I tried upgrading and ran into the above issue.

Any suggestions appreciated.
Comment 8 Roan Kattouw 2010-05-22 08:46:08 UTC
Re-closing as INVALID. This bug tracker is for bugs in MediaWiki, which this is not. Note that you can still comment on a closed bug.
Comment 9 Kym 2010-05-23 23:47:07 UTC
I have restored the database and physical files of my MediaWiki installation.

http://www.pinkpt.com/neodex/

I receive the following error:

Parse error: syntax error, unexpected T_NAMESPACE, expecting T_STRING in /home/pinkptc/public_html/neodex/includes/Namespace.php on line 49

PHP was just upgraded to 5.3.2. Prior to the upgrade, the wiki was running perfect.
Comment 10 Max Semenik 2010-05-24 16:57:03 UTC
You've got an older version of this file, not from 1.15.x but from 1.12 or older. Please reupload MediaWiki.

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


Navigation
Links