Forums

Database error / wp_comments.MYI (?) (6 posts)

  1. eliotmail
    Member
    Posted 4 years ago #

    I updated to 1.5 about a week ago, I haven't made any edits to WP or the server or MySQL, etc. in about 48 hours, suddenly this started showing up at the top of the site, the admin page, and at each comments section:

    WordPress 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 (92,90,88,49,87,85,82,81,80,72) GROUP BY ID

    see this bug in action at: visualresistance.org/wordpress

    anyone seen this before or know what might be causing it? thanks in advance....

  2. podz
    Support Maven
    Posted 4 years ago #

    Looks like a hosting error - email them.

  3. eliotmail
    Member
    Posted 4 years ago #

    ok i'll try that -- thanks podz

  4. cheeks
    Member
    Posted 4 years ago #

    eliotmail, did you ever resolve this?

  5. cheeks
    Member
    Posted 4 years ago #

    Found the answer! In PHPMyAdmin you need to type:

    REPAIR tablename USE_FRM

    This should sort it out.

  6. cheeks
    Member
    Posted 4 years ago #

    Oops! Try:

    REPAIR TABLE tablename USE_FRM

Topic Closed

This topic has been closed to new replies.

About this Topic

Tags