Hey germinal, im gettiing this error when i attempt to set 2.1 Content Statistics (RANKING) module as well as the other modules on a k2/cb item or category list...using the selector all = no filter...shows content but when i set the module to its criteria and and the selector to current then i get the error below. any idea what i may need to look at...thanks


1064 - 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 s.confirmed = 1 AND s.approved = 1 GROUP BY s.id ORDER BY howmuch DESC L' at line 1 SQL=SELECT s.*, COUNT(st.id) AS howmuch, u.username as item_name, CONCAT("index.php?option=com_comprofiler&task=userprofile&user=", s.id) as item_link FROM #__content_statistics as st LEFT JOIN #__comprofiler AS s ON s.id = st.reference_id LEFT JOIN #__users AS u ON u.id = s.user_id LEFT JOIN #__user_usergroup_map AS ug ON ug.user_id = u.id WHERE st.type = 1 AND st.component = "com_comprofiler" AND st.date_event BETWEEN "2016-08-01 00:00:00" AND NOW() AND ug.group_id = AND s.confirmed = 1 AND s.approved = 1 GROUP BY s.id ORDER BY howmuch DESC LIMIT 5