user warning: Unknown column 'nc.uid' in 'where clause' query: SELECT nc.nid FROM node_comment_statistics nc WHERE (nc.uid NOT IN (739)) AND ( nc.comment_count > 0 )ORDER BY nc.last_comment_timestamp DESC LIMIT 0, 10 in /var/www/html/modules/comment/comment.module on line 316.

Comments

danielb’s picture

danielb commented

That doesn't make sense. :/ This module does not affect comment queries unless the primary field is 'cid', which it is not in that case.

danielb’s picture

danielb commented
Category: bug » support
Status: Active » Postponed (maintainer needs more info)

I can't reproduce this, and you have not sufficiently identified a bug. I will need to be told exactly what the problem with the code is, or given instructions to reproduce this, in order to do anything about it.

steven9’s picture

steven9 commented

Actually it is not on enabling the module, but on checking the "Cave" user on any user profile. I get the warning error that later never goes away, it just stays there.

UnitedVision’s picture

UnitedVision commented

this happens to me as well. i just installed troll & cave. I click to cave a user and my block that shows recent comments on the home page disappears and I get the following error.

user warning: Unknown column 'nc.uid' in 'where clause' query: SELECT nc.nid FROM node_comment_statistics nc WHERE (nc.uid NOT IN (33)) AND ( nc.comment_count > 0 )ORDER BY nc.last_comment_timestamp DESC LIMIT 0, 10 in /hermes/bosweb/web222/b2221/ipg.mydomain/modules/comment/comment.module on line 314.

danielb’s picture

danielb commented
Status: Postponed (maintainer needs more info) » Active

yeah OK I see the problem now, I'll need to check the table as well as the primary field.

danielb’s picture

danielb commented
Category: support » bug
danielb’s picture

danielb commented
Status: Active » Fixed

This should no longer be a problem in future versions.

Status: Fixed » Closed (fixed)

Automatically closed -- issue fixed for 2 weeks with no activity.