I don't know enough about this module yet to say for sure what's wrong but I will relate to you the symptoms I am seeing. My implementation is Drupal 5.5 with PostgreSQL. I have only been using Firefox 2.0 up to this point.

1. I was able to select Lat/Long on my own user map under my profile but it does not display on my View tab. It only displays on my Edit tab.

2. While I see the marker for my location on my user map under the Edit tab, I don't see my marker on the site user locations map either. The map displays but the following errors appear on the page:

    * 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 /usr/local/apache2/htdocs/drupal/includes/database.pgsql.inc on line 125.
    * user warning: query: SELECT u.name, MAX(r.rid) as role, l.eid as uid, l.latitude, l.longitude FROM users u INNER JOIN location l ON u.uid = l.eid LEFT JOIN users_roles r ON l.eid = r.uid WHERE l.type = 'user' AND (l.latitude != 0 OR l.longitude != 0) GROUP BY l.eid in /usr/local/apache2/htdocs/drupal/includes/database.pgsql.inc on line 144.

I would really like to use this module to display user locations with their avatar/picture on a map for the whole site. Additionally, I would like user locations maps for members of my organic groups. I'm hoping all of this is possible and would appreciate any advise in getting me there including estimates for contracting this work.

Thanks!

CommentFileSizeAuthor
#3 gmap-5.x-1.0-alpha1-pgsql.patch733 bytespounard

Comments

tinou’s picture

tinou commented

Same settings for me (Lighttpd, PostgreSQL, Drupal 5.5) and a warning that is sometimes the same as described by WISeOz, sometimes has some extras:

    * warning: pg_query() [function.pg-query]: Query failed: ERROR: relation "location_fax" does not exist in /var/www/lighttpd/test/includes/database.pgsql.inc on line 125.
    * user warning: query: SELECT fax FROM location_fax WHERE lid = 1 in /var/www/lighttpd/test/includes/database.pgsql.inc on line 144.
    * warning: pg_query() [function.pg-query]: Query failed: ERROR: relation "location_phone" does not exist in /var/www/lighttpd/test/includes/database.pgsql.inc on line 125.
    * user warning: query: SELECT phone FROM location_phone WHERE lid = 1 in /var/www/lighttpd/test/includes/database.pgsql.inc on line 144.
    * 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 /var/www/lighttpd/test/includes/database.pgsql.inc on line 125.
    * user warning: query: SELECT u.name, MAX(r.rid) as role, l.eid as uid, l.latitude, l.longitude FROM users u INNER JOIN location l ON u.uid = l.eid LEFT JOIN users_roles r ON l.eid = r.uid WHERE l.type = 'user' AND (l.latitude != 0 OR l.longitude != 0) GROUP BY l.eid in /var/www/lighttpd/test/includes/database.pgsql.inc on line 144.
Anonymous’s picture

Anonymous (not verified) commented

Same problem over here. Apache 2, PostgreSQL, Drupal 5.1.

    * 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 /home/dmclaren/http/danielmclaren.net/includes/database.pgsql.inc on line 125.
    * user warning: query: SELECT u.name, MAX(r.rid) as role, l.eid as uid, l.latitude, l.longitude FROM gn_users u INNER JOIN gn_location l ON u.uid = l.eid LEFT JOIN gn_users_roles r ON l.eid = r.uid WHERE l.type = 'user' AND (l.latitude != 0 OR l.longitude != 0) GROUP BY l.eid in /home/dmclaren/http/danielmclaren.net/includes/database.pgsql.inc on line 144.

Node locations isn't displaying at all (error 404) but I'm guessing that's a separate issue.

pounard’s picture

pounard
Primary language French
commented
StatusFileSize
new gmap-5.x-1.0-alpha1-pgsql.patch733 bytes

I had to correct manually to use gmap location, here is a quick patch that works with the 5.x-1.0-alpha1 version.

bdragon’s picture

bdragon commented
Status: Active » Postponed (maintainer needs more info)

Is the beta any better?

pounard’s picture

pounard
Primary language French
commented

The beta is better, I don't have those messages anymore, but I don't have any markers displaying anymore :(
If there is no revelant PostgreSQL error message, I can't help !

Update: Ok, works fine, great work. The only problem remaining for me is when loading a GMap, it does not center on the marker(s).

bdragon’s picture

bdragon commented
Status: Postponed (maintainer needs more info) » Fixed

OK, could you file a seperate bug for that then? Thanks.

pounard’s picture

pounard
Primary language French
commented

I don't really have time to do this now, so I can't help you right now. I'll maybe try to take a look later but I can't promise anything :(

Anonymous’s picture

Anonymous (not verified) commented
Status: Fixed » Closed (fixed)

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

sebzur’s picture

sebzur commented
Status: Closed (fixed) » Needs review

I managed to make users location display simply, by adding u.name, l.latitude, l.longitude to GROUP BY clause in line 133 in gmap_location.module file of gmap module:

GROUP BY
      u.name, i.uid, i.lid, l.latitude, l.longitude");

I hope, this will be helpful.

bdragon’s picture

bdragon commented
Status: Needs review » Fixed
Issue tags: +PostgreSQL

Fixed in #398272: PostrgeSQL needs explicit column names in GROUP BY when aggregate is used.

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

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

Issue tags: +PostgreSQL

Restoring issue tags, see #2125755: System messages removed all issue tags during D7 upgrade.