The forum module uses on lines 509 and 557 COUNT-statements that are not correctly mapped by db_distinct_field.

Such a malformed query that is not accepted by postgres looks like this:

SELECT COUNT( DISTINCT ON (n.nid) n.nid) FROM node n INNER JOIN term_node tn ON n.vid = tn.vid AND tn.tid = 2 LEFT JOIN history h ON n.nid = h.nid AND h.uid = 1 WHERE n.status = 1 AND n.created > 1205455563 AND h.nid IS NULL

http://www.postgresql.org/docs/8.3/interactive/queries-select-lists.html...

Comments

dpearcefl’s picture

dpearcefl commented
Status: Active » Postponed (maintainer needs more info)

Does this issue exist in current D6?

dpearcefl’s picture

dpearcefl commented
Status: Postponed (maintainer needs more info) » Active
wienczny’s picture

wienczny commented

I don't currently have a drupal 6.x installatoin. This bug was a show stopper for me.

Status: Active » Closed (outdated)

Automatically closed because Drupal 6 is no longer supported. If the issue verifiably applies to later versions, please reopen with details and update the version.