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?

    Thread Starter toomasr

    (@toomasr)

    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?

    Thread Starter toomasr

    (@toomasr)

    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.

    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.