SQLSTATE[42S22]: Column not found: 1054 Unknown column ‘e.status’ in ‘where clause’ in magento:
When we upgrade a magento CE from lower version to higher version (below magento CE 2 version) we may get below error message.
SQLSTATE[42S22]: Column not found: 1054 Unknown column ‘e.status’ in ‘where clause’
SELECT COUNT(DISTINCT e.entity_id) FROM `catalog_product_flat_1`
Trace:
#0 /root/lib/Varien/Db/Statement/Pdo/Mysql.php(110): Zend_Db_Statement_Pdo->_execute(Array)
When you get this error, your entire site (frontend (some time admin also)) broken. You won’t get the page.
Steps to resolve:
1. Do re-indexing all by putty
2. Clear cache folder.
3. Referesh the page. It will work. The issue is noting but flat table. Flat table may missing a column. Once we do the re-indexing then it will add new column.
————————————————————————————————————————————————————————————-
Corner of Blog:
” SAVE WATER ….. SAVE LIFE “
———————————————————————————————————————————————————————————————-