I recently followed these instructions to set up a new website under the same url as the existing site:
http://magento.stackexchange.com/questions/79358/multi-website-multi-store-set-up
It is working however when I try to reindex the Catalog Search I get this error:
Base table or view not found: 1146 Table 'mysite.catalog_product_flat_24' doesn't exist
I have noticed others with a similar issue when they migrate their site but I am not sure why this table would be missing all of a sudden.
Any ideas how to rebuild this?
EDIT: Figured it out. I needed to enable Flat Catalog Products, then reindex it and then disable it again.
