Error migrating Reviews: Duplicate entry error

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

Profile photo of Mall Staff 184060.00 $tone June 27, 2017
Public

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.

#1
Profile photo of dockmarksib 30.00 $tone June 28, 2017
Public

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)

#2
Profile photo of Mall Staff 184060.00 $tone June 28, 2017
Public

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.
 

#3
Profile photo of ubdev Staff 97910.00 $tone June 28, 2017
Public

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
 

#5
Profile photo of ubdev Staff 97910.00 $tone June 28, 2017
Public

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 

#7

Please login or Register to Submit Answer

Written By

Comments