WordPress Development Stack Exchange is a question and answer site for WordPress developers and administrators. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

Is it possible to use the user-interface (front-end) part of Wordpress to open comments on all posts in one (or two) clicks? I have many posts with closed comments which must have happened by mistake, and I want to make them all open comments.

Here's the caveat: My host provider doesn't give me ssh access into the database, so I can't just run a simple sql REPLACE command. Therefore, I need a way to do this from the Administration Panel within wordpress.


share|improve this question
up vote 5 down vote accepted

I wrote up this quick plugin that updates all posts of type post to comment_status open on activation, it should work for you. you can immediately deactivate and delete it once you activate it that once.

Plugin Name: update comment status
function activate_update_comment_status() {
    global $wpdb;
            'comment_status' => 'open'
            'post_type' => 'post'
register_activation_hook( __FILE__, 'activate_update_comment_status' );
share|improve this answer
Thanks a lot! This is exactly what I needed – Amit Jul 13 '12 at 20:27

Just because this method is so out dated, here's a modern solution.

In the wp-admin under Posts when you see the list of all your posts, check the box next to Title so that all your posts are selected. Then choose the bulk option Edit. From here you can change all your comments to Allow in the select box. Then click update. This now allowed comments on all your posts at once.

share|improve this answer

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.