cancel
Showing results for 
Search instead for 
Did you mean: 

Exception Printing Error after Magento CE 1.9.2.0 Upgrade

SOLVED
   Did you know you can see the translated content as per your choice?

Translation is in progress. Please check again after few minutes.

Exception Printing Error after Magento CE 1.9.2.0 Upgrade


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.

1 ACCEPTED SOLUTION

Accepted Solutions

Re: Exception Printing Error after Magento CE 1.9.2.0 Upgrade

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

View solution in original post

4 REPLIES 4

Re: Exception Printing Error after Magento CE 1.9.2.0 Upgrade

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.

Re: Exception Printing Error after Magento CE 1.9.2.0 Upgrade

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

Re: Exception Printing Error after Magento CE 1.9.2.0 Upgrade

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

Re: Exception Printing Error after Magento CE 1.9.2.0 Upgrade

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}