cancel
Showing results for 
Search instead for 
Did you mean: 

Migrated Database Import Error

   Did you know you can see the translated content as per your choice?

Translation is in progress. Please check again after few minutes.

Migrated Database Import Error

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.

1 REPLY 1

Re: Migrated Database Import Error

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