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
Comment #1
michelleI 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
Comment #2
soyarma commentedlooks like it may also be from the comment statistics since that is what references node.nid in it's ON clause
Comment #3
michellenode_comment_statistics is part of core so probably not.
No response from the OP so closing.
Michelle