aquadiscount Posted April 1, 2015 Share Posted April 1, 2015 Bonjour, depuis hier je n'arrive plus à afficher les paniers abandonnés alors que tout marchait avant. Je suis en 1.6.0.9 Sur cette page donc : /ADMIN//index.php?controller=AdminCarts&token=xxxxxxxxxxxxxxxxxxxxxxxxx&action=filterOnlyAbandonedCarts Mauvaise requête SQLYou have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'id_order = 'Panier abandonné' ORDER BY a.`id_cart` DESC LIMIT 0,50' at line 15 Que faire ? D'où vient le souci ? Merci Link to comment Share on other sites More sharing options...
doekia Posted April 1, 2015 Share Posted April 1, 2015 Heu l'erreur n'est pas d'hier ... elle existe dans toutes les versions 1.6.0.8 à la version future ... Quand on vous dit que c'est testé - il faut le croire! Remplacer dans controllers/admin/AdminCartsController.php if (Tools::getValue('action') && Tools::getValue('action') == 'filterOnlyAbandonedCarts') $this->_having = 'id_order = \''.$this->l('Abandoned cart').'\''; par if (Tools::getValue('action') && Tools::getValue('action') == 'filterOnlyAbandonedCarts') $this->_having = 'o.id_order IS NULL '; 2 Link to comment Share on other sites More sharing options...
kehezen Posted June 25, 2015 Share Posted June 25, 2015 (edited) Merci pour l'info doekia, malheureusement de mon côté (1.6.0.9.), appliquer ce patch ne fait que changer la teneur du message : Mauvaise requête SQLYou have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'o.id_order IS NULL ORDER BY a.`id_cart` DESC LIMIT 0,50' at line 15Est-ce quelqu'un peut m'aider à résoudre ça ? Edited June 25, 2015 by kehezen (see edit history) Link to comment Share on other sites More sharing options...
kehezen Posted July 3, 2015 Share Posted July 3, 2015 je relance ma question, sait-on jamais... ? 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