Hi, If I try and use the tree lineage tree view I get the following error...

warning: pg_query() [function.pg-query]: Query failed: ERROR: column "term_lineage.tid" must appear in the GROUP BY clause or be used in an aggregate function in /Users/jasonstratford/Sites/cms/includes/database.pgsql.inc on line 125.

user warning: query: SELECT term_lineage.tid AS tid, term_lineage.depth AS term_lineage_depth, term_lineage.lineage AS term_lineage_lineage, term_data.name AS name, count(node.nid) AS num_nodes FROM (SELECT DISTINCT ON (nid) * FROM node) node LEFT JOIN term_node term_node ON node.nid = term_node.nid LEFT JOIN term_lineage term_lineage ON term_node.tid = term_lineage.tid LEFT JOIN term_data term_data ON term_lineage.tid = term_data.tid WHERE (node.status = '1') AND (term_lineage.tid IS NOT NULL) GROUP BY term_data.name, term_lineage_lineage ORDER BY term_lineage_lineage ASC LIMIT 999 OFFSET 0 in /Users/jasonstratford/Sites/cms/includes/database.pgsql.inc on line 144.

I am not up to speed on the way drupal generates these queries so would appreciate some help debugging this.

Many thanks
Jason

Comments

neclimdul’s picture

neclimdul
He/Him
commented
Status: Active » Postponed (maintainer needs more info)

This still valid? I don't have a postgres install to test this on so any help would be appreciated.

pomliane’s picture

pomliane commented
Status: Postponed (maintainer needs more info) » Closed (won't fix)

This version of Views Bonus Pack is not supported anymore. The issue is closed for this reason.
Please upgrade to a supported version and feel free to reopen the issue on the new version if applicable.

This issue has been automagically closed by a script.