When I try to reindex catalog_product_flat from command line I get following error.

Reindex finished with error message "SQLSTATE[HY000]: General error: 1005 Can't create tablemagento_db.#sql-4f16_e84(errno: 121 "Duplicate key on write or update")". catalog_product_flat

I tried to truncate all catalog_product_flat tables and rerun it, same result. How can I fix this?

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.