Mass Edit – Turning Comments On

  • Hi, I’ve recently migrated from Movable Type over to WordPress, and I’m having great success with the comment spam-fighting plugins. However, back in my MT days I was getting so many comment spams that I had to turn off “allow comments and pings” for all of my posts. Now that I can actually install plugins to manage the spam, I’d like to re-enable comments and pings… but I have over 2oo posts. Is there any way to mass edit this, and turn comments and pings back on for all my posts without doing it to each one individually?

    Thanks ??

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

  • SQl has the answer. If you use phpMyAdmin to access your database, click on the SQL tab and enter this:

    UPDATE wp_posts SET comment_status = 'open', ping_status = 'open' WHERE comment_status = 'closed';

    You may need to change wp_posts to another prefix if you’re not using the default for your WordPress tables.

    I tried that…even tried removing the ping_status query and running it separately…and my comments are still closed.

    Any idea why?

    (this is the only thing keeping me from announcing my site ATM *argh*)

    AH HA! I found that if you remove everything from the “WHERE comment_st….” to the end and then run the query… blam… all posts’ comments and pings open. WOO! ??

    Your comments must have been set to ‘moderated’ instead of ‘closed’ (or perhaps even ‘registered_only’). But I’m glad you figured it out.

    Thread Starter dminky

    (@dminky)

    Thanks a million! ??

Viewing 5 replies - 1 through 5 (of 5 total)
  • The topic ‘Mass Edit – Turning Comments On’ is closed to new replies.