This evening, 1/10/06 – we received reports and experienced the following error in blogs using WordPress version 2.0:
WordPress database error: [Got error 28 from table handler]
SELECT * FROM wp_posts WHERE 1=1 AND (post_status = “publish” OR post_author = 1 AND post_status != ‘draft’ AND post_status != ‘static’) AND post_status != “attachment” GROUP BY wp_posts.ID ORDER BY post_date DESC LIMIT 0, 15
The problem existed for all of 3-5 minutes on our server and appeared to wipe out all posts made on the blogs – however, a quick check of the database told us that the databases were, indeed, in tact with no data loss at all. Something quirky in the calls to the database to retrieve the data was going on.
This error did not occur on any site on our server running earlier versions of WordPress, this only happened with 2.0 users. (unless we didn’t catch it – but a quick review by loading those sites running earlier versions of WordPress told us that they were running fine, while the WordPress 2.0 blogs were toast (like mine)).
We resolved the error by running a MYSQL repair on all 2.0 database tables, and the error went away, server-wide.
We are currently in communications with the folks from MYSQL and WordPress to determine what the error was about, how to avoid it in the future and whether or not this is a true WordPress 2.0 bug, or rather some tweaks that need doing in MYSQL.
We currently have all sites utilizing WordPress 2.0 on our ‘Watch List” (for lack of a better phrase) to monitor and keep track of until we find a solid resolution to this error.
Should you have any questions at all, please do not hesitate to submit a ticket with a request at our Support Center: http://tickets.blogs-about.com