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
Voyagerric changed their profile photo