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

merlinofchaos’s picture

Title: SQL Failure » node comment statistics: comment count causes SQL failure

Putting in a more descriptive title. Will look into this. Thanks.

merlinofchaos’s picture

Status: Active » Fixed

This should be fixed now.

Anonymous’s picture

Status: Fixed » Closed (fixed)

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