By iwant2fly on

I have about 5000 nodes that we initially did not allow commenting on. I now want to allow comments on them. How can I bulk update those nodes to allow comments? The module Mass Change sounds perfect but it is only for D5 & 6.

⋅ Categories: Drupal 7.x

Comments

sushantpaste’s picture

sushantpaste
Primary language Marathi
Location Sawantwadi India
commented

You can do it with the help of views bulk operations by creating view of that content type and adding field "bulk operation content".

Hth
S

Ayesh’s picture

Ayesh commented

Yes, VBO can do the trick with zero coding.
You will not find a "allow comments" action but there is a "modify entity values" action that you can choose comment status in the next step.

Set the value to 2 (numeric) to enable comments and read/write.
1 is read only, 0 is for disabled.

What's new and changing in PHP 8

iwant2fly’s picture

iwant2fly commented

This did the trick. Took a good while to update that many nodes, but other than that perfect. Thank you very much. That is an awesome module.

cfox612’s picture

cfox612 commented

Also possible to bulk change through the database (I never had luck getting VBO to do anything other than give me a headache :)
This really only works if you have a distinguishing factor (one content type for instance, after a certain date, etc. This post gives you the queries you'd need to run (one for the node table and one for node_revision).