Base table or view not found: 1146 Table 'catalog_category_flat_store_1' doesn't exit
Base table or view not found: 1146 Table 'catalog_category_flat_store_1' doesn't exist
I have see some answer for this question but its quick fix after some time I have same issue. But I get this error frequently. We can't say customer always to try again or refresh page. If I refresh page or do re-index I can see table available.
As part of debug I tried to DROP table manually and then visit pages but I can't see any error but I found that when table is not exits Magento will disable Flat table option in admin. so here I am not sure when this error occurs and what is the best solution to get rid of this.
If anybody found any solution to get rid of this problem permanently? For your information I have repair database as well as I replace flat table with fresh Magento table but still no luck I get error again after 2 days.