Hi
I have installed UB data migration tool, on Magento 2,2,4 / sqlite with php 7
on step 2, “Migrate websites, strores i get this error:
CDbCommand failed to execute the SQL statement: SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry ‘1’ for key ‘PRIMARY’. The SQL statement executed was: INSERT INTO `store` (`website_id`, `group_id`, `sort_order`, `is_active`, `store_id`, `code`, `name`) VALUES (:yp0, :yp1, :yp2, :yp3, :yp4, :yp5, :yp6)
on …./pub/ub-tool/yii/db/CDbCommand.php(358)
Any ideas?
1 answer
Hi Giannis,
Thanks for giving our Lite version a try.
It’s a pity that our UB Data Migration Lite version is available for Magento 2.0.7 only, and it also comes with a few limitations:
- Your Magento must be a fresh instance
- It does not support Nginx server
- It is based on an outdated codebase, so it might lead to unexpected issues during the migration process
So we highly recommend you consider moving forward with our Pro version, it will definitely save you much of time.
Regards,
Ubertheme team