comments all broken?

  • circuitor

    (@circuitor)


    19 years, 2 months 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:
    http://cutecircuit.com/news.php?cat=1

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

Viewing 7 replies - 1 through 7 (of 7 total)
  • Mark (podz)

    (@podz)

    19 years, 2 months ago

    I’m getting a 404 on the domain ?

    cheeks

    (@cheeks)

    19 years, 1 month 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)

    cheeks

    (@cheeks)

    19 years, 1 month ago

    Can anyone help me out on this? Please?

    Could it have been caused by upgrading Spam Karma?

    cheeks

    (@cheeks)

    19 years, 1 month ago

    Found the answer! In PHPMyAdmin you need to type:

    REPAIR tablename USE_FRM

    This should sort it out.

    cheeks

    (@cheeks)

    19 years, 1 month ago

    Oops! Try:

    REPAIR TABLE tablename USE_FRM

    leofish

    (@leofish)

    18 years, 7 months ago

    Hey, This saved my ass. Thanks for posting

    blau

    (@blau)

    17 years, 11 months ago

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

Viewing 7 replies - 1 through 7 (of 7 total)
  • The topic ‘comments all broken?’ is closed to new replies.