Support » Fixing WordPress » cannot delete comments after upgrading to 2.1

  • Hello,

    i was wondering if someone can help me out with this. i want to delete comments but i am getting this error message.

    WordPress database error: [Incorrect key file for table ‘./databases/wp_comments.MYI’; try to repair it]
    DELETE FROM wp_comments WHERE comment_approved = ‘spam’ AND ‘2007-01-28 15:50:48’ > comment_date_gmt

    Warning: Cannot modify header information – headers already sent by (output started at /home/site/blog/wp-includes/wp-db.php:121) in /home/site/blog/wp-includes/pluggable.php on line 275

    thank you
    vic

Viewing 4 replies - 1 through 4 (of 4 total)
  • do you have any plugins running that affect comments? If you do, try disabling whichever one it is, and see if that fixes anything.

    citee,

    i dont have any plugin that affects commments. the only one is Akismet.

    today when i login into the admin section of my site i get this:

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

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

    If you have something like phpMyAdmin, you could try to do a “Repair” on that table.

    If you don’t, or have no clue what I meant, contact your host and see if they can help.

Viewing 4 replies - 1 through 4 (of 4 total)
  • The topic ‘cannot delete comments after upgrading to 2.1’ is closed to new replies.