I have an issue with catalog flat indexing.
Product Flat Data index process unknown error:
PDOException: SQLSTATE: Integrity constraint violation: 1022 Can't write; duplicate key in table '#sql-d4a_b2d'
Even after truncation of the table catalog_product_flat_1 and start new indexation there is an error for duplicated key.
I tried do disable Catalog Product Flat and truncate catalog_product_flat_1 table and then enable again to create a new table but again I have an error.
I will grant you access with teamviewer to SSH or you can send me instructions how to fix this.
14 freelancers are bidding on average $62 for this job
Hi, Can I help you? I am Magento developer and designer since 2009, I am interested to work with you for long term, can we discuss about your project requirement ? waiting for your reply, bye.
Hi, I have read your exact requirement and understood the error. I will fix it as per your guidance. I have +8 years of experience in Magento and also have +5 years of experience as a Linux Admin. Regards Karuna