WordPress.org

Ready to get started?Download WordPress

Forums

Close All Comment (8 posts)

  1. Sphyr
    Member
    Posted 9 years ago #

    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?

  2. lawtai
    Member
    Posted 9 years ago #

    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.

  3. Sphyr
    Member
    Posted 9 years ago #

    The wiki always confuses me. I can't find squat. Trying to go to wiki.wordpress.org and searching for "plugin" or "comment" doesn't seem to find this plugin. I'll keep looking.

  4. charle97
    Member
    Posted 9 years ago #

  5. charle97
    Member
    Posted 9 years ago #

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

  6. notthatugly
    Member
    Posted 9 years ago #

    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'.

  7. See "I have disabled comments, but comments continue to be posted." here: http://codex.wordpress.org/Combating_Comment_Spam#Q_.26_A

    All of the various instructions are there.

  8. notthatugly
    Member
    Posted 9 years ago #

    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.

Topic Closed

This topic has been closed to new replies.

About this Topic

Tags

No tags yet.