cancel
Showing results for 
Search instead for 
Did you mean: 

Migrate data issue from 1.9.2.4 to 2.3.5-p1 - SQLSTATE[23000]: Integrity constraint violation

Migrate data issue from 1.9.2.4 to 2.3.5-p1 - SQLSTATE[23000]: Integrity constraint violation

Hi

I am trying to migrate magento from 1.9.2.4 version to 2.3.5-p1 with data migration tool. I have migrated settings, but now I have this issue on settings migration.

SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry '4-' for key 'EAV_ATTRIBUTE_ENTITY_TYPE_ID_ATTRIBUTE_CODE'

I already tried to check duplicates in eav_attributes table for entity_id = 4, but I cannot see any duplicate. Can you help me?

1 REPLY 1

Re: Migrate data issue from 1.9.2.4 to 2.3.5-p1 - SQLSTATE[23000]: Integrity constraint violation

@adrianmari1a59 ,

check the table into Magento1 

if the issue is still there try the following tool from UB

 

https://www.ubertheme.com/magento-extensions-2-x/magento-2-data-migration-pro/

 

it has really good options and the results are good.