February 5, 2013
Generally speaking, Drupal does a great job of letting you bulk update content settings across your site. And where core falls short, usually a module called Views Bulk Operations (VBO) jumps in to save the day.
But recently I needed a way to bulk update comment settings. I have a side project where I set commenting to be closed for a content type that I ultimately needed to open commenting on. I searched for a while, even giving VBO a run, but it doesn’t provide the ability to update comment settings.
Unfortunately, there’s no module, so the next best thing was to update rows in the database manually. There are a couple places where rows need to be updated, so here’s the fastest and easiest way to update comment settings in the database.
WARNING: While this is a fairly simple process, if you do not know what you are looking at in the database, this can be a very bad idea!