Suddenly getting an error.

[ibloom]

I've had a wiki up for over a year, suddenly it's getting this error:

Database error

A database query syntax error has occurred. This may indicate a bug in the software. The last attempted database query was:
(SQL query hidden)
from within function "MediaWikiBagOStuff::_doquery". MySQL returned error "1030: Got error -1 from storage engine (localhost)".

Any ideas?

[Emufarmers]

Sounds like a corrupted database table. To see which table, add

$wgShowSQLErrors = true;

to the bottom of LocalSettings.php (remove the line once you've fixed the problem).

Repair the damaged table with phpMyAdmin or the database management tool of your choice.

[ibloom]

Ok so repairing the SQL database did not seem to work. I got many messages saying "Table does not support repair."

Once I enable the:
$wgShowSQLErrors = true;

I get the following message:

A database query syntax error has occurred. This may indicate a bug in the software. The last attempted database query was:
DELETE FROM `objectcache` WHERE keyname='redhaxn_redhaxcache:idhash:1-0!1!0!!en!2!edit=0'
from within function "MediaWikiBagOStuff::_doquery". MySQL returned error "1030: Got error -1 from storage engine (localhost)".

Do I need to upgrade mediawiki, do you think that will help?

IBloom

[ibloom]

I get the same error from the installation script when I try install another wiki on the same database.

Here is the output:
Please include all of the lines below when reporting installation problems.
PHP 5.2.5 installed

Warning: Cannot load module 'pdo_sqlite' because required module 'pdo' is not loaded in Unknown on line 0
Found database drivers for: MySQL
Warning: PHP's register_globals option is enabled. Disable it if you can.
MediaWiki will work, but your server is more exposed to PHP-based security vulnerabilities.
PHP server API is cgi; using ugly URLs (index.php?title=Page_Title)
Have XML / Latin1-UTF-8 conversion support.
Warning: A value for session.save_path has not been set in PHP.ini. If the default value causes problems with saving session data, set it to a valid path which is read/write/execute for the user your web server is running under.
PHP's memory_limit is 64M.
Couldn't find Turck MMCache, eAccelerator, APC or XCache; cannot use these for object caching.
Found GNU diff3: /usr/bin/diff3.
Found ImageMagick: /usr/bin/convert; image thumbnailing will be enabled if you enable uploads.
Found GD graphics library built-in.
Installation directory: /home/redhaxn/public_html/mediawiki-1.13.2
Script URI path: /mediawiki-1.13.2
Installing MediaWiki with php file extensions
Environment checked. You can install MediaWiki.
Generating configuration file...
Database type: MySQL
Loading class: DatabaseMysql
Attempting to connect to database server as redhaxn_hax...success.
Connected to 5.0.67-community; enabling MySQL 4.1/5.0 charset mode
Database redhaxn_redhax exists
There are already MediaWiki tables in this database. Checking if updates are needed...
Warning: you requested the mysql5-binary schema, but the existing database has the mysql4 schema. This upgrade script can't convert it, so it will remain mysql4.
...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.
...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.
Adding ipb_block_email field to table ipblocks...Query "ALTER TABLE `ipblocks`
ADD ipb_block_email tinyint NOT NULL default '0'
" failed with error code "Got error -1 from storage engine (localhost)".

[Emufarmers]

Ok so repairing the SQL database did not seem to work. I got many messages saying "Table does not support repair."

I believe you have to actually tell your tool which table to repair (objectcache).

Do I need to upgrade mediawiki, do you think that will help?

You haven't indicated what version you're running now, so I can't say for certain, but it could help (and certainly won't hurt).

I get the same error from the installation script when I try install another wiki on the same database.

You haven't actually installed a separate wiki; you're just re-running the installer. For a separate installation, you need to use a separate database or prefix.

A couple more thoughts: Make sure your database user has all privileges for the database (including ALTER and DELETE). Also, make sure the MySQL server's disk isn't full. (If you're on shared hosting, you may have to ask your host to verify this for you.)

[ibloom]

I can't figure it out.

Any idea how to salvage the wiki and rebuild it??