Jump to content

Bug Sulla Demo


Marco_n

Recommended Posts

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

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