HI,

I recently installed APK and got teh following user warning when clicking in the user 3 Posts tab:
( user 1 does not get this warning)

user warning: Unknown column 'node.nid' in 'on clause' query: SELECT COUNT(*) FROM (SELECT node.nid AS nid FROM dkvv_node node INNER JOIN dkvv_node_comment_statistics node_comment_statistics ON node.nid = node_comment_statistics.nid LEFT JOIN dkvv_history history_user ON node.nid = history_user.nid AND history_user.uid = 3 WHERE (node.status <> 0) AND (node.type not in ('uprofile')) AND (node.uid = 3 OR ((SELECT COUNT(*) FROM dkvv_comments c INNER JOIN dkvv_node_access na ON na.nid = node.nid WHERE (na.grant_view >= 1 AND ((na.gid = 0 AND na.realm = 'all') OR (na.gid = 1 AND na.realm = 'private') OR (na.gid = 3 AND na.realm = 'private_author'))) AND ( c.uid = 3 AND c.nid = node.nid) > 0)) )) count_alias in /var/www/vhosts/diegojulian.nl/httpdocs/sites/all/modules/views/includes/view.inc on line 739.
user warning: Unknown column 'node.nid' in 'on clause' query: SELECT node.nid AS nid, node.title AS node_title, node.language AS node_language, node_comment_statistics.comment_count AS node_comment_statistics_comment_count, node_comment_statistics.last_comment_timestamp AS node_comment_statistics_last_comment_timestamp, history_user.timestamp AS history_user_timestamp, history_user.nid AS history_user_nid, node.created AS node_created, node.changed AS node_changed, node.type AS node_type FROM dkvv_node node INNER JOIN dkvv_node_comment_statistics node_comment_statistics ON node.nid = node_comment_statistics.nid LEFT JOIN dkvv_history history_user ON node.nid = history_user.nid AND history_user.uid = 3 WHERE (node.status <> 0) AND (node.type not in ('uprofile')) AND (node.uid = 3 OR ((SELECT COUNT(*) FROM dkvv_comments c INNER JOIN dkvv_node_access na ON na.nid = node.nid WHERE (na.grant_view >= 1 AND ((na.gid = 0 AND na.realm = 'all') OR (na.gid = 1 AND na.realm = 'private') OR (na.gid = 3 AND na.realm = 'private_author'))) AND ( c.uid = 3 AND c.nid = node.nid) > 0)) )ORDER BY node_comment_statistics_last_comment_timestamp DESC LIMIT 0, 25 in /var/www/vhosts/diegojulian.nl/httpdocs/sites/all/modules/views/includes/view.inc on line 765.

What is this warning?

Mark

Comments

michelle’s picture

Assigned: El Rey Mark » Unassigned
Category: bug » support
Status: Active » Postponed (maintainer needs more info)

I don't know... I can't reproduce it. That page is just a view. Possibly something to do with the node access module(s) you're using? Try turning those off and see if the error goes away.

Michelle

soyarma’s picture

looks like it may also be from the comment statistics since that is what references node.nid in it's ON clause

michelle’s picture

Status: Postponed (maintainer needs more info) » Closed (won't fix)

node_comment_statistics is part of core so probably not.

No response from the OP so closing.

Michelle