Knowledge Base
MilesWeb / CMS FAQ

How To Disable Comments In Drupal?

Approx. read time : 2 min

If you are working with Drupal, you will often encounter issues with spam bots that post a huge number of spam comments. This is specifically true if you are working with an older version of Drupal.

The first step to undertake in this case is to disable the comments module until you delete all the spam comment posts.

You have 2 options for doing this:

#1 – Through Drupal Admin

  • Login to your Drupal admin area
  • Go to Administrator >> Content >> Content Types
  • Edit the content type you prefer
  • Ensure that the comments are on ‘OFF’ mode by default

If you are using the Drupal version 7.x/8.x, you can disable the spam comments through these steps:

  • Login to your admin area
  • Go to Structure >> Content >> Types >>Comment Settings
  • Select the option ‘Closed’ present under ‘Default comment setting’
  • Save the changes

#2 – By Executing SQL Query

Deleting the spam comments can also be done through phpMyAdmin by executing the SQL query mentioned below in your database:

UPDATE system SET status = ‘0’ WHERE filename =  ‘modules/comment/comment.module’;

When you would like to enable the comments option again, execute a reverse query:

UPDATE system SET status = ‘1’ WHERE filename =  ‘modules/comment/comment.module’;

It is recommended to use a CAPTCHA module by Akismet to block the spam comments. Even if a spam bot passes the Captcha, Akismet will check it through a spam database. Only if the source of comment is legitimate, it will appear on your dashboard for you to approve or disapprove or delete it.

My aim is to create enriching content on topics related to SEO, web hosting and social media. The idea is to elevate the readers to new levels of usability, accessibility and understanding.

Trusted By Thousands of Clients & Big Businesses

We highly appreciate the kind and stellar feedback we receive from our customers. Delivering the best is our goal! MilesWeb is rated Excellent out of 5 based on reviews. Read more reviews.

Excellent
Based on reviews
2 hours ago
Perfect and Valuable Server + ...
I am using MilesWeb Servers, The main thing which I getting are continuous support over everything w...
Gunjan Makwana
4 hours ago
Milesweb is superb Hosting pro...
Milesweb is superb Hosting provider ever, their Support team is amazing!!!...
Abhishek Singh
15 hours ago
Great support in great timing...
We need urgent assistance on changes in a primary domain on our client's Cpanel accounts and reached...
Riyaju Deen
21 hours ago
Best Website Hosting platform ...
I was new on MilesWeb. And needed help on multiple areas from setting up to getting started with cre...
Harshada
1 days ago
Very quick and helpful assista...
Very quick and helpful assistance. Support person listened properly and provided a nice solution....
Narendra
1 days ago
the team is very supportive th...
the team is very supportive though at times effort needs to be made to make understand the problem s...
Suree Sharma
1 days ago
I am using miles web for 3plus...
I am using miles web for 3plus years, very quick and perfect support by the team, they helped me man...
Sri Raghav
2 days ago
The service is good...
The service is good. They are answering with patience and doing the needful as soon as possible....
MR
2 days ago
Perfect and Valuable Server + ...
I am using MilesWeb Servers, The main thing which I getting are continuous support over everything w...
Gunjan Makwana
3 days ago
Very quick and helpful assista...
Very quick and helpful assistance. Support person listened properly and provided a nice solution....
Narendra
4 days ago
positively helped me with find...
positively helped me with finding insecure content on my website causing SSL to not work properly on...
Thaviraj Junglee
4 days ago
Exceptional support, Truly Pra...
I had opted for the basic wordpress hosting plan as I intended to experiment with various plug-ins. ...
Aseem Chandna