When migrating the Reviews from magento 1.9.3.db we encounter this issue:
CDbCommand failed to execute the SQL statement: SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry ‘1-0’ for key ‘PRIMARY’
Key seems strange to me.
Please help us out.
7 answers
Hi dockmarksib,
CDbCommand failed to execute the SQL statement: SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry ‘1-0’ for key ‘PRIMARY’
You got that issue in which step of our tool? Kindly enable debug mode as indicated in the guide of our tool in Readme.html.
And then, re-run the data migration in the step with issue as you mentioned. I will check further and help you out.
Regards,
Mall.
Debug modus enabled.
Following more explicit error returned:
CDbCommand failed to execute the SQL statement: SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry ‘1-0’ for key ‘PRIMARY’. The SQL statement executed was: INSERT INTO `review_store` (`review_id`, `store_id`) VALUES (:yp0, :yp1)
Hi there,
What version of our tool in your working now? That issue was fixed in the latest version 3.0.9 of our tool. Kindly download the latest version and install upgrade to your working.
Once done, you can continue with data migration in the step #8 of our tool:
php -f bin/ubdatamigration run --step=8
And tell me know how it goes.
Regards,
Mall.
Where can I find the download link? I have to renew my license?
Hi Paul,
Our team did grant you access to download the version 3.0.8, as noted in this ticket.
As you subscription has expired, please consider renewal to get access to the latest UB Data Migration Pro package. Further, our technical support requires active subscription though.
Thanks for your understanding.
Regards,
Ubertheme team
Are you seriously considering that I have to buy a full new license for 399$ to have a bug fixed?
Hi Paul,
The issue you mentioned might come from one of the following reasons:
-- You did use Reset option many times in the step #8 after your first migration, or
-- Your database issue itself
From many projects using our migration tool, it takes less than 2 months on average for the migration process. And our team is always available to provide you help within your subscription duration.
In your case, we went ahead to grant you extended time to download version 3.0.8, even after your subscrition expiry.
We are not sure if any issue might occur with your specific database; also our newer release version 3.0.9 comes with extra enhancements in delta migration (as noted here) that’s why we suggest you consider renewal option.
Regards,
Ubertheme team