I'm running MySQL v4.1.21 and PHP 5.1.4. I've just installed the latest version of modr8 but get a MySQL error on my home page above all entries, here's the error message:

user warning: 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 ) ORDER BY n.last_comment_timestamp DESC LIMIT 0, 10 in /home/mattnli/public_html/drupal/includes/database.mysql.inc on line 172.

Other info:

Any idea's why this is happening? Why is this query looking for n.moderate or n.uid when neither of these exist in the node_comment_statistics table?

Note: Everything else works fine (Drupal and other modules).

Thanks in advance for your help.
Matthew

CommentFileSizeAuthor
drupal-error-screenshot.gif7.4 KBxybermatthew

Comments

pwolanin’s picture

pwolanin commented

Yes- existing issues about this:

http://drupal.org/node/111830

http://drupal.org/node/111421

I assume you have the recent comment block enabled? Try the patch at the first issue above and follow-up there.

pwolanin’s picture

pwolanin commented
Status: Active » Fixed

since the patch at http://drupal.org/node/111830 was committed, this should be fixed.

Anonymous’s picture

(not verified) commented
Status: Fixed » Closed (fixed)