SQL commenting error

  • https://reviews.frozen-rain.net/

    The comments don’t show up, and in the admin panel, everywhere that has any information on comments has SQL errors; here’s one of the errors:

    WordPress database error: [Can’t open file: ‘wp_comments.MYI’ (errno: 144)]
    SELECT COUNT(*) FROM wp_comments WHERE comment_approved = ‘0’

    WordPress database error: [Can’t open file: ‘wp_comments.MYI’ (errno: 144)]
    SELECT COUNT(comment_ID) FROM wp_comments WHERE comment_approved = ‘spam’

Viewing 3 replies - 1 through 3 (of 3 total)

  • Almost always this means a table has crashed and needs repairing. Do it through phpmyadmin or contact your host.

    Sometimes it means someone has mailed or tried to upload a huge attachment that exceeds host specs.

    Thread Starter michiru37

    (@michiru37)

    Well, wordpress is only acting up for that subdomain, and as far as I know, I haven’t touched it in a while.

    But thank you, I’ll fiddle with the SQL for a while and contact my host.

    But a table is specific to one certain instance of WP. You could have 10 WP’s installed in one db and have a table crash and it will only affect one blog.

Viewing 3 replies - 1 through 3 (of 3 total)
  • The topic ‘SQL commenting error’ is closed to new replies.