WordPress.org

Ready to get started?Download WordPress

Forums

How to delete 40k waiting for moderation comments (8 posts)

  1. toomasr
    Member
    Posted 5 years ago #

    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.

  2. ipears
    Member
    Posted 5 years ago #

    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?

  3. toomasr
    Member
    Posted 5 years ago #

    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 :(

  4. moshu
    Member
    Posted 5 years ago #

    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?

  5. toomasr
    Member
    Posted 5 years ago #

    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.

  6. pumpkindoodle
    Member
    Posted 5 years ago #

    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?

  7. dale426
    Member
    Posted 5 years ago #

    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!

  8. wpmaniac
    Member
    Posted 5 years ago #

    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.

Topic Closed

This topic has been closed to new replies.

About this Topic