WordPress.org

Ready to get started?Download WordPress

Forums

WordPress database error - Table 'wp_comments' (3 posts)

  1. vmgbpo
    Member
    Posted 6 years ago #

    I am getting this message in the admin area:

    WordPress database error: [Table 'wp_comments' is marked as crashed and last (automatic?) repair failed]
    SELECT COUNT(*) FROM wp_comments WHERE comment_approved = '0'

    The site is working fine though. Is there a way correct this error ?

  2. MichaelH
    Member
    Posted 6 years ago #

    See if you can manually repair the table with phpMyAdmin.

    Paul has a quick howto:
    http://paulstamatiou.com/2006/05/31/how-to-quickie-repair-mysql-tables-in-phpmyadmin/

  3. Microdot
    Member
    Posted 6 years ago #

    I'm having this problem but the quick howto didn't work..

    Here's the error I get:

    WordPress database error: [Table 'wp_comments' is marked as crashed and should be repaired]
    SELECT COUNT(*) FROM wp_comments WHERE comment_approved = '0'

    WordPress database error: [Table 'wp_comments' is marked as crashed and should be repaired]
    SELECT COUNT(comment_ID) FROM wp_comments WHERE comment_approved = 'spam'

Topic Closed

This topic has been closed to new replies.

About this Topic