modules/relevant_content/relevant_content.module
line 502
'GROUP BY n.nid' should be => 'GROUP BY n.nid, n.vid, n.title, n.type, n.created'

Comments

interestingaftermath’s picture

interestingaftermath commented

I believe this is the same issue. I am also having the problem:

    * warning: pg_query() [function.pg-query]: Query failed: ERROR: column "n.vid" must appear in the GROUP BY clause or be used in an aggregate function in /var/www/includes/database.pgsql.inc on line 139.
    * user warning: query: SELECT n.nid AS nid, n.vid AS vid, n.title AS title, n.type AS type, COUNT(*) AS cnt FROM node n LEFT JOIN term_node tn ON tn.nid = n.nid AND tn.tid IN(34) WHERE n.type IN ('editorial_content') AND n.status = 1 AND tn.tid IS NOT NULL AND n.nid NOT IN (7552) GROUP BY n.nid ORDER BY cnt DESC, n.created DESC, n.nid DESC LIMIT 5 in /var/www/sites/all/modules/contrib/relevant_content/relevant_content.module on line 508.