Download & Extend

Proximity filter adds a 'and (0)' to the view sql even if unset

Project:Location Views
Component:Code
Category:bug report
Priority:critical
Assigned:Unassigned
Status:active
Issue tags:location, Location proximity view, views

Issue Summary

We are using location views and have used a "Location: Distance / Proximity" as one of the filters, see attached 1.jpg. Even though the value is not set of the zipcode, it adds a additional "and (0)" to the view's sql, see below & 2.jpg.

........
........
WHERE (node.type in ('listing_elite', 'listing_portfolio')) AND (node.status <> 0) AND (0)
ORDER BY node_title ASC

Some one please help.

AttachmentSize
Location: Distance / Proximity48.87 KB
View's SQL22.33 KB

Comments

#1

Same problem. Happens when setting Proximity filter to Zipcode/country. With all the power of location.module I'd like to build a dead simple store locator by proximity... No luck...