turn comments on for every post

  • Resolved drkknght

    (@drkknght)


    15 years, 6 months ago

    i’ve been in the process of converting an old forum to a WP. long story short, everything is up and running now, but all imported posts were automatically set to “do not allow comments”

    because there’s so many posts (few thousand) i’d rather not go back by hand and select the “allow comments” check box. is there anyway to “mindwipe” the blog so that all of those are now magically reversed?

Viewing 2 replies - 1 through 2 (of 2 total)

  • This SQL in phpMyAdmin will do it:

    UPDATE wp_posts SET comment_status='open' WHERE post_status = 'publish' AND post_type = 'post';

    The wp_ in wp_posts could be different for you depending on your $table_prefix in wp-config.php.

    Backup your database before attempting.

    Thread Starter drkknght

    (@drkknght)

    woo! looks good!

    thanks, Michael! ??

Viewing 2 replies - 1 through 2 (of 2 total)
  • The topic ‘turn comments on for every post’ is closed to new replies.