Location:Proximity Exposed Filter Error
| Project: | location (API, module) |
| Version: | 5.x-1.x-dev |
| Component: | Code |
| Category: | bug report |
| Priority: | normal |
| Assigned: | Unassigned |
| Status: | active |
Jump to:
I have a view that I use for searching users, and one of the exposed filters is Location:Proximity. When I attempt to use this, I get the following error:
<?code
user warning: Column 'latitude' in field list is ambiguous query: SELECT DISTINCT(node.nid), (((IFNULL(ACOS(0.731738246395*COS(RADIANS(latitude))*(0.318160563877*COS(RADIANS(longitude)) + -0.948036842951*SIN(RADIANS(longitude))) + 0.681585753052*SIN(RADIANS(latitude))), 0.00000)*6368175.74664)) / 1609.347) AS distance, usernode_users.name AS usernode_users_name, usernode_users.uid AS usernode_users_uid, user_location.city AS user_location_city, user_location.country AS user_location_country, usernode_users.created AS usernode_users_created FROM node node LEFT JOIN location location ON node.vid = location.eid INNER JOIN usernode usernode ON node.nid = usernode.nid LEFT JOIN users usernode_users ON usernode.uid = usernode_users.uid LEFT JOIN location user_location ON usernode.uid = user_location.eid WHERE (node.type IN ('uprofile')) AND (node.status = '1') AND (location.longitude IS NOT NULL) AND (location.latitude > 42.6056933981 AND location.latitude < 43.3296746019 AND location.longitude > -71.9429824338 AND location.longitude < -70.9535775662) ORDER BY distance ASC LIMIT 0, 10 in /includes/database.mysqli.inc on line 151.
?>
Any ideas?
#1
I've got a very similar scenario generation a similar error. I've got an exposed Location:Proximity filter for a list of nodes displaying lattitude and longitude and I get this error:
user warning: Column 'latitude' in field list is ambiguous query: SELECT node.nid, (((IFNULL(ACOS(0.74303117096305*COS(RADIANS(latitude))*(0.040665776061976*COS(RADIANS(longitude)) + -0.99917280520302*SIN(RADIANS(longitude))) + 0.66925681093081*SIN(RADIANS(latitude))), 0.00000)*6368532.0516327)) / 1609.347) AS distance, location.latitude AS location_latitude, location.longitude AS location_longitude, node.title AS node_title, node.changed AS node_changed, node.type AS gmap_node_type FROM node node INNER JOIN usernode usernode ON node.nid = usernode.nid LEFT JOIN location user_location ON usernode.uid = user_location.eid LEFT JOIN location location ON node.vid = location.eid WHERE (node.type IN ('dealer')) AND (user_location.longitude IS NOT NULL) AND (user_location.latitude > 41.937336930123 AND user_location.latitude < 42.082125069877 AND user_location.longitude > -87.766810751674 AND user_location.longitude < -87.571949248326) ORDER BY distance ASC in .../includes/database.mysql.inc on line 172.#2
The location views issue queue seems to be abandoned, so I'm moving this issue over the location (API, module) issue queue since the location module to be the mother ship for the location views module.