u add one status coloum in catalog_product_flat give the as defined value 1 your problem is solved if not complete call to this number 9912397326
THIS HELPED ME:
CMS > SYSTEM > INDEX MANAGEMENT > SELECT ALL AND REINDEX ALL DATA
But I get " An error occurred while saving the URL rewrite", to fix this use this tutorial:
http://www.human-element.com/magento-fixes-an-error-occurred-while-saving-the-url-rewrite/
Hi,
this was helpfull for me. Thank you!