Marco_n Posted January 21, 2016 Share Posted January 21, 2016 sono sulla demo online, entro nel pannello di controllo, clicco sul link dei prodotti terminati, clicco nella barra di ricerca, la prima "LISTA DEI PRODOTTI CON ATTRIBUTI E SENZA QUANTITÀ DISPONIBILE ALLA VENDITA" , poi seleziono "stato = si " e premo cerca. Unknown column 'sa.active' in 'where clause' SELECT SQL_CALC_FOUND_ROWS b.*, a.* FROM `ps_product` a LEFT JOIN `ps_product_lang` b ON (b.`id_product` = a.`id_product` AND b.`id_lang` = 4 AND b.`id_shop` = a.id_shop_default) INNER JOIN ps_product_shop product_shop ON (product_shop.id_product = a.id_product AND product_shop.id_shop = a.id_shop_default) WHERE 1 AND EXISTS ( SELECT 1 FROM `ps_product` p LEFT JOIN ps_stock_available stock ON (stock.id_product = p.id_product AND stock.id_shop = 1 AND stock.id_shop_group = 0 ) WHERE a.id_product = p.id_product AND EXISTS ( SELECT 1 FROM `ps_product_attribute` WHERE `ps_product_attribute`.id_product = p.id_product ) AND IFNULL(stock.quantity, 0) <= 0 ) AND sa.`active` = 1 ORDER BY a.`id_product` DESC LIMIT 0, 50 at line 791 in file classes/db/Db.php 786. if ($webservice_call && $errno) { 787. $dbg = debug_backtrace(); 788. WebserviceRequest::getInstance()->setError(500, '[SQL Error] '.$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 3199 - classes/controller/AdminController.php] - [3 Arguments] AdminControllerCore->getList - [line 340 - controllers/admin/AdminTrackingController.php] - [6 Arguments] AdminTrackingControllerCore->getList - [line 251 - controllers/admin/AdminTrackingController.php] - [1 Arguments] AdminTrackingControllerCore->renderList - [line 166 - controllers/admin/AdminTrackingController.php] AdminTrackingControllerCore->getCustomListProductsAttributesNoStock - [line - ] call_user_func - [line 76 - controllers/admin/AdminTrackingController.php] - [1 Arguments] 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