Hi.

When I put HS on view exposed filter everything works fine for admin, but for anonymous user I am getting tons of warring errors like this:

user warning: Not unique table/alias: 'na' query: SELECT COUNT(*) FROM (SELECT DISTINCT node.nid AS nid, node.type AS node_type, node.vid AS node_vid, node.title AS node_title, uc_products.sell_price AS uc_products_sell_price FROM node node INNER JOIN term_node term_node ON node.vid = term_node.vid LEFT JOIN uc_products uc_products ON node.vid = uc_products.vid INNER JOIN node_access na ON na.nid = node.nid INNER JOIN node_access na ON na.nid = node.nid WHERE (na.grant_view >= 1 AND ((na.gid = 0 AND na.realm = 'all') OR (na.gid = 0 AND na.realm =
'nodeaccess_userreference') OR (na.gid = 0 AND na.realm =
'nodeaccess_userreference_author') OR (na.gid = 1 AND na.realm =
'nodeaccess_userreference_all') OR (na.gid = 0 AND na.realm =
'content_access_author') OR (na.gid = 1 AND na.realm =
'content_access_rid') OR (na.gid = 1174 AND na.realm =
'nodeaccess_nodereference_view') OR (na.gid = 1174 AND na.realm =
'nodeaccess_nodereference_view') OR (na.gid = 1174 AND na.realm =
'nodeaccess_nodereference_view') OR (na.gid = 3872 AND na.realm =
'nodeaccess_nodereference_view') OR (na.gid = 5801 AND na.realm =
'nodeaccess_nodereference_view') OR (na.gid = 1174 AND na.realm =
'nodeaccess_nodereference_view') OR (na.gid = 1174 AND na.realm =
... and so on...
...

hierarchical_select/modules/hs_taxonomy_views.module on line 571.

Line 571 in hs_taxonomy_views.module is basicaly
// Execute the count query.
$count[$current_view->name][$item] = db_result(db_query($count_query, $args));

Does anyone has any idea how to solve this issue?
Any help will be very appreciate.

Comments

blroot’s picture

Same problem here

Wim Leers’s picture

Category: bug » support
Status: Active » Postponed (maintainer needs more info)

Can you reproduce this without Hierarchical Select?