Thanks Neil for pointing out that I had a problem on my WordPress comments form. The error went as follows:
WordPress database error: [Can't open file: 'wp_comments.MYI' (errno: 144)]
After searching on Google for about 30 seconds, I found that my database had become corrupt. I went into phpMyAdmin via my control panel to find that within the Operations tab in the admin itself, I couldn’t click "Repair" to fix the table. Great!
After another 10 seconds of Google found me an SQL query to run which would repair the selected table in question. I ran the following query directly into the SQL query window:
REPAIR TABLE wp_comments
And it worked. Not sure how my table become corrupt, maybe its because of all the hundreds of trackback spam I keep receiving. I must do something to fix that soon…
I am swamped with trackback spam! I can’t keep up with it and as much as I mark spam Akismet still fails.
I’ve had enough of it.
Ads, I know what you mean.
Go into wp-admin > Options > Discussion > Turn ON Comment author must have a previously approved comment
This at least removes them publicly. Then just login to your wp-admin every few days to Mark as spam and approve where needed.
Ahh! great tip.
Cheers mate.
(Why didn’t I think of that before?)
And then BOTH of you get Spam Karma 2 to run alongside Akismet. Works a treat for me.
OK, i’ll give that a try as well.
Quality, thanks Collin. Mine is holding back OK at the moment, its finding the time to do anything to my blog at the moment which is the tricky part!
I tried your tip, but it says
beachbum_blog.wp_comments repair error Can’t find file: ‘wp_comments.MYI’ (errno: 2)
What to do? Please email me, quite desperate to solve this!
Cheers
BB
Beachbum – not sure. The error you’ve got sounds like a non-standard WP error to me, but I can’t be certain. I am not much of an expert at WP, try asking on their website.
Worked like a charm, thank you!!!
[...] UPDATE: Comments fixed. I was getting a reporting a missing sql comments file. The problem and the solution providerd here fixed the issue. Thanks dazecoop.co.uk/03-04-2007/word...... [...]
Thanks for the informative post.. and thanks for adding our comment to the blog.