This bug affects at least 5.x.-1.x-dev and 5.x.-1.0 using PostgreSQL. I get following message, when i try to access the view taxonomy_term:

* warning: pg_query() [function.pg-query]: Query failed: ERROR: syntax error at or near "ON" at character 161 in /srv/www/drupal/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( DISTINCT ON (node.nid) node.nid) AS num_nodes 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 node.nid, term_lineage_lineage ASC LIMIT 999 OFFSET 0 in /srv/www/drupal/includes/database.pgsql.inc on line 144.

Comments

dmitrig01’s picture

dmitrig01 commented
Project: Views Bonus Pack » Views (for Drupal 7)

This is not a bug with views_bonus.

merlinofchaos’s picture

merlinofchaos commented
Status: Active » Closed (won't fix)

"count( DISTINCT ON (node.nid) node.nid)"

There's nothing in Views that would create that. I dunno where that's coming from, but it's not Views. Maybe it's the db_rewrite_sql but that doesn't look like a typical error from that either.

I dunno what to tell you.