vicgompal Posted September 11, 2013 Share Posted September 11, 2013 Unknown column 'id_shop' in 'where clause' SELECT * FROM ps_layered_category WHERE id_category = 16 AND id_shop = 1 GROUP BY `type`, id_value ORDER BY position ASC at line 607 in file classes/db/Db.php 601. WebserviceRequest::getInstance()->setError(500, '[SQL Error] '.$this->getMsgError().'. From '.(isset($dbg[3]['class']) ? $dbg[3]['class'] : '').'->'.$dbg[3]['function'].'() Query was : '.$sql, 97);602. }603. else if (_PS_DEBUG_SQL_ && $errno && !defined('PS_INSTALLATION_IN_PROGRESS'))604. {605. if ($sql)606. throw new PrestaShopDatabaseException($this->getMsgError().'<br /><br /><pre>'.$sql.'</pre>');607. throw new PrestaShopDatabaseException($this->getMsgError());608. }609. }610. 611. /** DbCore->displayError - [line 307 - classes/db/Db.php] - [1 Arguments] DbCore->query - [line 482 - classes/db/Db.php] - [1 Arguments] DbCore->executeS - [line 2590 - modules/blocklayered/blocklayered.php] - [1 Arguments] BlockLayered->getFilterBlock - [line 1207 - modules/blocklayered/blocklayered.php] - [1 Arguments] BlockLayered->hookHeader - [line 423 - classes/Hook.php] - [1 Arguments] HookCore::exec - [line 425 - classes/controller/FrontController.php] - [1 Arguments] FrontControllerCore->initContent - [line 98 - controllers/front/CategoryController.php] - [0 Argument] CategoryControllerCore->initContent - [line 167 - classes/controller/Controller.php] - [0 Argument] ControllerCore->run - [line 349 - classes/Dispatcher.php] - [0 Argument] DispatcherCore->dispatch - [line 28 - index.php] - [0 Argument] Link to comment Share on other sites More sharing options...
Pronux Posted March 28, 2014 Share Posted March 28, 2014 same here, using PS 1.5.4.1, did you find a solution? Link to comment Share on other sites More sharing options...
Rosiel Posted August 14, 2014 Share Posted August 14, 2014 Idem, Avez-vous trouver une solution ? Merci Link to comment Share on other sites More sharing options...
Recommended Posts