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.
| Comment | File | Size | Author |
|---|---|---|---|
| #3 | userpoints.module_0.diff | 941 bytes | ckg |
| userpoints.module.diff | 1.14 KB | ckg |
Comments
Comment #1
ckg commentedDisregard the previous title. Forgot to change it. Title should have been as appears above.
Comment #2
kbahey commentedPlease use unidiff, as shown here http://drupal.org/patch
Comment #3
ckg commentedSame thing -- except using proper diff format.
Comment #4
kbahey commentedCommitted to 5.x and HEAD.
Thanks
Comment #5
(not verified) commented