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
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.
Hi
yes it is working fine now.
Thank you
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
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.
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.
