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.

CommentFileSizeAuthor
View's SQL22.33 KBnehpad
Location: Distance / Proximity48.87 KBnehpad
Support from Acquia helps fund testing for Drupal Acquia logo

Comments

Anonymous’s picture

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...