When view type is table and field "Node Comment Statistics: Comment count" is selected, sql query doesn't work, because field name is missing in JOIN statement:
SELECT node.nid AS nid, node_comment_statistics.comment_count AS node_comment_statistics_comment_count, node.sticky AS node_sticky, node.created AS node_created FROM node node LEFT JOIN node_comment_statistics node_comment_statistics ON node.nid = node_comment_statistics. WHERE (node.promote <> 0) AND (node.status <> 0) ORDER BY node_sticky ASC, node_created ASC
Comments
Comment #1
merlinofchaos commentedPutting in a more descriptive title. Will look into this. Thanks.
Comment #2
merlinofchaos commentedThis should be fixed now.
Comment #3
Anonymous (not verified) commentedAutomatically closed -- issue fixed for two weeks with no activity.