DB error with empty cart

[LukeLuke]

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_pushoncart
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. }

• 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]

[polosat]

It seems the problem is caused by "PushOnCart" module. Try to contact its developers, I believe they'll fix this little issue:)

[LukeLuke]

Thank you, I deactivated it, but it is strange, because it neever caused any problem.