Was updating my indexes and noticed that one had failed, upon further investigation it looks like
catalog_product_flat throws the following exception:
exception 'PDOException' with message 'SQLSTATE[HY000]: General error: 1005 Can't create table
sql-4416_38f7(errno: 121 "Duplicate key on write or update")' in /home/mysite/public_html/lib/Zend/Db/Statement/Pdo.php:228
Does someone have a statement I can run to resolve this error? or Should I drop the catalog_product_flat table and re-index to recreate it?
EDIT: Just tried running the repair tool and it says
I know I'm not the only one to have this because Google leads to links back to the old magento forum or people post that they fixed the issue but didn't outline what they've done.