Error: 1064 content stats map module

faruk
faruk
Offline
0
Hi, whenever I put map mudule on current profile/group/album I get directed to:

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 st.country != "" AND st.component = "com_community" AND st.date_event BETWE' at line 1 SQL=SELECT COUNT(st.id) AS howmuch, st.country, st.state, st.city, st.date_event FROM XXX_content_statistics as st WHERE st.type = 1 AND st.reference_id = AND st.country != "" AND st.component = "com_community" AND st.date_event BETWEEN SUBDATE(CURDATE(), 7) AND NOW() GROUP BY st.country ORDER BY howmuch

Please advise
Responses (1)
  • Accepted Answer

    Monday, February 02 2015, 12:10 PM - #Permalink
    0
    hello,

    what is your Order ID on our website? you don't appear in our system as a customer.
    The reply is currently minimized Show
Your Reply