Support » Fixing WordPress » How to delete 40k waiting for moderation comments

  • I’m running the latest version of WP. I have a blog that has 39,263 comments waiting for moderation. Deleting them via the wp-admin interface sounds years of work.

    Could somebody give me the SQL query to delete the awaiting for moderation comments?

    And I do use Akismet. I installed it after I discovered the huge amount of spam. In 2.3 clicking to recheck the queue resulted in blank page. In 2.6 it says the queue is empty.

Viewing 7 replies - 1 through 7 (of 7 total)
  • Same story here… have a site that runs on bleeding edge (now 2.7-beta3-9771) and has about 6300 comments in moderation. When hitting “check for spam”, the resulting page /wp-admin/admin.php?action=akismet_recheck_queue shows nothing but blank.

    Guess that this is still in the works? Any news?

    I just went to the DB and deleted all comments needing moderation with a SQL query. If you’re running bleeding edge I guess the bug has not been adressed yet 🙁

    I just went to the DB and deleted all comments needing moderation with a SQL query.

    That’s exactly the thing that everybody is asking for: the query.
    Could you post it?

    To delete all the comments that have _not_ been approved yet can be deleted via:

    delete from wp_comments where comment_approved=0;

    Your table name can be different so wp_comments can be your defined prefix_comments.

    *) If you have non-spam comments that need approval they will also be deleted so watch out.

    pumpkindoodle

    (@pumpkindoodle)

    I’m having the same problem and would love not to delete ALL comments, since there are actually some good ones in there. I haven’t found any solution to the blank page problem with akismet. I’m also worried that it’s not catching new spam…

    Did anyone find a fix for this?

    dale426

    (@dale426)

    hello everyone
    same issue here, 34K comments waiting, but 99% in a single post.

    I would like to use something more specific than:
    delete from wp_comments where comment_approved=0;

    I would like to restrict the conditions to a specific post (how are they identified? ordinal number?), and containing a specific keyword (matching a few spam keywords should get rid of most spam posts, and hopefully leave some good comments)

    I am in the MySql php admin panel, but it’s my first time here so I’d like a little help…

    thanks!

    Same problem – blank result on /wp-admin/admin.php?action=akismet_recheck_queue – don’t want to delete all unmoderated comments since there must be a couple valid ones in the 28,000+ Pending comments.

Viewing 7 replies - 1 through 7 (of 7 total)
  • The topic ‘How to delete 40k waiting for moderation comments’ is closed to new replies.