I'm trying to setup a view that displays a list of users Node Comment-type nodes sorted by the taxonomy term of the parent. I have added "Node: Origiinal Parent Nid" as a relationship then tried adding "Taxonomy: Term" with the "Node" reliationship as both a field and a sort criteria. This is the error I get in The Red Box of Dissapointment under "Live preview":

user warning: Unknown column 'node_node_comments.tid' in 'on clause' query: SELECT node.nid AS nid, node_node_comments__term_data.name AS node_node_comments__term_data_name, node_node_comments__term_data.vid AS node_node_comments__term_data_vid, node_node_comments__term_data.tid AS node_node_comments__term_data_tid, node.title AS node_title, node.type AS node_type, node.changed AS node_changed FROM node node LEFT JOIN node_comments node_comments ON node.nid = node_comments.cid LEFT JOIN node node_node_comments ON node_comments.nid = node_node_comments.nid INNER JOIN users users ON node.uid = users.uid LEFT JOIN term_data node_node_comments__term_data ON node_node_comments.tid = node_node_comments__term_data.tid WHERE (node.type in ('review')) AND (users.name = 'tai-te') ORDER BY node_node_comments__term_data_name ASC LIMIT 0, 10 in .../sites/all/modules/views/includes/view.inc on line 723.

Comments

crea’s picture

Status: Active » Closed (fixed)

D6 1.x branch is not supported anymore. Closing.