WordPress.org

Ready to get started?Download WordPress

Forums

How to delete all comments from MultiSite? (4 posts)

  1. Razva
    Member
    Posted 6 months ago #

    Hey,

    When setting up WP MultiSite 4 years ago I've unfortunately forgot to disable/moderate comments, or activate Akismet. So I've just found out that some MultiSite websites have thousands of comments.

    In my network commenting is not required, so I would like to delete all approved/unapproved/pending comments. It's like...I want to delete ALL comments, regardless their state.

    How can I do this please?

    Thanks!

  2. If something is truly urgent, you need to consider hiring someone via jobs.wordpress.net - otherwise you get to wait until a friendly volunteer pops in.

    Delete all comments from all sites? You'll have to do this in the DB.

    DELETE from wp_comments WHERE comment_approved = '0';

    And you'll want to run this changing wp_comments for each site, so wp_2_comments and so on.

    Want to turn comments OFF for all your sites? http://wpmututorials.com/how-to/close-comments-across-the-network/

  3. Razva
    Member
    Posted 6 months ago #

    Hey,
    Will this delete the approved comments also?
    Thanks!

  4. No. That's what WHERE comment_approved = '0' means :) When your comments are approved, that number changes to 1

Reply

You must log in to post.

About this Topic

Tags

No tags yet.