Lezidefol Posted June 27, 2016 Share Posted June 27, 2016 (edited) 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.lastnameat 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, Edited June 27, 2016 by Lezidefol (see edit history) Link to comment Share on other sites More sharing options...
Lezidefol Posted June 27, 2016 Author Share Posted June 27, 2016 Non, J'ai tenté de désinstaller puis réinstaller mais aucune mise à jour à ma connaissance. Avez vous une idée ? Il s'agit d'une erreur simple de syntaxe sql mais je préfère éviter de changer le code au risque de provoquer d'autres erreurs. Cordialement, Link to comment Share on other sites More sharing options...
doekia Posted June 27, 2016 Share Posted June 27, 2016 AND c.ip_address NOT IN (1514318356,1511902264,1458999010,) Tu as laissé trainé des informations erronées dans tes ip de maintenance il traine une virgule en trop 1 Link to comment Share on other sites More sharing options...
Lezidefol Posted June 27, 2016 Author Share Posted June 27, 2016 Merci, Pour le coup, j'avais même pas fait attention. A charge de revanche si un jour je peux vous aider à mon tour. Merci, A bientot 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