SQLSTATE[42S22]: Column not found: 1054 Unknown column ‘e.visibility’ in ‘where clause’
Sounds quite a catastrophic error in Magento, but it seems to be quite common in “responsive magento themes”. Quick fix for this is to ensure the following are set –
Use Flat Catalog Category = NO
Use Flat Catalog Product = NO
You find these settings under the “Default Config” Scope – under System, Configuration, Catalog, Frontend.