SQLSTATE[42S22]: Column not found: 1054 Unknown column ‘e.status’ in ‘where clause’ in magento

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  “

———————————————————————————————————————————————————————————————-