Got error -1 from table handler #1030
Filed in: Site News — January 26th, 2005
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
Comments Feed
TrackBack URL
January 26th, 2005 at 4:26 pm
Looks like another Blacklist problem. Have you tried uninstalling (removing it) and seeing if that solves the problem?
January 26th, 2005 at 4:28 pm
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’
January 26th, 2005 at 4:40 pm
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.
January 26th, 2005 at 7:56 pm
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.
January 26th, 2005 at 9:01 pm
you so bad luck.
January 27th, 2005 at 12:53 am
Ya, the table is corrupted. I think it is fixed now.