Jump to content

PrestaShopDatabaseException


Matvej17

Recommended Posts

Hi guys, i am developing first time presta eshop in my local enviroment and i hit on a problem. A try change theme, switch on custom and back on my theme and then on products listing template i see this error.

 

[PrestaShopDatabaseException]
You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ')' at line 5<br /><br /><pre>SELECT o.id_order FROM ps_orders o LEFT JOIN ps_order_detail od ON (od.id_order = o.id_order) WHERE o.valid = 1 AND od.product_id IN ()</pre>
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.     }
DbCore->displayError - [line 385 - classes/db/Db.php] - [1 Arguments]
DbCore->query - [line 613 - classes/db/Db.php] - [1 Arguments]
DbCore->executeS - [line 251 - modules/ps_crossselling/ps_crossselling.php] - [1 Arguments]
Ps_Crossselling->getOrderProducts - [line 210 - modules/ps_crossselling/ps_crossselling.php] - [1 Arguments]
Ps_Crossselling->getWidgetVariables - [line 231 - modules/ps_crossselling/ps_crossselling.php] - [2 Arguments]

 

I try search solution, but I was not successful. Can u guys please help me ? 

 

427707626_NewProject.thumb.jpg.09c8f9962bd74f3ccb1166012054f81b.jpg

Link to comment
Share on other sites

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 account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...