WordPress.org

1. MisterX
   Member
   Posted 5 years ago #

   Looks like all the entries I imported from MT have their comment closed.
   Is there a way to open all of them at the same time?
   Going through every single entry in the admin section to enable comments would be rather time consumming...
   Thanks for any suggestion! :)

2. antifuse
   Member
   Posted 5 years ago #

   Do you have the ability to execute SQL statements directly on your database? (ie through the MySQL panel in a shell window, or via PhpMyAdmin)
   If so, you can execute the following SQL statement:
   
update wp_posts set comment_status='open';

   Of course, if you have a different prefix for your tables then change wp_ to whatever your prefix is :)

3. MisterX
   Member
   Posted 5 years ago #

   WOAH!!!
   Thanks! That worked beautifully!
   I really wish I knew something about SQL... ;P
   If you come to NYC, I buy you a beer :)

4. alexkingorg
   Member
   Posted 5 years ago #

   This is the beauty of storing your blog in a standard database. :)

5. antifuse
   Member
   Posted 5 years ago #

   Good stuff, glad to hear it worked! And I might just take you up on that beer the next time I'm in NYC (or rather... the FIRST time I'm in NYC :P)

6. Daisyhead
   Member
   Posted 5 years ago #

   Hello! I'm a newbie to SQL and WordPress but I've heard so many good things about WP that I decided to give it a whirl over MT. I am running into the same problem here, but since I am not familiar with SQL or PHPMyAdmin I am unsure on how to execute the above query. Can anyone point me in the right direction?
   Thanks in advance,
   Daisyhead

7. Daisyhead
   Member
   Posted 5 years ago #

   Oops! I just figured it out. I guess I should have taken the time to scour the Internet first. ;-)
   -Daisyhead

Topic Closed

This topic has been closed to new replies.