Support » Networking WordPress » How to delete all comments from MultiSite?

  • Razva

    (@razva)


    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!

Viewing 3 replies - 1 through 3 (of 3 total)
  • Moderator Ipstenu (Mika Epstein)

    (@ipstenu)

    🏳️‍🌈 Halfelf Rogue & Plugin Review Team Rep

    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/

    Razva

    (@razva)

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

    Moderator Ipstenu (Mika Epstein)

    (@ipstenu)

    🏳️‍🌈 Halfelf Rogue & Plugin Review Team Rep

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

Viewing 3 replies - 1 through 3 (of 3 total)
  • The topic ‘How to delete all comments from MultiSite?’ is closed to new replies.