Exception Printing Error after Magento CE 1.9.2.0 Upgrade

[ilinked]

After Magento CE 1.9.0.1 to Magento CE 1.9.2.0 Upgrade I again started getting the error (There has been an error processing your request - Exception printing is disabled by default for security reasons.).  Backend now seems to be working but Frontend throws above error.

I Prevously fixed Exception Printing Error by making modification to ( /lib/Zend/Cache/Backend/File.php -- Line 99 - 'cache_dir' => 'tmp/', ) and created a tmp/ directory ) since then I have never seen any files stored in this tmp directory UNTIL TODAY.

TODAY I also noticed the original modified file (File.php) had been replaced by the upgrade so I modified it again . I still get the Exception printing is disabled Error.

Perhaps the current error is because files for 'cache_dir' are being looked for in multiple places after 1.9.2.0 Upgrade.





Following is a copy of ------> ERROR REPORT - 592209513033


There has been an error processing your request

SQLSTATE[42S22]: Column not found: 1054 Unknown column 'e.status' in 'where clause', query was: SELECT COUNT(DISTINCT e.entity_id) FROM `mdw_catalog_product_flat_1` AS `e`
INNER JOIN `mdw_report_compared_product_index` AS `idx_table` ON (idx_table.product_id=e.entity_id) AND (idx_table.visitor_id = '426993')
INNER JOIN `mdw_catalog_category_product_index` AS `cat_index` ON cat_index.product_id=e.entity_id AND cat_index.store_id=1 AND cat_index.category_id = '3'
LEFT JOIN `mdw_core_store` AS `store_index` ON store_index.store_id = idx_table.store_id
LEFT JOIN `mdw_core_store_group` AS `store_group_index` ON store_index.group_id = store_group_index.group_id
LEFT JOIN `mdw_catalog_category_product_index` AS `store_cat_index` ON store_cat_index.product_id = e.entity_id AND store_cat_index.store_id = idx_table.store_id AND store_cat_index.category_id=store_group_index.root_category_id WHERE (e.status = 1) AND (cat_index.visibility IN(3, 2, 4) OR store_cat_index.visibility IN(3, 2, 4))

Trace:
#0 /home/MyDomain/public_html/shop/lib/Varien/Db/Statement/Pdo/Mysql.php(110): Zend_Db_Statement_Pdo->_execute(Array)
#1 /home/MyDomain/public_html/shop/app/code/core/Zend/Db/Statement.php(291): Varien_Db_Statement_Pdo_Mysql->_execute(Array)
#2 /home/MyDomain/public_html/shop/lib/Zend/Db/Adapter/Abstract.php(480): Zend_Db_Statement->execute(Array)
#3 /home/MyDomain/public_html/shop/lib/Zend/Db/Adapter/Pdo/Abstract.php(238): Zend_Db_Adapter_Abstract->query('SELECT COUNT(DI...', Array)
#4 /home/MyDomain/public_html/shop/lib/Varien/Db/Adapter/Pdo/Mysql.php(504): Zend_Db_Adapter_Pdo_Abstract->query('SELECT COUNT(DI...', Array)
#5 /home/MyDomain/public_html/shop/lib/Zend/Db/Adapter/Abstract.php(828): Varien_Db_Adapter_Pdo_Mysql->query(Object(Varien_Db_Select), Array)
#6 /home/MyDomain/public_html/shop/lib/Varien/Data/Collection/Db.php(225): Zend_Db_Adapter_Abstract->fetchOne(Object(Varien_Db_Select), Array)
#7 /home/MyDomain/public_html/shop/app/code/core/Mage/Reports/Model/Product/Index/Abstract.php(175): Varien_Data_Collection_Db->getSize()
#8 /home/MyDomain/public_html/shop/app/code/core/Mage/Reports/Model/Product/Index/Abstract.php(202): Mage_Reports_Model_Product_Index_Abstract->calculate()
#9 /home/MyDomain/public_html/shop/app/code/core/Mage/Reports/Block/Product/Abstract.php(186): Mage_Reports_Model_Product_Index_Abstract->getCount()
#10 /home/MyDomain/public_html/shop/app/code/core/Mage/Reports/Block/Product/Compared.php(66): Mage_Reports_Block_Product_Abstract->getCount()
#11 /home/MyDomain/public_html/shop/app/code/core/Mage/Core/Block/Abstract.php(919): Mage_Reports_Block_Product_Compared->_toHtml()
#12 /home/MyDomain/public_html/shop/app/code/core/Mage/Core/Block/Text/List.php(43): Mage_Core_Block_Abstract->toHtml()
#13 /home/MyDomain/public_html/shop/app/code/core/Mage/Core/Block/Abstract.php(919): Mage_Core_Block_Text_List->_toHtml()
#14 /home/MyDomain/public_html/shop/app/code/core/Mage/Core/Block/Abstract.php(637): Mage_Core_Block_Abstract->toHtml()
#15 /home/MyDomain/public_html/shop/app/code/core/Mage/Core/Block/Abstract.php(581): Mage_Core_Block_Abstract->_getChildHtml('right', true)
#16 /home/MyDomain/public_html/shop/app/design/frontend/base/default/template/page/2columns-right.phtml(50): Mage_Core_Block_Abstract->getChildHtml('right')
#17 /home/MyDomain/public_html/shop/app/code/core/Mage/Core/Block/Template.php(241): include('/home/MyDomain/...')
#18 /home/MyDomain/public_html/shop/app/code/core/Mage/Core/Block/Template.php(272): Mage_Core_Block_Template->fetchView('frontend/base/d...')
#19 /home/MyDomain/public_html/shop/app/code/core/Mage/Core/Block/Template.php(286): Mage_Core_Block_Template->renderView()
#20 /home/MyDomain/public_html/shop/app/code/core/Mage/Core/Block/Abstract.php(919): Mage_Core_Block_Template->_toHtml()
#21 /home/MyDomain/public_html/shop/app/code/core/Mage/Core/Model/Layout.php(555): Mage_Core_Block_Abstract->toHtml()
#22 /home/MyDomain/public_html/shop/app/code/core/Mage/Core/Controller/Varien/Action.php(390): Mage_Core_Model_Layout->getOutput()
#23 /home/MyDomain/public_html/shop/app/code/core/Mage/Cms/Helper/Page.php(137): Mage_Core_Controller_Varien_Action->renderLayout()
#24 /home/MyDomain/public_html/shop/app/code/core/Mage/Cms/Helper/Page.php(52): Mage_Cms_Helper_Page->_renderPage(Object(Mage_Cms_IndexController), 'home')
#25 /home/MyDomain/public_html/shop/app/code/core/Mage/Cms/controllers/IndexController.php(45): Mage_Cms_Helper_Page->renderPage(Object(Mage_Cms_IndexController), 'home')
#26 /home/MyDomain/public_html/shop/app/code/core/Mage/Core/Controller/Varien/Action.php(418): Mage_Cms_IndexController->indexAction()
#27 /home/MyDomain/public_html/shop/app/code/core/Mage/Core/Controller/Varien/Router/Standard.php(254): Mage_Core_Controller_Varien_Action->dispatch('index')
#28 /home/MyDomain/public_html/shop/app/code/core/Mage/Core/Controller/Varien/Front.php(172): Mage_Core_Controller_Varien_Router_Standard->match(Object(Mage_Core_Controller_Request_Http))
#29 /home/MyDomain/public_html/shop/app/code/core/Mage/Core/Model/App.php(365): Mage_Core_Controller_Varien_Front->dispatch()
#30 /home/MyDomain/public_html/shop/app/Mage.php(684): Mage_Core_Model_App->run(Array)
#31 /home/MyDomain/public_html/shop/index.php(83): Mage::run('', 'store')
#32 {main}

Error log record number: 592209513033


Currently Magento FrontEnd is down and have no idea as to how to proceed or what other files have been over written.

[chiefair]

SQLSTATE[42S22]: Column not found: 1054 Unknown column 'e.status' in 'where clause', query was: SELECT COUNT(DISTINCT e.entity_id) FROM `mdw_catalog_product_flat_1`

After upgrading, rebuild all indexes. Your catalog_product_flat_1 index is missing a column because it hasn't been reindexed so it rebuilds to include the new column.

[ilinked · Accepted solution]

Thanks... It now works after I Reorginized Flat File Data.

[Wasim Akram]

hi ,

 i am also getting same problems like "

There has been an error processing your request

SQLSTATE[42S22]: Column not found: 1054 Unknown column 'e.status' in 'where clause', query was: SELECT COUNT(DISTINCT e.entity_id) FROM `catalog_product_flat_1` AS `e`
 INNER JOIN `deal_deal_product` AS `related` ON related.product_id = e.entity_id
 INNER JOIN `deal_deal` AS `deal` ON deal.entity_id = related.deal_id WHERE (e.status = 1) AND (deal.status = '1') AND (deal.end_date > '2016-

"so may i know that what is the proceess to reorganize the flat file and could you tell me that how to do overcome the problems ...help would be appreciable ...........thanks

[Smacks1879]

Hi,

I have this error as well after upgrading to 1.9 could you please help me?

SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '.`value)` = '0') AND (`start_time` <= '2016-02-02') AND (`end_time` >= '2016-02-' at line 2, query was: SELECT `main_table`.* FROM `bannerslider_banner` AS `main_table`
 LEFT JOIN `bannerslider_value` AS `status` ON main_table.banner_id = status.banner_id AND status.store_id = 1 AND status.attribute_code = 'status' WHERE (`bannerslider_id` = '1') AND (`IF(status`.`value IS NULL, main_table`.`status, status`.`value)` = '0') AND (`start_time` <= '2016-02-02') AND (`end_time` >= '2016-02-02') ORDER BY order_banner ASC

Trace:
#0 /home/cheapfis/public_html/lib/Varien/Db/Statement/Pdo/Mysql.php(110): Zend_Db_Statement_Pdo->_execute(Array)
#1 /home/cheapfis/public_html/app/code/core/Zend/Db/Statement.php(291): Varien_Db_Statement_Pdo_Mysql->_execute(Array)
#2 /home/cheapfis/public_html/lib/Zend/Db/Adapter/Abstract.php(480): Zend_Db_Statement->execute(Array)
#3 /home/cheapfis/public_html/lib/Zend/Db/Adapter/Pdo/Abstract.php(238): Zend_Db_Adapter_Abstract->query('SELECT `main_ta...', Array)
#4 /home/cheapfis/public_html/lib/Varien/Db/Adapter/Pdo/Mysql.php(504): Zend_Db_Adapter_Pdo_Abstract->query('SELECT `main_ta...', Array)
#5 /home/cheapfis/public_html/lib/Zend/Db/Adapter/Abstract.php(737): Varien_Db_Adapter_Pdo_Mysql->query('SELECT `main_ta...', Array)
#6 /home/cheapfis/public_html/lib/Varien/Data/Collection/Db.php(740): Zend_Db_Adapter_Abstract->fetchAll('SELECT `main_ta...', Array)
#7 /home/cheapfis/public_html/app/code/core/Mage/Core/Model/Resource/Db/Collection/Abstract.php(521): Varien_Data_Collection_Db->_fetchAll('SELECT `main_ta...', Array)
#8 /home/cheapfis/public_html/lib/Varien/Data/Collection/Db.php(572): Mage_Core_Model_Resource_Db_Collection_Abstract->getData()
#9 /home/cheapfis/public_html/lib/Varien/Data/Collection.php(741): Varien_Data_Collection_Db->load()
#10 /home/cheapfis/public_html/app/code/community/Magestore/Bannerslider/Block/Default.php(44): Varien_Data_Collection->getIterator()
#11 /home/cheapfis/public_html/app/design/frontend/ultimo/default/template/bannerslider/bannerslider.phtml(28): Magestore_Bannerslider_Block_Default->getBlockData()
#12 /home/cheapfis/public_html/app/code/core/Mage/Core/Block/Template.php(241): include('/home/cheapfis/...')
#13 /home/cheapfis/public_html/app/code/core/Mage/Core/Block/Template.php(272): Mage_Core_Block_Template->fetchView('frontend/ultimo...')
#14 /home/cheapfis/public_html/app/code/community/Magestore/Bannerslider/Block/Bannerslider.php(47): Mage_Core_Block_Template->renderView()
#15 /home/cheapfis/public_html/app/code/core/Mage/Core/Block/Abstract.php(919): Magestore_Bannerslider_Block_Bannerslider->_toHtml()
#16 /home/cheapfis/public_html/app/code/core/Mage/Core/Block/Text/List.php(43): Mage_Core_Block_Abstract->toHtml()
#17 /home/cheapfis/public_html/app/code/core/Mage/Core/Block/Abstract.php(919): Mage_Core_Block_Text_List->_toHtml()
#18 /home/cheapfis/public_html/app/code/core/Mage/Core/Block/Abstract.php(637): Mage_Core_Block_Abstract->toHtml()
#19 /home/cheapfis/public_html/app/code/core/Mage/Core/Block/Abstract.php(581): Mage_Core_Block_Abstract->_getChildHtml('content', true)
#20 /home/cheapfis/public_html/app/design/frontend/ultimo/default/template/page/1column.phtml(101): Mage_Core_Block_Abstract->getChildHtml('content')
#21 /home/cheapfis/public_html/app/code/core/Mage/Core/Block/Template.php(241): include('/home/cheapfis/...')
#22 /home/cheapfis/public_html/app/code/core/Mage/Core/Block/Template.php(272): Mage_Core_Block_Template->fetchView('frontend/ultimo...')
#23 /home/cheapfis/public_html/app/code/core/Mage/Core/Block/Template.php(286): Mage_Core_Block_Template->renderView()
#24 /home/cheapfis/public_html/app/code/core/Mage/Core/Block/Abstract.php(919): Mage_Core_Block_Template->_toHtml()
#25 /home/cheapfis/public_html/app/code/core/Mage/Core/Model/Layout.php(555): Mage_Core_Block_Abstract->toHtml()
#26 /home/cheapfis/public_html/app/code/core/Mage/Core/Controller/Varien/Action.php(390): Mage_Core_Model_Layout->getOutput()
#27 /home/cheapfis/public_html/app/code/core/Mage/Cms/Helper/Page.php(137): Mage_Core_Controller_Varien_Action->renderLayout()
#28 /home/cheapfis/public_html/app/code/core/Mage/Cms/Helper/Page.php(52): Mage_Cms_Helper_Page->_renderPage(Object(Mage_Cms_IndexController), 'home')
#29 /home/cheapfis/public_html/app/code/core/Mage/Cms/controllers/IndexController.php(45): Mage_Cms_Helper_Page->renderPage(Object(Mage_Cms_IndexController), 'home')
#30 /home/cheapfis/public_html/app/code/core/Mage/Core/Controller/Varien/Action.php(418): Mage_Cms_IndexController->indexAction()
#31 /home/cheapfis/public_html/app/code/core/Mage/Core/Controller/Varien/Router/Standard.php(254): Mage_Core_Controller_Varien_Action->dispatch('index')
#32 /home/cheapfis/public_html/app/code/core/Mage/Core/Controller/Varien/Front.php(172): Mage_Core_Controller_Varien_Router_Standard->match(Object(Mage_Core_Controller_Request_Http))
#33 /home/cheapfis/public_html/app/code/core/Mage/Core/Model/App.php(365): Mage_Core_Controller_Varien_Front->dispatch()
#34 /home/cheapfis/public_html/app/Mage.php(684): Mage_Core_Model_App->run(Array)
#35 /home/cheapfis/public_html/index.php(83): Mage::run('', 'store')
#36 {main}