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

dawehner’s picture

Category: support » bug
Status: Active » Postponed (maintainer needs more info)

Can you please export this view, so we can reproduce it easy?

This seems to be somehow a bug.

johncionci’s picture

StatusFileSize
new7 KB

Exported View attached.

dawehner’s picture

This seems to be a bug of


$handler->override_option('style_plugin', 'grouping_limit');

Do you have an idea which module adds this style plugin?

johncionci’s picture

Views 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!

esmerel’s picture

Project: Views (for Drupal 7) » Views Grouping Row Limit
Version: 6.x-2.12 » 6.x-1.4
Component: taxonomy data » Code
Status: Postponed (maintainer needs more info) » Active

Tossing this over - this seems like something you might want to look at?