Can you tell me how to solve this problem?
CDbCommand failed to execute the SQL statement: SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry ‘2’ for key ‘PRIMARY’. The SQL statement executed was: INSERT INTO `catalog_product_entity` (`attribute_set_id`, `type_id`, `has_options`, `required_options`, `entity_id`, `sku`, `created_at`, `updated_at`) VALUES (:yp0, :yp1, :yp2, :yp3, :yp4, :yp5, :yp6, :yp7)
5 answers
Hi Tom,
May I know the Magento version you are using?
Actually, our Lite version is available for Magento 2.0.7 only, and it has some limitations:
- It is not ready for NGINX web server
- Your Magento 2.0.7 must be a fresh installation
- And it comes with limited feature sets, compared to our Pro version.
- It uses old codebase which was not improved with bug fixes, performance optimization.
If you wish to make a test migration, you can follow the guide in Readme.txt file (in your download package) again with a fresh Magento 2.0.7 instance. You can also take a look at this tutorial video: https://youtu.be/Jvr8d3OeB8M -- This is for our old UB Data Migration Pro version 2 (which uses the same codebase with Lite version).
Anyway, it will save you pretty much time to move forward with our Pro version, as this version is completely overhauled, with various bug fixes and performance optimisation. You can learn more via this tutorial video for UB Data Migration Pro version 3: https://youtu.be/R4UBLe2kf-I
Regards,
An Nguyen
dear An,
I am using Magento 2.1.5 and it is a fresh installation
Hi Tom,
It’s pity our Lite version is available for Magento 2.0.7 only. Please try with this version again, if you choose to.
Meanwhile, I’d like to include two recent case studies so that you can learn more about our Pro version:
- We did use the Pro version ourself to help Winetasting.com – Migrate 382,047 customer entities to Magento 2.
- And this case study as well -- Freelaunch.nl used UB Data Migration Pro to migrate 230,000 products to Magento 2.
Hope that helps.
Regards,
An Nguyen
Hi An
I am using this migration tool https://github.com/ubertheme/magento2_data_migration
Hi Tom,
The old script on Github was no longer maintained, and replaced with our newer Pro version. So we’re sorry for not being of much help under your case.
Thanks,
An Nguyen