ZM_Model_Database (Zend_Db_Statement_Exception)
> Exception: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'bpbm.ID_SELECTION' in 'field list'
> Query: SELECT
m.ID_MARQUE as marque_id,
m.URL_REWRITE as marque_url_img,
COALESCE(m.NOM,mt.TITLE , gt.TITLE) AS title,
mt.DESCRIPTION_BLOC AS description,
if(m.URL_IMG,m.URL_IMG,'') AS img,
bpbm.LIST_IDS_PRODUCT as list_ids,
bpbm.BANNER_TYPE as banner_type,
bpbm.GROUP_ID as group_id,
bpbm.POSITION as position,
bpbm.ID_SELECTION AS selection_id
FROM banner_product_bloc_manage AS bpbm
LEFT JOIN gammificator_trad AS gt
ON gt.ID_GAMME = bpbm.ID_GAMME
AND gt.ID_LANGUE = 1
LEFT JOIN marque AS m
ON m.ID_MARQUE = bpbm.ID_MARQUE
JOIN marque_trad AS mt
ON mt.ID_MARQUE = bpbm.ID_MARQUE
AND mt.ID_LANGUE = 1
WHERE bpbm.ID_CATEGORIE = 3
AND FIND_IN_SET(1, bpbm.WEBSITES_ID)
AND NOW() BETWEEN DATE_START AND DATE_END;
> Backtrace:
#0 /var/www/zoomalia.com/htdocs/staging/releases/20261116110340/library/ZM/Model/Database.php(187): ZM_Model_Database->exception_log()
#1 /var/www/zoomalia.com/htdocs/staging/releases/20261116110340/library/ZE/BannerProduct.php(109): ZM_Model_Database->sqlRows()
#2 /var/www/zoomalia.com/htdocs/staging/releases/20261116110340/library/ZA/BannerProduct.php(18): ZE_BannerProduct->getDataBannerForCategorie()
#3 /var/www/zoomalia.com/htdocs/staging/releases/20261116110340/library/ZA/Categories/Datas.php(123): ZA_BannerProduct::getBlockBannerProduct()
#4 /var/www/zoomalia.com/htdocs/staging/releases/20261116110340/library/ZA/Indexed/CategoryData.php(56): ZA_Categories_Datas->__construct()
#5 /var/www/zoomalia.com/htdocs/staging/releases/20261116110340/application/public/modules/pages/controllers/CategoriesController.php(301): Library\ZA\Indexed\CategoryData::sqlFetch()
#6 /var/www/zoomalia.com/htdocs/staging/releases/20261116110340/application/public/modules/pages/controllers/CategoriesController.php(200): Pages_CategoriesController->getEsObjectAndGenerate()
#7 /var/www/zoomalia.com/htdocs/staging/releases/20261116110340/library/Zend/Controller/Action.php(514): Pages_CategoriesController->categoryAction()
#8 /var/www/zoomalia.com/htdocs/staging/releases/20261116110340/library/Zend/Controller/Dispatcher/Standard.php(295): Zend_Controller_Action->dispatch()
#9 /var/www/zoomalia.com/htdocs/staging/releases/20261116110340/library/Zend/Controller/Front.php(954): Zend_Controller_Dispatcher_Standard->dispatch()
#10 /var/www/zoomalia.com/htdocs/staging/releases/20261116110340/www/index.php(315): Zend_Controller_Front->dispatch()