Hi Ubertheme,
At the delta migration at step 7 this happens
Message: CDbCommand failed to execute the SQL statement: SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry ‘62933’ for key ‘PRIMARY’. The SQL statement executed was: INSERT INTO `quote_item_option` (`option_id`, `item_id`, `product_id`, `code`, `value`) VALUES (:yp0, :yp1, :yp2, :yp3, :yp4)
3 answers
Hi there,
1062 Duplicate entry ‘62933’ for key ‘PRIMARY’. The SQL statement executed was: INSERT INTO `quote_item_option`
That issue occurred because you checked the ‘KEEP ORIGINAL IDs’ setting in step #7. And you did add some testing sales orders after the first migration with our module.
Please try the following steps:
+ Run the SQL below in your M2 database:
Delete From quote_item_option Where option_id = 62933;
+ Once done, continue with the data migration in step #7.
Regards,
Mall.
Hi Mall,
I will try this command.
But the extra orders that were created were deleted because I put back a databasebackup.
Hi there,
But the extra orders that were created were deleted because I put back a databasebackup.
Please note that the duplicated issue happened on sales quotes data which was added in M2 after the first migration.
I will try this command.
Yes, please follow the steps as suggested in my reply #1. And contact me if you need further assistance.
Regards,
Mall.
