How to disable or enable comments on node types as Bulk
If you have a content type where you have comments enabled/disabled and later you have decided to ON/OFF the comments but the problem is that if you have disabled/enabled the comments from the content type, it does not turn off/on the comments on existing nodes which you have made before.
To turn off the comments you have to update 2 tables not just one . These are :
So run the query :
UPDATE node_revision, node SET node_revision.comment = 0 WHERE node_revision.nid = node.nid AND node.type = "story";
Where comment values can be 0,1,2.
0 = no, 1 = closed (read only), 2 = open .