LukeLuke Posted June 2, 2016 Share Posted June 2, 2016 I've some troubles with my shop. When I've a product in cart, it works fine, but when the cart is empty and I click on cart. It gives me a page with this error: How can I correct it? [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 ') AND p.multiple_codes_allowed = 1 AND p.id_shop = 1 AND (r.amount1 <=' at line 3 SELECT DISTINCT p.id_product FROM `ps_pushoncartproducts` p, `ps_pushoncart_ranges` r WHERE p.archive = 0 AND p.active = 1 AND p.id_product NOT IN ( ) AND p.multiple_codes_allowed = 1 AND p.id_shop = 1 AND (r.amount1 <= 0 OR r.amount1 IS NULL) AND (r.amount2 > 0 OR r.amount2 IS NULL) AND r.id_pushoncart = p.id_pushoncartat 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. } DbCore->displayError - [line 425 - classes/db/Db.php] - [1 Arguments] DbCore->query - [line 643 - classes/db/Db.php] - [1 Arguments] DbCore->executeS - [line 864 - modules/pushoncart/pushoncart.php] - [1 Arguments] PushOnCart->getRandomPromo - [line 1103 - modules/pushoncart/pushoncart.php] - [2 Arguments] PushOnCart->getTopProduct - [line 1592 - modules/pushoncart/pushoncart.php] - [2 Arguments] PushOnCart->hookShoppingCart - [line 587 - classes/Hook.php] - [1 Arguments] HookCore::coreCallHook - [line 544 - classes/Hook.php] - [3 Arguments] HookCore::exec - [line 371 - controllers/front/ParentOrderController.php] - [2 Arguments] ParentOrderControllerCore->_assignSummaryInformations - [line 366 - controllers/front/OrderOpcController.php] OrderOpcControllerCore->initContent - [line 155 - override/controllers/front/OrderOpcController.php] OrderOpcController->initContent - [line 189 - classes/controller/Controller.php] ControllerCore->run - [line 367 - classes/Dispatcher.php] DispatcherCore->dispatch - [line 28 - index.php] Link to comment Share on other sites More sharing options...
polosat Posted June 2, 2016 Share Posted June 2, 2016 It seems the problem is caused by "PushOnCart" module. Try to contact its developers, I believe they'll fix this little issue:) Link to comment Share on other sites More sharing options...
LukeLuke Posted June 3, 2016 Author Share Posted June 3, 2016 Thank you, I deactivated it, but it is strange, because it neever caused any problem. 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