using V2.0 RC5 r1302,I got an SQL error in front-end only when i try to view a sub category which contain also sub categories:
Code:
SQL QUERY ERROR:
SELECT DISTINCT itemid FROM #__flexicontent_cats_item_relations AS rel LEFT JOIN #__content AS i ON rel.itemid = i.id LEFT JOIN #__flexicontent_items_ext AS ie ON i.id = ie.item_id LEFT JOIN #__categories AS cc ON cc.id = rel.catid WHERE cc.published = 1 AND ( i.state IN (1, -5, 0, -3, -4) OR i.created_by = 42 OR ( i.modified_by = 42 AND i.modified_by != 0 ) ) AND rel.catid IN () AND i.access IN (1,1,2,3,4) AND cc.access IN (1,1,2,3,4)
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 ') AND i.access IN (1,1,2,3,4) AND cc.access IN (1,1,2,3,4)' at line 1 SQL=SELECT DISTINCT itemid FROM jom_flexicontent_cats_item_relations AS rel LEFT JOIN jom_content AS i ON rel.itemid = i.id LEFT JOIN jom_flexicontent_items_ext AS ie ON i.id = ie.item_id LEFT JOIN jom_categories AS cc ON cc.id = rel.catid WHERE cc.published = 1 AND ( i.state IN (1, -5, 0, -3, -4) OR i.created_by = 42 OR ( i.modified_by = 42 AND i.modified_by != 0 ) ) AND rel.catid IN () AND i.access IN (1,1,2,3,4) AND cc.access IN (1,1,2,3,4)
I got this error althougth the sub categories are well displayed.
