Hello
I have this error
CDbCommand failed to execute the SQL statement: SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry ‘11874’ for key ‘PRIMARY’
Please advice
Thanks
4 answers
Hi there,
CDbCommand failed to execute the SQL statement: SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry ‘11874’ for key ‘PRIMARY’
Please provide me more details information about that error message, I will help to check further and get back you then.
Regards,
Mall.
Hi Mall
This error come by running delta from the Magento admin (there is not other info)
Now i run again step 5 from the cli (php7.3 -f bin/ubdatamigration run --step=5 --mode=update;) but is going very slow, I will waiting if an error come up and i come back to you
thanks
Hi Mall
This is what i get:
Status: fail
Message: CDbCommand failed to execute the SQL statement: SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry ‘11874’ for key ‘PRIMARY’. The SQL statement executed was: INSERT INTO `catalog_product_link_attribute_int` (`value`, `value_id`, `product_link_attribute_id`, `link_id`) VALUES (:yp0, :yp1, :yp2, :yp3)
Hi there,
Message: CDbCommand failed to execute the SQL statement: SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry ‘11874’ for key ‘PRIMARY’. The SQL statement executed was: INSERT INTO `catalog_product_link_attribute_int` (`value`, `value_id`,
That issue occurred because you checked the ‘KEEP ORIGINAL IDs’ settings in step #5 of our module while you had newly added products in M2 after the first migration.
Please run the following SQL query in your M2 database to delete the duplicated record ID (11874) in the error message that you saw:
Delete From catalog_product_link_attribute_int Where value_id = 11874;
+ Once done, you continue with the data migration in step #5 using this command:
php7.3 -f bin/ubdatamigration run --step=5 --mode=update
Regards,
Mall.