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

Profile photo of ubdev Staff 98370.00 $tone February 28, 2020

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. 
Ubertheme team


Please login or Register to Submit Answer

Written By