After I updated my site, I found out that all the node comments are set to "disabled." I then went to the specific content type setting page, and changed the default comment setting to read/write, but the nodes of that content type are still disabled. If I change the comment settings for each node, that would be a too cumbersome work. Is there a way to change each node comment setting using a SQL command?

1 Answer 1


Comment settings for each post are stored in the node table. You can run the following, or similar, query:

UPDATE node set comment = 2 WHERE type = 'foo';

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.