-1
Hello,
we have a 1064 in the backend (system > control panel)
How can we fix it ??
Regard.
we have a 1064 in the backend (system > control panel)
How can we fix it ??
Regard.
An error has occurred.
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 'GROUP BY st.country ORDER BY howmuch' at line 1 SQL=GROUP BY st.country ORDER BY howmuch
Responses (7)
-
Accepted Answer
-
Accepted Answer
0Hello,
we use K2 and logman.
I just disabled these admin modules, but still have error. See my screenshot.
Regard.Attachments:
-
-
Accepted Answer
0now it is different...
we made some test but impossible to see a module in backend (cpanel position)
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.component = "com_k2" AND st.date_event BETWEEN SUBDATE(CURDATE(), 30) AN' at line 1 SQL=SELECT COUNT(st.id) AS howmuch, st.date_event FROM micmag_content_statistics as st LEFT JOIN micmag_k2_items as s ON s.id = st.reference_id WHERE st.type = 1 AND st.reference_id = AND st.component = "com_k2" AND st.date_event BETWEEN SUBDATE(CURDATE(), 30) AND NOW() AND s.published = 1 GROUP BY DAY(date_event), MONTH(date_event), YEAR(date_event) ORDER BY date_event
-
Germinal Campsmore than a month agocan you send me access to your website so I can take a look?
-
-
Accepted Answer
Your Reply
Please login to post a reply
You will need to be logged in to be able to post a reply. Login using the form on the right or register an account if you are new here.
Register Here »