How to enable comments on 800 pages ?

poseidon123 - July 16, 2008 - 21:27

ok I have a old site with 800 pages with comments as disabled. Now I want to enable comments on them but manually doing this can take ages. What's the short and sweet way of doing this ? :)

To enable comments for all

nevets - July 16, 2008 - 22:21

To enable comments for all content in the database you could edit the database and do an update like

UPDATE node SET comment = 2

To limit the update you could do something like (you will want to change the name of the type)
UPDATE node SET comment = 2 WHERE type = 'some_type'

 
 

Drupal is a registered trademark of Dries Buytaert.