HS Taxonomy Views ads option to every exposed filter. It's useless, because the blank line is serve as wildcart. Moreover, when you choose , it brakes the view with SQL error:
user warning: Unknown column 'Any' in 'on clause' query: SELECT COUNT(*) FROM (SELECT node.nid AS nid FROM node node INNER JOIN term_node term_node_value_0 ON node.vid = term_node_value_0.vid AND term_node_value_0.tid = Any LEFT JOIN content_type_wine_label node_data_field_wa_rating ON node.vid = node_data_field_wa_rating.vid WHERE (node.status <> 0) AND (node.type in ('wine_label')) AND (term_node_value_0.tid = 0) ) count_alias in Z:\home\eba\www\modules\views\includes\view.inc on line 729.
When you remove it, everything lives fine.
| Comment | File | Size | Author |
|---|---|---|---|
| hs_taxonomy_patch.patch | 630 bytes | neochief |
Comments
Comment #1
wim leersIt's not useless, because the blank line is not present when the "Force deepest level" setting is enabled. The problem you're describing is fixed in #555084: Apply searching for "Any" results in SQL error when Save term lineage is enabled :)
Comment #2
neochief commentedThanks!