hi, i am receiving the following error on step 5 products
Message: 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 `catalog_product_super_attribute` (`product_id`, `attribute_id`, `position`, `product_super_attribute_id`) VALUES (:yp0, :yp1, :yp2, :yp3)
many thanks
1 answer
Hi there,
1062 Duplicate entry ‘1’ for key ‘PRIMARY’. The SQL statement executed was: INSERT INTO `catalog_product_super_attribute`
That issue occurred because you did check the ‘KEEP ORIGINAL IDs’ setting in step #5 while your M2 has the sample or testing data in the product data section.
We handled that case in UB Data Migration Pro ver3.2.4 already. Please consider upgrading to this version and then, you can continue with data migration in step #5 by running the CLI command:
php -f bin/ubdatamigration run --step=5;
Regards,
Mall.
