Support » Fixing WordPress » Close All Comment

  • I’m moving hosts; I want to close all the comments during the transition.
    The “Close comments” under options only closes comments for new posts. How do I close comments on my past 450 posts?

Viewing 7 replies - 1 through 7 (of 7 total)
  • there’s a plugin that’ll auto close comments after X amount of days. I can’t remember where it is, but it’s on the wiki plugin section so take a look over there. You’d be able to just set X to like 1.

    The wiki always confuses me. I can’t find squat. Trying to go to and searching for “plugin” or “comment” doesn’t seem to find this plugin. I’ll keep looking.

    a sql query can easily switch comments from closed to open and vice versa.

    OK: are there any mySQL gurus here willing to tell us what form that query might take? I don’t need a plugin: I just need to know how to change all the comment_status values in my 1.2 database from ‘open’ to ‘closed’.

    Moderator James Huff


    See “I have disabled comments, but comments continue to be posted.” here:

    All of the various instructions are there.

    That’s what I wanted; thanks!

    To save anyone else trawling though the Codex for this code, the actual query is UPDATE wp_posts SET comment_status="closed";, which I ran from the SQL page in phpMyAdmin. Remember that if you’re using a different table prefix you’ll have to change wp_ to whatever prefix you specified in wp-config.

Viewing 7 replies - 1 through 7 (of 7 total)
  • The topic ‘Close All Comment’ is closed to new replies.