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.

CommentFileSizeAuthor
hs_taxonomy_patch.patch630 bytesneochief

Comments

wim leers’s picture

Status: Needs review » Closed (duplicate)

It'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 :)

neochief’s picture

Thanks!