Come together with the global Drupal community in Rotterdam, 28 Sept – 1 Oct 2026. Sessions, contribution, connection, and Early Bird savings until 8 June.
By bigsend on
I imported all my blog posts from wordpress to drupal but now, all the blog comments are read only.
How do I change all blog posts to read/write comment access?
-Thanks
BigSend
http://bigsendworld.com
Comments
Check one of those blog
Check one of those blog posts. There is a "Comment settings" section in the edit form, with possible values "Disabled", "Read only", "Read write". You can change that setting (if that was the problem).
If you want to do some bulk database operation, this is in the "node" table, "comment" column, with possible values 0, 1, 2 respectively.
Yes I would like to do bulk
Yes I would like to do bulk database operation..
you said, "If you want to do some bulk database operation, this is in the "node" table, "comment" column, with possible values 0, 1, 2 respectively." Which file do I perform these operations in?
Is there a readme or help-file documentation for that particular file?
-Thanks
BigSend
http://bigsendworld.com
That is not in a file
That is not in a file. It is in the database. Direct database operations are dangerous territory, so there is no documentation.
First verify that changing that setting in a blog post solves the problem. If so, proceed.
Go to your site's database using phpmyadmin
- Take a backup of the database, just in case.
- Browse the "node" table, take a look, notice the "comment" column. You should see that your blog posts have a value 0 there, which you need to change to 2 in all of them.
- If your blog posts are really of type "blog", then click on the SQL tab and use the query:
If the table name was not exactly
nodebut had a prefix in front, append it.If any of my "ifs" was not so, don't do it and ask again.
It worked!! Thanks a
It worked!!
Thanks a lot.
-Thanks
BigSend
http://bigsendworld.com