#398272 by jmpoure: Fix PostgreSQL support in gmap_location.

diff --git a/gmap_location.module b/gmap_location.module
index 3f82917..406f552 100644 (file)
--- a/gmap_location.module
+++ b/gmap_location.module
@@ -130,7 +130,9 @@ function gmap_location_user_page() {
     AND
       (l.latitude != 0 OR l.longitude != 0)
     GROUP BY
-      i.uid, i.lid");
+      i.uid, i.lid, u.name, l.latitude, l.longitude");
+  // The u.name, l.latitude, and l.longitude in the GROUP BY are needed for
+  // PostgreSQL.
 
   while ($row = db_fetch_object($result)) {
     // Determine marker type to show.