comments all broken? (8 posts)

  1. circuitor
    Posted 10 years ago #

    Hi all!
    My site has been smoothly running WP for months now (I love it!). Lately I've gotten alot of spam, which I just delete in the moderatioon cue.

    But last night it seems that things went haywire and all over my site I am getting the following:

    Database error: [Can't open file: 'wp_comments.MYI'. (errno: 145)]
    SELECT ID, COUNT( comment_ID ) AS ccount FROM wp_posts LEFT JOIN wp_comments ON ( comment_post_ID = ID AND comment_approved = '1') WHERE post_status = 'publish' AND ID IN (35) GROUP BY ID

    This forum has helped me trouble shoot all my previous glitches but this one is beyond me.
    Please help. I have no idea how to approach this issue!!

    you may see the site here:

    please note that other than the comments everything is working fine!
    thanks a million!

  2. Mark (podz)
    Support Maven
    Posted 10 years ago #

    I'm getting a 404 on the domain ?

  3. cheeks
    Posted 10 years ago #

    Hi, I'm suddenly getting this error also;

    [Can't open file: 'wp_comments.MYI'. (errno: 138)]<br />
    SELECT COUNT(*) FROM wp_comments WHERE comment_approved = '0'

    When I take a look at my database in phpMyAdmin I see that the wp_comments table is corrupt; how did this happen? And, more to the point, how do I fix it? I've run a Repair on the table but I get:

    Can't open file: 'wp_comments.MYI'. (errno: 138)

  4. cheeks
    Posted 10 years ago #

    Can anyone help me out on this? Please?

    Could it have been caused by upgrading Spam Karma?

  5. cheeks
    Posted 10 years ago #

    Found the answer! In PHPMyAdmin you need to type:

    REPAIR tablename USE_FRM

    This should sort it out.

  6. cheeks
    Posted 10 years ago #

    Oops! Try:

    REPAIR TABLE tablename USE_FRM

  7. leofish
    Posted 10 years ago #

    Hey, This saved my ass. Thanks for posting

  8. blau
    Posted 9 years ago #

    This worked for me. But what is the reason of table corruption? It's the second time in 24 hours.

Topic Closed

This topic has been closed to new replies.

About this Topic


No tags yet.