I was very happy, when I found this modul, but after installation (6.x-1.x-dev) is showing user warning:
*******
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 'DISTINCT(t.tid), COUNT(tn.nid) as nodes FROM term_data t LEFT JOIN term_node tn ' at line 1 query: SELECT t.name, t.description, DISTINCT(t.tid), COUNT(tn.nid) as nodes FROM term_data t LEFT JOIN term_node tn USING(tid) LEFT JOIN image_gallery_access iga ON t.tid = iga.tid LEFT JOIN acl acl_iga ON acl_iga.name = 't.tid' AND acl_iga.module = 'image_gallery_access' LEFT JOIN acl_user aclu_iga ON aclu_iga.acl_id = acl_iga.acl_id AND aclu_iga.uid = 4 WHERE ((iga.grant_view >= 1 AND iga.rid IN (2, 3)) OR iga.tid IS NULL OR aclu_iga.uid = 4) AND ( t.vid=4 )GROUP BY t.tid, t.name, t.description ORDER BY LENGTH(t.name) DESC in /mnt/data/accounts/p/petrios/data/www/modules/glossary/glossary.module on line 1007.
****
Could somebody explain me this message? What is wrong Thanks a lot !!!
Comments
Comment #1
petrios commentedsorry, forget it, there was conflict with glossary modul
Comment #2
salvisglossary.module should probably rearrange the query to be
SELECT t.tid, t.name, t.description
(start with t.tid).