Bonjour à tous,
Merci à tout ceux qui prendront le temps de me lire et de me répondre.
Mon soucis : le tableau de bord n'affiche plus les visiteurs en ligne et dans le module statistiques quand je cherche à aller sur visiteurs en ligne, j'ai le message d'erreur suivant :
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 u.id_customer ORDER BY u.firstname, u.lastname' 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('2016-06-27 16:23:00', cp.`time_start`)) < 900 AND c.ip_address NOT IN (1514318356,1511902264,1458999010,) GROUP BY u.id_customer ORDER BY u.firstname, u.lastname at line 791 in file classes/db/Db.php
786. if ($webservice_call && $errno) { 787. $dbg = debug_backtrace(); 788. WebserviceRequest::getInstance()->setError(500, '
'.$this->getMsgError().'. From '.(isset($dbg[3]['class']) ? $dbg[3]['class'] : '').'->'.$dbg[3]['function'].'() Query was : '.$sql, 97); 789. } elseif (_PS_DEBUG_SQL_ && $errno && !defined('PS_INSTALLATION_IN_PROGRESS')) { 790. if ($sql) { 791. throw new PrestaShopDatabaseException($this->getMsgError().'<br /><br /><pre>'.$sql.'</pre>'); 792. } 793. 794. throw new PrestaShopDatabaseException($this->getMsgError()); 795. }796. } Une idée ? Merci à tous, Cordialement,