PrestaShopDatabaseException

[bleur]

Hi

I found problem on my website and I am looking for help.

 

Unknown column 'a.low_stock_threshold' in 'field list'

SELECT SQL_CALC_FOUND_ROWS
								b.*, a.*
			, a.`reference`, sa.`active`, a.low_stock_threshold   AS `active`, shop.`name` AS `shopname`, a.`id_product` as `id`,
        image_shop.`id_image` AS `id_image`,
         cl.`name` AS `name_category`, sa.`price`, 0 AS `price_final`, 
        pd.`nb_downloadable`, sav.`quantity` AS `sav_quantity`, sa.`active`,sa.`available_for_order`,
        IF(sav.`quantity`<=0, 1, 0) AS `badge_danger`
			FROM `ps_product` a 
			LEFT JOIN `ps_product_lang` b ON (b.`id_product` = a.`id_product` AND b.`id_lang` = 1 AND b.`id_shop` = 1)
			
        LEFT JOIN `ps_stock_available` sav ON (sav.`id_product` = a.`id_product` 
            AND sav.`id_product_attribute` = 0
             AND sav.id_shop = 1  AND sav.id_shop_group = 0 )
        JOIN `ps_product_shop` sa ON (
        a.`id_product` = sa.`id_product` AND sa.id_shop = a.id_shop_default)
        LEFT JOIN `ps_category_lang` cl
         ON (sa.`id_category_default` = cl.`id_category` AND b.`id_lang` = cl.`id_lang` 
            AND cl.id_shop = a.id_shop_default)
        LEFT JOIN `ps_shop` shop ON (shop.id_shop = a.id_shop_default)
        LEFT JOIN `ps_image_shop` image_shop
         ON (image_shop.`id_product` = a.`id_product` AND image_shop.`cover` = 1 
            AND image_shop.id_shop = a.id_shop_default)
        LEFT JOIN `ps_image` i ON (i.`id_image` = image_shop.`id_image`) 
        
        LEFT JOIN `ps_product_download` pd ON (pd.`id_product` = a.`id_product`) LEFT JOIN `ps_product_supplier` ps ON (ps.`id_product` = a.`id_product`) 
			 WHERE 1  
			GROUP BY sa.`id_product` 
			 ORDER BY a.`id_product` ASC  LIMIT 0, 50

at line 791 in file classes/db/Db.php

791.   throw new PrestaShopDatabaseException($this->getMsgError().'<br /><br /><pre>'.$sql.'</pre>');

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

 

Anyone can help me?

 

Thanks

index.php.htm