* warning: pg_query() [function.pg-query]: Query failed: ERREUR: la colonne « u.name » doit apparaître dans la clause GROUP BY ou doit être utilisé dans une fonction d'agrégat in /home/html/test/includes/database.pgsql.inc on line 139.
    * user warning: query: SELECT u.name, MAX(r.rid) as role, i.uid, i.lid, l.latitude, l.longitude FROM users u INNER JOIN location_instance i ON u.uid = i.uid INNER JOIN location l ON i.lid = l.lid LEFT JOIN users_roles r ON i.uid = r.uid WHERE u.status = 1 AND u.access != 0 AND (l.latitude != 0 OR l.longitude != 0) GROUP BY i.uid, i.lid in /home/html/test/sites/all/modules/gmap/gmap_location.module on line 133.

Patch attached. Please apply.

CommentFileSizeAuthor
patch.diff429 bytesgrub3

Comments

bdragon’s picture

Status: Needs review » Fixed
Issue tags: +PostgreSQL

Status: Fixed » Closed (fixed)
Issue tags: -PostgreSQL

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