There has been an error processing your request

SQLSTATE[42S22]: Column not found: 1054 Unknown column 'news_from_date' in 'field list', query was: SELECT IF(news_from_date <> "NULL", 
            IF(news_to_date <> "NULL",
            IF(news_from_date <= STR_TO_DATE("2024-03-28 23:59:59", "%Y-%m-%d %H:%i:%s"), 
            IF(news_to_date >= STR_TO_DATE("2024-03-28 00:00:00", "%Y-%m-%d %H:%i:%s"),
            "no","yes"), "yes"), "yes"), "yes") as on_sale, COUNT(*) as count from (SELECT `e`.*, `cat_index`.`position` AS `cat_index_position`, `price_index`.`price`, `price_index`.`tax_class_id` as tax_class, `price_index`.`final_price`, IF(price_index.tier_price IS NOT NULL, LEAST(price_index.min_price, price_index.tier_price), price_index.min_price) AS `minimal_price`, `price_index`.`min_price`, `price_index`.`max_price`, `price_index`.`tier_price` FROM `catalog_product_entity` AS `e`
 INNER JOIN `catalog_category_product_index` AS `cat_index` ON cat_index.product_id=e.entity_id AND cat_index.store_id=4 AND cat_index.visibility IN(2, 4) AND cat_index.category_id = '127'
 INNER JOIN `catalog_product_index_price` AS `price_index` ON price_index.entity_id = e.entity_id AND price_index.website_id = '1' AND price_index.customer_group_id = 0) AS q GROUP BY on_sale
Trace: #0 /usr/home/carolanfiestas/www/lib/Varien/Db/Statement/Pdo/Mysql.php(110): Zend_Db_Statement_Pdo->_execute(Array) #1 /usr/home/carolanfiestas/www/app/code/core/Zend/Db/Statement.php(291): Varien_Db_Statement_Pdo_Mysql->_execute(Array) #2 /usr/home/carolanfiestas/www/lib/Zend/Db/Adapter/Abstract.php(480): Zend_Db_Statement->execute(Array) #3 /usr/home/carolanfiestas/www/lib/Zend/Db/Adapter/Pdo/Abstract.php(238): Zend_Db_Adapter_Abstract->query('SELECT IF(news_...', Array) #4 /usr/home/carolanfiestas/www/lib/Varien/Db/Adapter/Pdo/Mysql.php(504): Zend_Db_Adapter_Pdo_Abstract->query('SELECT IF(news_...', Array) #5 /usr/home/carolanfiestas/www/lib/Zend/Db/Adapter/Abstract.php(811): Varien_Db_Adapter_Pdo_Mysql->query('SELECT IF(news_...', Array) #6 /usr/home/carolanfiestas/www/app/code/local/Singular/Carolan/Model/Catalog/Layer/Filter/Abstract.php(164): Zend_Db_Adapter_Abstract->fetchPairs('SELECT IF(news_...') #7 /usr/home/carolanfiestas/www/app/code/local/Singular/Carolan/Model/Catalog/Layer/Filter/Abstract.php(89): Singular_Carolan_Model_Catalog_Layer_Filter_Abstract->_getCountNew() #8 /usr/home/carolanfiestas/www/app/code/core/Mage/Catalog/Model/Layer/Filter/Abstract.php(151): Singular_Carolan_Model_Catalog_Layer_Filter_Abstract->_getItemsData() #9 /usr/home/carolanfiestas/www/app/code/core/Mage/Catalog/Model/Layer/Filter/Abstract.php(120): Mage_Catalog_Model_Layer_Filter_Abstract->_initItems() #10 /usr/home/carolanfiestas/www/app/code/core/Mage/Catalog/Model/Layer/Filter/Abstract.php(109): Mage_Catalog_Model_Layer_Filter_Abstract->getItems() #11 /usr/home/carolanfiestas/www/app/code/core/Mage/Catalog/Block/Layer/Filter/Abstract.php(132): Mage_Catalog_Model_Layer_Filter_Abstract->getItemsCount() #12 /usr/home/carolanfiestas/www/app/code/core/Mage/Catalog/Block/Layer/View.php(218): Mage_Catalog_Block_Layer_Filter_Abstract->getItemsCount() #13 /usr/home/carolanfiestas/www/app/code/core/Mage/Catalog/Block/Layer/View.php(233): Mage_Catalog_Block_Layer_View->canShowOptions() #14 /usr/home/carolanfiestas/www/app/design/frontend/default/ma_metrofas/template/catalog/layer/view.phtml(34): Mage_Catalog_Block_Layer_View->canShowBlock() #15 /usr/home/carolanfiestas/www/app/code/core/Mage/Core/Block/Template.php(241): include('/usr/home/carol...') #16 /usr/home/carolanfiestas/www/app/code/core/Mage/Core/Block/Template.php(272): Mage_Core_Block_Template->fetchView('frontend/defaul...') #17 /usr/home/carolanfiestas/www/app/code/core/Mage/Core/Block/Template.php(286): Mage_Core_Block_Template->renderView() #18 /usr/home/carolanfiestas/www/app/code/core/Mage/Core/Block/Abstract.php(923): Mage_Core_Block_Template->_toHtml() #19 /usr/home/carolanfiestas/www/app/code/core/Mage/Core/Block/Text/List.php(43): Mage_Core_Block_Abstract->toHtml() #20 /usr/home/carolanfiestas/www/app/code/core/Mage/Core/Block/Abstract.php(923): Mage_Core_Block_Text_List->_toHtml() #21 /usr/home/carolanfiestas/www/app/code/core/Mage/Core/Block/Abstract.php(641): Mage_Core_Block_Abstract->toHtml() #22 /usr/home/carolanfiestas/www/app/code/core/Mage/Core/Block/Abstract.php(585): Mage_Core_Block_Abstract->_getChildHtml('left', true) #23 /usr/home/carolanfiestas/www/app/design/frontend/default/ma_metrofas/template/page/2columns-left.phtml(53): Mage_Core_Block_Abstract->getChildHtml('left') #24 /usr/home/carolanfiestas/www/app/code/core/Mage/Core/Block/Template.php(241): include('/usr/home/carol...') #25 /usr/home/carolanfiestas/www/app/code/core/Mage/Core/Block/Template.php(272): Mage_Core_Block_Template->fetchView('frontend/defaul...') #26 /usr/home/carolanfiestas/www/app/code/core/Mage/Core/Block/Template.php(286): Mage_Core_Block_Template->renderView() #27 /usr/home/carolanfiestas/www/app/code/core/Mage/Core/Block/Abstract.php(923): Mage_Core_Block_Template->_toHtml() #28 /usr/home/carolanfiestas/www/app/code/core/Mage/Core/Model/Layout.php(555): Mage_Core_Block_Abstract->toHtml() #29 /usr/home/carolanfiestas/www/app/code/core/Mage/Core/Controller/Varien/Action.php(390): Mage_Core_Model_Layout->getOutput() #30 /usr/home/carolanfiestas/www/app/code/core/Mage/Catalog/controllers/CategoryController.php(161): Mage_Core_Controller_Varien_Action->renderLayout() #31 /usr/home/carolanfiestas/www/app/code/core/Mage/Core/Controller/Varien/Action.php(418): Mage_Catalog_CategoryController->viewAction() #32 /usr/home/carolanfiestas/www/app/code/core/Mage/Core/Controller/Varien/Router/Standard.php(254): Mage_Core_Controller_Varien_Action->dispatch('view') #33 /usr/home/carolanfiestas/www/app/code/core/Mage/Core/Controller/Varien/Front.php(172): Mage_Core_Controller_Varien_Router_Standard->match(Object(Mage_Core_Controller_Request_Http)) #34 /usr/home/carolanfiestas/www/app/code/core/Mage/Core/Model/App.php(365): Mage_Core_Controller_Varien_Front->dispatch() #35 /usr/home/carolanfiestas/www/app/Mage.php(687): Mage_Core_Model_App->run(Array) #36 /usr/home/carolanfiestas/www/index.php(86): Mage::run('', 'store') #37 {main}

Error log record number: 689785764458