Comment Module Error in Drupal 7.0

Asked By Anthony Curtis 0 points N/A Posted 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?

• Status: Open
• Question Views: 1020
• Answer Count: 1
• Vote Up 0 Vote Down

• Answer Accepted: No
• Question Category: Network Management

Answered By Alber grower 0 points N/A #85293

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.

About Alber grower

Questions
0

Answers
370

Best Answers
106

• Vote Up 0 Vote Down

• Posted on - 10/03/2011
• Question Category: Network Management