getting error

michael
michael
Offline
0
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
Responses (5)
  • Accepted Answer

    michael
    michael
    Offline
    Friday, August 26 2016, 03:22 AM - #Permalink
    0
    sorry...also the modules are showing no content when displayed on the profiles
    The reply is currently minimized Show
  • Accepted Answer

    michael
    michael
    Offline
    Friday, August 26 2016, 08:17 PM - #Permalink
    0
    Update..im finding that the settings
    comprofiler
    top viewed
    specific users
    specific id filter = usergroup #
    (is getting me 1064 error) similar to the initial setup issues i posted regarding current selector but for some reason setting it to all (no filters) is displaying content.
    The reply is currently minimized Show
  • Accepted Answer

    michael
    michael
    Offline
    Sunday, August 28 2016, 03:30 AM - #Permalink
    0
    Additional finding..
    as i mentioned the rankings mod displays ok when no custom or specific filters are on.. but now im noticing as well.that the mod will only display the hits just mentioned for profile views and logins but it will not display any data for list views..
    Looking forward to hearing from you and thanks
    The reply is currently minimized Show
  • Accepted Answer

    michael
    michael
    Offline
    Monday, August 29 2016, 05:10 PM - #Permalink
    0
    Im getting error on cb as well and they said its because cs is incorrectly joining my tables....i will await your response and tnx
    The reply is currently minimized Show
  • Accepted Answer

    michael
    michael
    Offline
    Tuesday, August 30 2016, 08:49 AM - #Permalink
    0
    Hey germinal..i sent some credentials and additional details via contact form to help move things along...thanks
    The reply is currently minimized Show
Your Reply