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.<\/p>\n
The first step to undertake in this case is to disable the comments module until you delete all the spam comment posts.<\/p>\n
You have 2 options for doing this:<\/strong><\/p>\n #1 \u2013 Through Drupal Admin<\/strong><\/p>\n If you are using the Drupal version 7.x\/8.x, you can disable the spam comments through these steps:<\/strong><\/p>\n #2 \u2013 By Executing SQL Query<\/strong><\/p>\n Deleting the spam comments can also be done through phpMyAdmin by executing the SQL query mentioned below in your database:<\/p>\n UPDATE system SET status = ‘0’ WHERE filename =\u00a0 ‘modules\/comment\/comment.module’;<\/p>\n When you would like to enable the comments option again, execute a reverse query:<\/p>\n UPDATE system SET status = ‘1’ WHERE filename =\u00a0 ‘modules\/comment\/comment.module’;<\/p>\n 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.<\/p>\n","protected":false},"excerpt":{"rendered":" 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.<\/p>\n","protected":false},"author":4,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[128],"tags":[164,310,235,309,55],"class_list":["post-3637","post","type-post","status-publish","format-standard","placeholder-for-hentry","category-cms-faq","tag-blog","tag-comments","tag-drupal","tag-spam-comments","tag-website"],"yoast_head":"\n\n
\n