I receive huge error when trying to build a Taxonomy View. This only happens after I add the ( (node) Node: Last comment author ) Field to my View. I have the exact same View built using the Node View and it works fine.
user warning: Unknown column 'node_term_node.last_comment_uid' in 'on clause' query: SELECT COUNT(*) FROM (SELECT DISTINCT(term_data.tid) AS tid, node_term_node__users.picture AS node_term_node__users_picture, node_term_node__users.uid AS node_term_node__users_uid, node_term_node__users.name AS node_term_node__users_name, node_term_node__users.mail AS node_term_node__users_mail, node_term_node.title AS node_term_node_title, node_term_node.nid AS node_term_node_nid, node_term_node__node_comment_statistics.comment_count AS node_term_node__node_comment_statistics_comment_count, COALESCE(node_term_node_ncs_users.name, node_term_node__node_comment_statistics.last_comment_name) AS node_term_node__node_comment_statistics_last_comment_name, node_term_node_ncs_users.name AS node_term_node_ncs_users_name, node_term_node__node_comment_statistics.last_comment_uid AS node_term_node__node_comment_statistics_last_comment_uid, node_term_node__node_comment_statistics.last_comment_timestamp AS node_term_node__node_comment_statistics_last_comment_timestamp, term_data.name AS term_data_name, term_data.vid AS term_data_vid FROM term_data term_data LEFT JOIN term_node term_node ON term_data.tid = term_node.tid LEFT JOIN node node_term_node ON term_node.vid = node_term_node.vid LEFT JOIN term_node node_term_node__term_node ON node_term_node.vid = node_term_node__term_node.vid LEFT JOIN term_node node_term_node_node_term_node__term_node ON node_term_node.vid = node_term_node_node_term_node__term_node.vid LEFT JOIN term_data node_term_node__term_data ON node_term_node__term_node.tid = node_term_node__term_data.tid INNER JOIN users node_term_node__users ON node_term_node.uid = node_term_node__users.uid INNER JOIN node_comment_statistics node_term_node__node_comment_statistics ON node_term_node.nid = node_term_node__node_comment_statistics.nid LEFT JOIN users node_term_node_ncs_users ON node_term_node.last_comment_uid = node_term_node_ncs_users.uid AND node_term_node_ncs_users.uid != '0' WHERE node_term_node__term_data.vid in ('1') GROUP BY tid ) count_alias in /var/www/html/sites/all/modules/views/includes/view.inc on line 745.
user warning: Unknown column 'node_term_node.last_comment_uid' in 'on clause' query: SELECT DISTINCT(term_data.tid) AS tid, node_term_node__users.picture AS node_term_node__users_picture, node_term_node__users.uid AS node_term_node__users_uid, node_term_node__users.name AS node_term_node__users_name, node_term_node__users.mail AS node_term_node__users_mail, node_term_node.title AS node_term_node_title, node_term_node.nid AS node_term_node_nid, node_term_node__node_comment_statistics.comment_count AS node_term_node__node_comment_statistics_comment_count, COALESCE(node_term_node_ncs_users.name, node_term_node__node_comment_statistics.last_comment_name) AS node_term_node__node_comment_statistics_last_comment_name, node_term_node_ncs_users.name AS node_term_node_ncs_users_name, node_term_node__node_comment_statistics.last_comment_uid AS node_term_node__node_comment_statistics_last_comment_uid, node_term_node__node_comment_statistics.last_comment_timestamp AS node_term_node__node_comment_statistics_last_comment_timestamp, term_data.name AS term_data_name, term_data.vid AS term_data_vid FROM term_data term_data LEFT JOIN term_node term_node ON term_data.tid = term_node.tid LEFT JOIN node node_term_node ON term_node.vid = node_term_node.vid LEFT JOIN term_node node_term_node__term_node ON node_term_node.vid = node_term_node__term_node.vid LEFT JOIN term_node node_term_node_node_term_node__term_node ON node_term_node.vid = node_term_node_node_term_node__term_node.vid LEFT JOIN term_data node_term_node__term_data ON node_term_node__term_node.tid = node_term_node__term_data.tid INNER JOIN users node_term_node__users ON node_term_node.uid = node_term_node__users.uid INNER JOIN node_comment_statistics node_term_node__node_comment_statistics ON node_term_node.nid = node_term_node__node_comment_statistics.nid LEFT JOIN users node_term_node_ncs_users ON node_term_node.last_comment_uid = node_term_node_ncs_users.uid AND node_term_node_ncs_users.uid != '0' WHERE node_term_node__term_data.vid in ('1') GROUP BY tid LIMIT 0, 5 in /var/www/html/sites/all/modules/views/includes/view.inc on line 771.
Comments
Comment #1
dawehnerCan you please export this view, so we can reproduce it easy?
This seems to be somehow a bug.
Comment #2
johncionci commentedExported View attached.
Comment #3
dawehnerThis seems to be a bug of
Do you have an idea which module adds this style plugin?
Comment #4
johncionci commentedViews Grouping Row Limit
http://drupal.org/project/views_limit_grouping
Essentially I need to do tis:
Term 1
- Node 1
- Node 14
Term 2
- Node 3
- Node 32
Term 3
- Node 3
Term 4
- Node 31
Term 5
- Node 8
Limit "Terms" to 5 per page, so I will need to page 1-5, 6-10, 11-15 etc...
Limit "Nodes" to 5 per "Term".
Thanks for your help!
Comment #6
esmerel commentedTossing this over - this seems like something you might want to look at?