eagleman Posted June 16, 2018 Share Posted June 16, 2018 Bonjour, Can you please help me to resolve this issues [PrestaShopDatabaseException] Table 'admin_nostop.ps_seosaproductlabels_excluded' doesn't exist SELECT `id_excluded_product` FROM `ps_seosaproductlabels_excluded` WHERE `id_product_label` = 1 AND `id_excluded_product` = 669 LIMIT 1 at line 746 in file classes/db/Db.php 741. if ($webservice_call && $errno) { 742. $dbg = debug_backtrace(); 743. WebserviceRequest::getInstance()->setError(500, '[SQL Error] '.$this->getMsgError().'. From '.(isset($dbg[3]['class']) ? $dbg[3]['class'] : '').'->'.$dbg[3]['function'].'() Query was : '.$sql, 97); 744. } elseif (_PS_DEBUG_SQL_ && $errno && !defined('PS_INSTALLATION_IN_PROGRESS')) { 745. if ($sql) { 746. throw new PrestaShopDatabaseException($this->getMsgError().'<br /><br /><pre>'.$sql.'</pre>'); 747. } 748. 749. throw new PrestaShopDatabaseException($this->getMsgError()); 750. } 751. } DbCore->displayError - [line 378 - classes/db/Db.php] - [1 Arguments] DbCore->query - [line 645 - classes/db/Db.php] - [1 Arguments] DbCore->getRow - [line 678 - classes/db/Db.php] - [2 Arguments] DbCore->getValue - [line 160 - modules/seosaproductlabels/classes/ProductLabel.php] - [1 Arguments] ProductLabel::checkExcludedProductForLabel - [line 156 - modules/seosaproductlabels/seosaproductlabels.php] - [2 Arguments] SeosaProductLabels->prepareHook - [line 179 - modules/seosaproductlabels/seosaproductlabels.php] - [1 Arguments] SeosaProductLabels->hookDisplayProductListReviews - [line 924 - classes/Hook.php] - [1 Arguments] HookCore::coreCallHook - [line 328 - classes/Hook.php] - [3 Arguments] HookCore::callHookOn - [line 860 - classes/Hook.php] - [3 Arguments] Link to comment Share on other sites More sharing options...
fxtc Posted September 16, 2018 Share Posted September 16, 2018 I have similar error : [PrestaShopDatabaseException] Unknown column 'id_shop' in 'where clause' SELECT * FROM `ps_info_lang` WHERE `id_lang` = 2 AND `id_shop` = 1 LIMIT 1 at line 746 in file classes/db/Db.php 741. if ($webservice_call && $errno) { 742. $dbg = debug_backtrace(); 743. WebserviceRequest::getInstance()->setError(500, '[SQL Error] '.$this->getMsgError().'. From '.(isset($dbg[3]['class']) ? $dbg[3]['class'] : '').'->'.$dbg[3]['function'].'() Query was : '.$sql, 97); 744. } elseif (_PS_DEBUG_SQL_ && $errno && !defined('PS_INSTALLATION_IN_PROGRESS')) { 745. if ($sql) { 746. throw new PrestaShopDatabaseException($this->getMsgError().'<br /><br /><pre>'.$sql.'</pre>'); 747. } 748. 749. throw new PrestaShopDatabaseException($this->getMsgError()); 750. } 751. } DbCore->displayError - [line 378 - classes/db/Db.php] - [1 Arguments] DbCore->query - [line 645 - classes/db/Db.php] - [1 Arguments] DbCore->getRow - [line 290 - modules/ps_customtext/ps_customtext.php] - [1 Arguments] Ps_Customtext->getWidgetVariables - [line 279 - modules/ps_customtext/ps_customtext.php] - [2 Arguments] Ps_Customtext->renderWidget - [line 929 - classes/Hook.php] - [2 Arguments] HookCore::coreRenderWidget - [line 881 - classes/Hook.php] - [3 Arguments] HookCore::exec - [line 39 - controllers/front/IndexController.php] - [1 Arguments] IndexControllerCore->initContent - [line 255 - classes/controller/Controller.php] ControllerCore->run - [line 428 - classes/Dispatcher.php] DispatcherCore->dispatch - [line 28 - index.php] 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