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

nehal.padia - September 22, 2009 - 14:48
Project:Location Views
Component:Code
Category:bug report
Priority:critical
Assigned:Unassigned
Status:active
Issue tags:location, Location proximity view, views
Description

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
 
 

Drupal is a registered trademark of Dries Buytaert.