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

Stuart's Blog

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.

View original post

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s