N/APosted on - 10/02/2011
My Drupal is very slow and I am encountering errors with my comment module. I encountered the problem when I updated my Drupal moderator module. I experience errors whenever I log out. But, it used to be fine before I created the updates. I am using Drupal 7.0, a free and opensource content management system (CMS).
This is the error message I get:
"Unknown column 'n.moderate' in 'where clause' query: SELECT n.nid FROM node_comment_statistics n WHERE ((n.moderate != 1 OR n.uid = 0)) AND ( n.comment_count > 0 )"
What can I do to resolve this?
Comment Module Error in Drupal 7.0
It seems that you have a problem with the query that its searching in the database. It is related to the comments side of your website. Try checking your codes and the records and attributes in your tables in your database. It is looking for the "moderate" column in your "n" table so the error must be within those data. It could also be that the result is an error or it is a null value.
Note: I don't think Drupal would send an update that will make your software run slower, it must be within the code itself, try checking it.