Closed

Magento 1 Fix Catalog Product Flat not indexing table (catalog_product_flat_1) PDOException: SQLSTATE[23000]: Integrity constraint violation: 1022

Hi,

I have an issue with catalog flat indexing.

Product Flat Data index process unknown error:

PDOException: SQLSTATE[23000]: 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.

Thank you

Skills: Linux, Magento, MySQL, PHP

See more: magento sqlstate 23000 integrity constraint violation 1452, magento search sqlstate 23000 integrity constraint violation 1452, sqlstate 23000 integrity constraint violation error, sqlstate 23000 sqlstate, table width oscommerce product description, table shipping per product zen cart, magento product sqlstate 23000 integrity constraint violation 1062, magento sqlstate 23000 integrity constraint violation import, magento sqlstate 23000 integrity constraint violation 1062 duplicate, product catalog table php, error magento sqlstate 23000 integrity constraint violation, magento sqlstate 23000 integrity constraint violation, 23000 sqlstate 23000 integrity constraint violation 1062, magento sqlstate 23000 integrity constraint violation 1062, exception pdoexception message sqlstate 23000 integrity constraint violation

About the Employer:
( 25 reviews ) Sofia, Bulgaria

Project ID: #19244169

14 freelancers are bidding on average $62 for this job

hardikmemagara

Hello, I will complete your every requirement as per your need that you have mentioned in your job details. We are group of magento experts. Will support after the work done as well. so please Come to the discussio More

$31 USD in 1 day
(557 Reviews)
7.8
sankhalainfosol

Hi, We are Expert team of Magento v.1 and v.2 developers. I am Certified Front end Magento Developer. So, We can work on both 1.x and 2.x. And we have worked on many Magento Projects earlier with high satisfaction o More

$72 USD in 1 day
(194 Reviews)
7.2
ambientinfotech

Hello, I have checked your job description as you mentioned and I am able to do this work because I have done many projects in this field and completed customized project, Please review my profile so we can discuss More

$61 USD in 1 day
(241 Reviews)
6.9
gursukh

yes sure I can help you now I have no timing issue I'm Individual freelancer with great experience thanks.

$30 USD in 0 days
(181 Reviews)
6.6
smilemittal181

Hello, I have read your job description carefully and I am ready to work on this project. I have 6+ years of experience in Magento website development and customization. I have done so many projects on Magento. P More

$100 USD in 5 days
(110 Reviews)
6.6
cubecreation

Hello, I have gone through your requirement, I can able to fix the duplicate constrant issue in the flat table. I am ready to start right away and aiming to finish this task in a couple of hours will try to finis More

$25 USD in 1 day
(85 Reviews)
6.5
Mangal01

Dear Client, Greetings!! I work on all the versions of Magento and currently updated myself with Magento 2.3.0 experience. I have 7+ your experience in Magento. I primarily work on web-development using Magento More

$25 USD in 1 day
(86 Reviews)
5.9
ubedarab

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.

$30 USD in 1 day
(60 Reviews)
5.6
hawkscodes

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

$35 USD in 1 day
(71 Reviews)
5.5
uvkoladiya

Hello There, I have read your post regarding Magento 1 Fix Catalog Product Flat not indexing table. I am expert in a Magento having more than 5+ years of experience in Customizing Magento website. I will fix you More

$20 USD in 1 day
(8 Reviews)
2.2
TechZeal1988

Hello, First of all, I need to see the admin and SSH then I can tell How It will solve. I am a Professional Full stack web developer having 5+ year experience of Web development using PHP, Codeigniter, Magento, W More

$50 USD in 1 day
(1 Review)
1.7
chetanpreetkaur

""Expert in Magento 2"" Dear Client, Hope you are doing well!! I have taken a detailed look at your job description and understand you want to us to work on ongoing websites which is on Magento 2 platform b More

$333 USD in 1 day
(1 Review)
1.2
KeyDevs

Hello Sir! Greetings! If you are looking at my reviews, you would not find them here as I just joined. However, if you would like to see my work, get in touch with me and I will show you hundreds and hundreds of pro More

$25 USD in 3 days
(0 Reviews)
0.0
sarathi190590

I have experience with Magento 1and 2. I can solve this problem with in a day.

$25 USD in 1 day
(0 Reviews)
0.0