Magento 2.3 - After migration from magento 1.9.2.3 SQLSTATE[23000]: Integrity constraint violation e

[Aveeva]

After migration php bin/magento setup:upgrade command return following error,

Screenshot : https://snipboard.io/mdfAe5.jpg

There is no table inside the DB that table error is shown.

Screenshot : https://snipboard.io/tsqZSB.jpg

[Bhanu Periwal]

Hi @Aveeva 

kindly refer below links:

https://firebearstudio.com/blog/magento-2-integrity-constraint-violation-issues-solutions.html
https://support.weltpixel.com/hc/en-us/articles/360000594454-How-to-fix-Integrity-constraint-violati...

It will help you to resolve issue.

If issue resolve, Please click on 'Kudos' & Accept As Solution!

[Aveeva]

@Bhanu Periwal  Thank You

[Marcus - LitExtension Expert]

Hi @Aveeva,

Please go to these tables: catalog_product_entity_varchar, text, datetime, decimal and check whether the product 26974 has any duplicated attributes or not.

If it has, remove the duplicated attributes and check again. 

Let me know if you need further assistance. Hope it helps! 

_____________

If issue solved, Click Kudos & Accept as Solution.