Closed (cannot reproduce)
Project:
Hierarchical Select
Version:
6.x-3.1
Component:
Code - Taxonomy Views
Priority:
Normal
Category:
Bug report
Assigned:
Unassigned
Reporter:
Created:
13 May 2010 at 04:27 UTC
Updated:
17 Jul 2013 at 04:24 UTC
Comments
Comment #1
wim leersThat's not very helpful. I'd need more details.
Also, please don't use the tags system like that.
Comment #2
charlysole commentedExactly the same problem here...
I have Taxonomy term filter exposed using HS. (Taxonomy Term modiffied default view)
If you try to use the options Display the node count or Require associated node my drupal returns
user warning: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') count_alias' at line 1 query: SELECT COUNT(*) FROM () count_alias in /usr/home/SITE.com/web/sites/all/modules/hierarchical_select/modules/hs_taxonomy_views.module on line 535.
Four times
Comment #3
Kook commentedOld question, but as I was able to replicate and fix this may help someone out.
Find the following in the /modules/hierachical_select/modules/hs_taxonomy_views.module file;
Replace with the following;
and then just below it (to make sure it doesn't return the error);
Replace with
Reasoning being I would prefer a slightly inaccurate count over a crash, just in case for some reason that $count_query string is empty, which is what caused the original issue.