When I try to do a proximity search using the 98660 zip code and a circular range of 3000 miles, I return 0 results despite having several users with locations in that range. If I choose a smaller range, say 100 miles, they all appear in the result set.

Looking at the SQL query generated with the larger range, I noticed that the WHERE clause has some criteria that can't possibly be met, specifically regarding location.longitude. With this particular query, for instance, it's looking for:

location.longitude > 157.646527826 AND location.longitude < -43.0267078257

The location.latitude range is fine (location.latitude > 2.20655070794 AND location.latitude < 89.0979592921), but something's clearly up with the longitude calculation.

Comments

yesct’s picture

Status: Active » Postponed (maintainer needs more info)

might be related to #606342-85: Views Argument Handler for Proximity and/or #821628: earth_longitude_range() in earth.inc uses invalid values with asin()

Please check, this might be fixed in the latest release. Post back if there is still a problem and set the status back to active.

ankur’s picture

Status: Postponed (maintainer needs more info) » Closed (cannot reproduce)

Closing due to no follow up reports for reproducing this bug.