Voyagerric Posted September 8, 2015 Share Posted September 8, 2015 He actualizado a la versión 1.6.1.0 de perstashop y ahora al intentar ver los visitantes en linea me da error siguiente [PrestaShopDatabaseException] 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 '1477545744,1595095929,1396398480,2958377644,3110267270) GROUP BY u.id_custo' at line 11 SELECT u.id_customer, u.firstname, u.lastname, pt.name as page FROM `ps_connections` c LEFT JOIN `ps_connections_page` cp ON c.id_connections = cp.id_connections LEFT JOIN `ps_page` p ON p.id_page = cp.id_page LEFT JOIN `ps_page_type` pt ON p.id_page_type = pt.id_page_type INNER JOIN `ps_guest` g ON c.id_guest = g.id_guest INNER JOIN `ps_customer` u ON u.id_customer = g.id_customer WHERE cp.`time_end` IS NULL AND c.id_shop IN (1) AND TIME_TO_SEC(TIMEDIFF('2015-09-08 17:36:00', cp.`time_start`)) < 900 AND c.ip_address NOT IN (1594980482,2958372384,2958372384,2958372384,1984425667,2958375073,2958298137,2958376184,2461605469,2958304769,1595272063,,1477545744,1595095929,1396398480,2958377644,3110267270) GROUP BY u.id_customer ORDER BY u.firstname, u.lastname alguien sabe como solucionarlo? gracias Link to comment Share on other sites More sharing options...
Boletus Posted November 15, 2016 Share Posted November 15, 2016 has podido solucionar este tema. A mi me pasa lo mismo Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now