Got error -1 from table handler #1030

Filed in: Site News — January 26th, 2005

advertisement

The second website problem of the day. A database error come up suddenly at front page. Duh… What an unlucky day!

Problem
If is all right for permalink page, but if you goto front page(and, If the problem haven’t be solved while you are reading this) – http://www.liewcf.com/blog, the following database error displayed at the top:

Database error: Got error -1 from table handler
SELECT DISTINCT * FROM wp_posts WHERE 1=1 AND post_date_gmt <= '2005-01-26 06:59:59' AND (post_status = "publish") GROUP BY wp_posts.ID ORDER BY post_date DESC LIMIT 7

I ran myslq repair table, doesn’t help. After searching in Wordpress support forum and Google, it is posibility a hosting side issue, not my fault. Waiting for hosting side reply…

Here are the links I found related to the same database problem:
http://wordpress.org/support/topic.php?id=14045
http://www.pmachine.com/forum/threads.php?id=15122_0_16_0_C
http://www.open.com.au/archives/radiator/2001-01/msg00129
http://www.mambers.com/archive/index.php/t-9753.html
http://www.vbulletin.com/forum/archive/index.php/t-16489.html

Bookmark and Share

Read also:

« Cannot Submit Comment
Free Blog Hosting »
  • Looks like another Blacklist problem. Have you tried uninstalling (removing it) and seeing if that solves the problem?
  • Whoa. When I submitted the comment earlier, I got a whole page of errors + plus there's an error msg now on the permalink page too:

    Database error: [Can't open file: 'blacklist.MYI'. (errno: 144)]
    SELECT * FROM blacklist WHERE regex_type = 'option'
  • LcF
    Yes, beside the wp_posts table, the blacklist table also gives me problem. I have disable blacklist plugin and drop the blacklist table. The wp_posts problem still not solved yet.
  • i believe it's due to corrupted database. dump the whole database into a script file, have your web hosting provider to drop the entire database, create it back, then run the script to load the scripts.
  • you so bad luck.
  • LcF
    Ya, the table is corrupted. I think it is fixed now. :)
blog comments powered by Disqus