On lines 575 and 627 appear statements like this:

$sql = "SELECT p.uid, u.name, p.points
FROM {userpoints} p INNER JOIN {users} u USING (uid)
GROUP BY p.uid";

It seems to me that the GROUP clause is not needed as the uid is always unique. In PostgreSQL deleting this clause fixes the "Query failed: ERROR: column 'u.name' must appear in the GROUP BY clause or be used in an aggregate function in" issue.

CommentFileSizeAuthor
#3 userpoints.module_0.diff941 bytesckg
userpoints.module.diff1.14 KBckg

Comments

ckg’s picture

Title: Install for PostgreSQL » PostgreSQL: u.name must appear in the GROUP BY clause

Disregard the previous title. Forgot to change it. Title should have been as appears above.

kbahey’s picture

Status: Needs review » Needs work

Please use unidiff, as shown here http://drupal.org/patch

ckg’s picture

StatusFileSize
new941 bytes

Same thing -- except using proper diff format.

kbahey’s picture

Status: Needs work » Fixed

Committed to 5.x and HEAD.

Thanks

Anonymous’s picture

Status: Fixed » Closed (fixed)