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.