Problem:

* warning: pg_query() [function.pg-query]: Query failed: ERROR: column "u.name" must appear in the GROUP BY clause or be used in an aggregate function in /websites/afilias.info/afilias.info-Build-#/current/includes/database.pgsql.inc on line 125.
* user warning: query: SELECT v.uid, v.hostname, v.timestamp, u.name FROM votingapi_vote v LEFT JOIN users u ON v.uid = u.uid WHERE v.content_type = 'advpoll' AND v.content_id = 30 GROUP BY v.uid, v.hostname, v.timestamp ORDER BY u.name ASC LIMIT 20 OFFSET 0 in /websites/afilias.info/afilias.info-Build-#/current/includes/database.pgsql.inc on line 144.

Patch attached:

CommentFileSizeAuthor
advpoll.module_pgsql_group_by.patch949 bytespearcec

Comments

ChrisKennedy’s picture

Status: Needs review » Fixed

Fixed, thanks for the report & patch.

Status: Fixed » Closed (fixed)

Automatically closed -- issue fixed for two weeks with no activity.