Hey all,
Slight update. I found the update.php script wasn't running correctly (similar error message to the one above)
I've included a log of the error:
MediaWiki 1.21.1 Updater
Going to run database updates for Beki Depending on the size of your database this may take a while! Abort with control-c in the next five seconds (skip this countdown with --quick) ... 543210 Turning off Content Handler DB fields for this part of upgrade. ...ipblocks table does not exist, skipping new field patch. ...ipblocks table does not exist, skipping new field patch. Creating interwiki table ...A database query syntax error has occurred. The last attempted database query was: "CREATE TABLE `interwiki` ( iw_prefix varchar(32) NOT NULL, iw_url blob NOT NULL, iw_local BOOL NOT NULL, UNIQUE KEY iw_prefix (iw_prefix) ) ENGINE=InnoDB, DEFAULT CHARSET=binary " from within function "DatabaseBase::sourceFile( E:\xampp\htdocs\xampp\Beki/maintenance/archives/patch-interwiki.sql )". Database returned error "1146: Table 'beki.interwiki' doesn't exist (127.0.0.1)"
Once that's done I then get 4 other Warnings saying Invalid argument supplied for foreach() in objectcache\SqlBagOStuff and cache\MessgeCahce.php
Still having problems.
Any advice would be greatly appreciated
On Mon, Sep 9, 2013 at 9:25 AM, Ben Crane curtly.boon@gmail.com wrote:
Morning all,
My Spec:
Windows 7 (64bit) Xampp 2.3.1 Apache 2.4.2 MySQL 5.6.11 PHP 5.5.3
Just installed MediaWiki over the weekend to have a play and so far so good...but...this morning when I tried to get back in I got the following error message:
*Warning*: Invalid argument supplied for foreach() in * E:\xampp\htdocs\xampp\Beki\includes\objectcache\SqlBagOStuff.php* on line *232*
*Warning*: Invalid argument supplied for foreach() in * E:\xampp\htdocs\xampp\Beki\includes\objectcache\SqlBagOStuff.php* on line *232* A database error has occurred. Did you forget to run maintenance/update.php after upgrading? See: https://www.mediawiki.org/wiki/Manual:Upgrading#Run_the_update_script Query: SELECT page_title FROM `page` WHERE page_is_redirect = '0' AND page_namespace = '8' AND (page_title NOT LIKE '%/%' ) AND (page_len > 10000) Function: MessageCache::loadFromDB(en)-big Error: 1146 Table 'beki.page' doesn't exist (127.0.0.1)
MySQL had not started so retried but still no joy so check the log file which said:
InnoDB: Error: could not open single-table tablespace file .\mysql\innodb_table_stats.ibd InnoDB: We do not continue the crash recovery, because the table may become InnoDB: corrupt if we cannot apply the log records in the InnoDB log to it. InnoDB: To fix the problem and start mysqld: InnoDB: 1) If there is a permission problem in the file and mysqld cannot InnoDB: open the file, you should modify the permissions. InnoDB: 2) If the table is not needed, or you can restore it from a backup, InnoDB: then you can remove the .ibd file, and InnoDB will do a normal InnoDB: crash recovery and ignore that table. InnoDB: 3) If the file system or the disk is broken, and you cannot remove InnoDB: the .ibd file, you can set innodb_force_recovery > 0 in my.cnf InnoDB: and force InnoDB to continue crash recovery here.
So I went to the MediaWiki site and ran the update.php file and then re-tried, no joy. I then removed the ibdata1 and voila MySQL restarts but I still get the same error with MediaWiki. I restart my machine in case that will help and all of a sudden the original problem re-appears with MySQL not starting and the ibdata1 re-surfaced. I repeated all the steps - same outcome...
So now I'm a little stuck. I have generated a couple test pages over the weekend in MediaWiki so not completely committed to it but this worries me going forward as if it's already falling over so early I don't want to lose any of my work if I commit and build hundreds of pages
Cheers Ben