• Hello..
    I have 10,000+ comments waiting for approval and all of them are spam.
    I want to delete them in one go. Is there any SQL quarry for this?
    I want to delete all the approved comments too.
    Please suggest me something.
    Regards
    Abhik

Viewing 7 replies - 1 through 7 (of 7 total)
  • Hello.. I have the same problem: how can I delete all the comments in one go. How did you solved it?
    Regards
    Enrico

    Don’t you have Akismet installed? It automatically deletes all spam after a few days. It normally ships with WP. Go to http://www.wordPress.com and sign up for a blog to get an Akismet key.

    Also, if you’re running WP 2.5.x and up, there’s a check box on the top header row, check that and all the comments will be checked and then you can bulk edit them.

    This suggest…
    “Also, if you’re running WP 2.5.x and up, there’s a check box on the top header row, check that and all the comments will be checked and then you can bulk edit them.?

    Does not work. It only works for the comments on the page, 25.

    How do you change the page view to include all or 100 or 500 comments?

    Thanks,
    Dan

    Essentially all the comment delete function does is

    DELETE FROM wp_comments WHERE comment_ID = [something]

    So if you wanted to delete every single comment you could just go into your database and do DELETE FROM wp_comments

    Or if you wanted to delete just unapproved ones –

    DELETE FROM wp_comments WHERE comment_approved=’0′

    Thanks, but I don’t want to/ don’t know how to go into the database. I just want to use the same interface sitting there that I use to post.

    I’m using Word Press because it’s supposed to be easy to use.

    And since every piece of software that has list views allows the user to change the number of items to view (as in web-based email), I just want to know how Word Press lets you do that.

    Even a response like “Word Press doesn’t have that built in” would be nice.

    This probably wouldn’t be a problem if Akismet worked. But it doesn’t and everytime I log in and look for that place where my code is, it isn’t. 300 SPAM blog posts a day is not good.

    Thanks,

    Dan

    Word Press doesn’t have that built in.

    You could hack edit-comments.php to change this

    $comments_per_page = apply_filters(‘comments_per_page’, 20, $comment_status);

Viewing 7 replies - 1 through 7 (of 7 total)
  • The topic ‘Is there any way to delete all the comments in one go?’ is closed to new replies.