data migration error

Hi
i just installed magento fresh version 2.2 and trying to migration but showing error.
 
CDbCommand failed to execute the SQL statement: SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry ’12-design’ for key ‘CATALOG_CATEGORY_PRODUCT_ATTRIBUTE_SET_ID_ATTRIBUTE_GROUP_CODE’. The SQL statement executed was: INSERT INTO `eav_attribute_group` (`attribute_set_id`, `sort_order`, `default_id`, `attribute_group_name`, `attribute_group_code`, `tab_group_code`) VALUES (:yp0, :yp1, :yp2, :yp3, :yp4, :yp5)

5 answers

Profile photo of Mall Staff 184060.00 $tone May 5, 2018
Public

Hi there,

CDbCommand failed to execute the SQL statement: SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry ’12-design’ for key ‘CATALOG_CATEGORY_PRODUCT_ATTRIBUTE_SET_ID_ATTRIBUTE_GROUP_CODE’. 

To solve that issue, please try with steps as followings:
+ Step 1: Open the php file at path: pub/ub-tool/protected/controllers/Step3Controller.php
and find to the code line:

$attributeGroupCode2 = (preg_match("/(design)/i", $attributeGroupCode2)) ? 'design' : $attributeGroupCode2;

and replace it by code line:

//$attributeGroupCode2 = (preg_match("/(design)/i", $attributeGroupCode2)) ? 'design' : $attributeGroupCode2;

+ Step 2: Continue with data migration in the step #3
And tell me know how it goes.
Regards,
Mall.

#1
Profile photo of ubdev Staff 98590.00 $tone May 5, 2018
Public

Hi there, 
Glad it helps. 
Please move forward with migration process. Make sure you follow strictly our Readme.html instruction that comes packed with your download package. 
If you run across any other issue, please get back to us here, we will help you out.
Regards,
Ubertheme team

#3
Profile photo of shar.next 30.00 $tone May 7, 2018
Public

Hi
i migreated my database from magento 1 to 2. it is showing 100%  but in frontend i am not able to see any data. i did reindexing and also clear cache and save store all this thing except delta migration. i have to do also delta migration or what i am going to wrong here. please help me.

#4
Profile photo of Mall Staff 184060.00 $tone May 7, 2018
Public

Hi there,

i have to do also delta migration or what i am going to wrong here. please help me.

No, you don’t need delta migration at this step.
It seems you have not assigned the migrated root category for the default store of the default website in your instance. Please check this in Stores management at your end again.

After changing to migrated root category for default Store, you must re-index data and clean the Magento cache.

Once done, please let me know how it goes.

Regards,
Mall.

#5

Please login or Register to Submit Answer

Written By

Comments