I'm using 4.5rc with postgresql 7.4.5 apache 1.x on rhes3
the error occurs regardless of user status/role -- all users get this error message

when you try and select a category (either from the category block, or from the summary view for a node, or you try and navigate to a specific taxonomy term by directly inputting a URL ie: http://www.example.com/taxonomy/term/3) I get the following error and the resulting page says "There are currently no posts in this category." when there are multiple posts within that category:

warning: pg_query(): Query failed: ERROR: for SELECT DISTINCT, ORDER BY expressions must appear in select list in /usr/local/apache/htdocs/includes/database.pgsql.inc on line 104.

user error:
query: SELECT DISTINCT(n.nid) FROM node n INNER JOIN term_node tn0 ON n.nid = tn0.nid WHERE n.status = 1 AND '1' AND tn0.tid IN (3) ORDER BY n.sticky DESC, n.created DESC LIMIT 10 OFFSET 0 in /usr/local/apache/htdocs/includes/database.pgsql.inc on line 121.

Comments

michaelemeyers’s picture

michaelemeyers commented

please disregard this post, too many windows open at one time -- put it in the wrong place; sorry about that :-0