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(a)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