We have magento 188.8.131.52. Our host provider upgraded the php on our server from 5.1.6 to 5.2.14 and I am now seeing this same problem:
SQLSTATE[42S22]: Column not found: 1054 Unknown column âused_in_product_listingâ in âwhere clauseâ
Also, this (in admin):
SQLSTATE[42S22]: Column not found: 1054 Unknown column âmain_table.is_visibleâ in âwhere clauseâ
1.) Admin --> System --> Cache Management --> All Cache --> Refresh
2.) Deleted the contents of magento/var/cache
Still the same problems.
This is on a live site.