Migrated Database Import Error

[Kiran]

I am trying to import the migrated database getting the below issue:

ERROR 1062 (23000) at line 1460: Duplicate entry '1-229-0' for key 'CATALOG_CATEGORY_ENTITY_INT_ENTITY_ID_ATTRIBUTE_ID_STORE_ID' 

 Please suggest how to fix this.

[Nishu Jindal]

Hi @Kiran 

In Migrated Database, Check for Table "catalog_category_entity_int" 

In above table you must be having 2 entries for Single Attribute Id (229).

Delete the unwanted entry.

In this table, combination of EntityId_AttributeId_StoreId should be unique.

I hope it will help you!

If my answer is useful, please Accept as Solution & give Kudos