I am trying to migrate a store from 220.127.116.11 to Magento 2.2 using the Magento data migration tool but unfortunately when running the tool the error appears
[PDOException] SQLSTATE: Integrity constraint violation: 1062 Duplicate entry 'default' for key 'STORE_GROUP_CODE'
As I understand
STORE_GROUP_CODE is a new column added in Magento 2.2
It is generated from column
STORE_GROUP_NAME which in Magento 2.X is found in table STORE_GROUP
In Magento 18.104.22.168 column
STORE_GROUP_NAME is located with table
from within the Magento 22.214.171.124 database
so migration is failing because of the duplicate entries.
The default Value for website_id 0 (admin) should be 'default' The default value for website id 1 (base) should be 'Main Website Store'
Unfortunately, both my store_group_names are the default.
As an experiment I change
Store_Group_Name for website 1 (base) to 'Main Website Store' and data migration ran no problems.
Everything worked until I reindex the result was
Frontend: When viewing the store (on a clean luma 2.2 installations) the add to cart buttons are missing Backend: All products show in list view but if you click one product it loads with the error: Unable to unserialize value
Does anyone know how I can change the Store_Group_Name website id 1 (base) without breaking the database