Support for Drupal 7 is ending on 5 January 2025—it’s time to migrate to Drupal 10! Learn about the many benefits of Drupal 10 and find migration tools in our resource center.
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.
Comment | File | Size | Author |
---|---|---|---|
View's SQL | 22.33 KB | nehpad | |
Location: Distance / Proximity | 48.87 KB | nehpad |
Comments
Comment #1
Anonymous (not verified) CreditAttribution: Anonymous commentedSame 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...