Support » Fixing WordPress » Deleating all Comments awaiting moderation

  • Hello,

    I cant seem to find any way to remove the exactly: 19,993 comments awaiting moderation with a simple press of a button.

    Does anyone know how to do this easily? I just upgraded to WordPress 2.1 and cant really find any other way to do it. When I press on [Mass Edit], then I have to check boxes, which doesnt ease my job as much seeing as I have so many comments.

    Any help would be greately appreciated.

Viewing 9 replies - 1 through 9 (of 9 total)
  • Thread Starter Juan Eduardo

    (@reynard)

    please. anyone know?

    Thread Starter Juan Eduardo

    (@reynard)

    anyone?

    Unless someone else has another idea, I would say that (a) yes, you can delete them using the inbuilt bulk deletion functionality, but (b) not with “the simple press of a button”.

    That said, I would seriously suggest that, if you’re geting that many bogus comments, you use Akismet:

    – sign up for an account at Akismet.com
    – get your API key
    – download the akismet plugin
    – upload it to your blog’s wp-content/plugins folder
    – activate it from your plugins page
    – put the API key into it

    This will catch most of your future comment spam, throwing it into your (new) internal Akismet queue (page), where you can indeed delete them with the simple press of a button.

    And … good luck. 19,993 is an awfully high number.

    Thread Starter Juan Eduardo

    (@reynard)

    alright, thanks for the info. I currently downloaded and installed Akismet and activated it. I signed up for an API key as well. But now when I try to activate it using the API key, the following message appears:

    The key you entered could not be verified because a connection to akismet.com could not be established. Please check your server configuration.

    Any idea on what can be done? Thanks again

    Hm. It sounds as if your wp-admin directory might be password protected — which would be one reason why the “connection to akismet.com could not be established.”

    At least, that’s the only problem I’ve run into in implementing Akismet.

    Thread Starter Juan Eduardo

    (@reynard)

    alright, how can I check if its password protected and how can I enable it to connect?

    Is there a way to delete the comments in cpanel (through the file or data itself)?

    >> Is there a way to delete the comments in cpanel (through the file or data itself)?

    There is another easy way to delete comments in bulk. Login to your mysql server ( for example through phpmyadmin) and delete comments from the table – wp_comments using any set criteria.

    I have had about a couple of thousands of spam comments in a span of a month. I used this technique to delete all of them in one move.

    I managed to do delete all comments in moderation through Spam Karma 2.

Viewing 9 replies - 1 through 9 (of 9 total)
  • The topic ‘Deleating all Comments awaiting moderation’ is closed to new replies.