Disable or enable comments for node types en mass

This snippit allows you to bulk enable or disable comments for nodes through the database.

SQL to disable comments for all nodes of type "story":
UPDATE node SET comment = 0 WHERE type LIKE "story";

comment = 2 would mass enable read/write
comment = 1 would mass enable just read
You can change "story" to "page" or whatever you'd like.

An alternate solution using Drush

Shows what node types have been created:
drush sql-query "SELECT DISTINCT type FROM node ORDER BY type"

Shows what node types have been created that have comments enabled:
drush sql-query "SELECT DISTINCT type FROM node WHERE comment <> 0 ORDER BY type"

Shows nodes titles that have comments enabled:
drush sql-query "SELECT title, type, comment FROM node WHERE comment <> 0 ORDER BY type"

Drush SQL query to disable comments for all nodes of type "story":
drush sql-query "UPDATE node SET comment = 0 WHERE type LIKE 'story'"

An alternate solution using Views Bulk Operations

A different method would be using VBO. Admin Views provides an out-of-the-box replacement for your main content list using VBO (but you can use VBO without Admin Views also). You can then:

select all the nodes you want
choose the operation: Change value and click [execute]
choose the value to modify (comments allowed), click [next]
set value to 0 or 1 or 2

Comments

thanks

bevin commented 3 June 2011 at 07:29

that is exactly what I need

Well, yes. But...

doublejosh commented 11 June 2011 at 08:29

Well, yes. But...
-- Would love to provide a UI to choose a large number of nodes, but not all of a type.
-- I prefer not to do this kind of thing in production.

D7

ngstigator commented 29 August 2011 at 22:21

http://drupal.org/node/103064#comment-4922950

You wanna do this via the

AaronELBorg commented 21 September 2012 at 23:23

You wanna do this via the abstraction layer, do ya?

Yeah, I know you do.

That's why I'm here to help you out, friend!!

$subquery = db_select('node');
$subquery->addField('node', 'nid');
$subquery->condition('node.type', 'YOUR_NODE_TYPE', '=');

$num_updated = db_update('node_revision')
->fields(array('comment' => '2',))
->condition ('node_revision.nid', $subquery, 'IN')
->execute();

I couldn't figure out how to do a join in a db_update.

Is it possible?

You need to change the

Shai commented 18 December 2012 at 04:18

You need to change the setting in the node revisions table as well. Maybe something like the following in addition to the original query:

UPDATE node_revision, node SET node_revision.comment = 2 WHERE
  node_revision.nid = node.nid AND
  node.type = "story";

content2zero.com

Update node tables as well

mchar commented 19 September 2016 at 12:02

Why don't you update and the node table, so to be:

UPDATE node_revision, node SET node_revision.comment = 2, node.comment = 2 
 WHERE  node_revision.nid = node.nid AND  node.type = "story";

is it wrong to do so, or is there any difference or it will be updated (the node table) on some future node save through the UI ?

Thank you ! A lot easier than using boring unclear VBO !

MakeOnlineShop commented 17 March 2013 at 09:24

Thank you ! A lot easier than using boring unclear VBO !

An example - a summary of both steps:

rodtatham commented 28 June 2013 at 14:51

Here's a complete example for a content type called "toolkit" in D7. This will turn on comments on all content types on your site:-

UPDATE `node` SET `comment` = '2' WHERE `type` = 'toolkit';
UPDATE node_revision SET comment=2 WHERE nid IN (SELECT nid FROM node WHERE node.type='toolkit');

Setting to zero rather than 2 turns them off.

Hope it's helpful.

Thank you, it is good example

dr.admin commented 19 February 2014 at 19:39

Thank you, it is good example and it works.

--
Drupal sites and server support - https://drupal-admin.com

here's how to set all

markshust commented 25 September 2014 at 11:16

here's how to set all comments to read only after they are 3 months old

UPDATE node SET comment = 1 WHERE created <= UNIX_TIMESTAMP(DATE_SUB(now(), INTERVAL 3 MONTH));
UPDATE node_revision SET comment = 1 WHERE timestamp <= UNIX_TIMESTAMP(DATE_SUB(now(), INTERVAL 3 MONTH));