MT import – all comments closed – Can I change tha

  • 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! ??

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

  • 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 ??

    Thread Starter misterx

    (@misterx)

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

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

    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)

    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

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

Viewing 6 replies - 1 through 6 (of 6 total)
  • The topic ‘MT import – all comments closed – Can I change tha’ is closed to new replies.