alama Posted February 18, 2019 Share Posted February 18, 2019 (edited) Bonjour, Après avoir mis à jour un prestashop 1.6.0.14 vers la version 1.7.5.0, tout fonctionne bien sauf deux modules statistiques. Le site est en mode Catalogue et les deux modules concernés sont les suivants (ils ont été installés fraîchement après la mise à jour) : 1- Le module Visites et visiteurs n'affiche pas de graphique (pas d'erreur qui remonte) 2- Le module visiteur en ligne donne cette erreur SQL : [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 ') 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('2019-02-18 09:14:00', cp.`time_start`)) < 900 AND c.ip_address NOT IN (1554629422,1562302468,) GROUP BY u.id_customer ORDER BY u.firstname, u.lastname at line 769 in file classes/db/Db.php 764. if ($webservice_call && $errno) { 765. $dbg = debug_backtrace(); 766. WebserviceRequest::getInstance()->setError(500, '[SQL Error] ' . $this->getMsgError() . '. From ' . (isset($dbg[3]['class']) ? $dbg[3]['class'] : '') . '->' . $dbg[3]['function'] . '() Query was : ' . $sql, 97); 767. } elseif (_PS_DEBUG_SQL_ && $errno && !defined('PS_INSTALLATION_IN_PROGRESS')) { 768. if ($sql) { 769. throw new PrestaShopDatabaseException($this->getMsgError() . '<br /><br /><pre>' . $sql . '</pre>'); 770. } 771. 772. throw new PrestaShopDatabaseException($this->getMsgError()); 773. } 774. } Quelqu'un a déjà vu cela ? Il y a t'il un correctif connu ? Cordialement, AM Edited February 18, 2019 by alama (see edit history) Link to comment Share on other sites More sharing options...
doekia Posted February 18, 2019 Share Posted February 18, 2019 (edited) Supprime la value de l'enregistrement PS_MAINTENANCE_IP dans ta table configuration Ou va dans l'onglet maintenance et supprime les IP Edited February 18, 2019 by doekia (see edit history) Link to comment Share on other sites More sharing options...
alama Posted February 18, 2019 Author Share Posted February 18, 2019 Merci, c'était bien cela. Bonne journée, AM 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