Great deals on car insurance from Direct Line
Save money - get a car insurance quote from privilege
adverts
 

WordPress database error: [Can't open file: 'wp_comments.MYI' (errno: 144)] 03Apr07

11 comments so far, what do you think? ...

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…

 
 
 

Don't forget Dazecoop

 
keep track of my tweets :)
 
For cheaper car insurance, there is only one place to go and that's Hastings Direct!

11 comments so far

  • Adcuz
    4 Apr 2007 at 2:30 pm

    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.

  • Daze
    4 Apr 2007 at 3:38 pm

    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.

  • Adcuz
    4 Apr 2007 at 5:19 pm

    Ahh! great tip.

    Cheers mate.

    (Why didn’t I think of that before?)

  • Collin
    4 Apr 2007 at 7:47 pm

    And then BOTH of you get Spam Karma 2 to run alongside Akismet. Works a treat for me. :)

  • Adcuz
    4 Apr 2007 at 8:56 pm

    OK, i’ll give that a try as well.

  • Daze
    4 Apr 2007 at 9:34 pm

    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!

  • Beachbum
    13 Sep 2007 at 5:57 am

    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

  • Daze
    16 Sep 2007 at 9:14 am

    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.

  • Cory
    7 Dec 2007 at 11:59 pm

    Worked like a charm, thank you!!!

  • Pingback from Blog comments not functioning at present | we eat bricks

    [...] 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...... [...]

  • autoverleih
    20 Aug 2008 at 8:17 am

    Thanks for the informative post.. and thanks for adding our comment to the blog.

What do you think?

 
wordpress
Theme by David Cooper :)