Hello There,
I am receiving the following error on step 7. Can you please assist me with which command to run to correct it?
CDbCommand failed to execute the SQL statement: SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry ‘1615’ for key ‘PRIMARY’. The SQL statement executed was: INSERT INTO `sales_order_tax` (`tax_id`, `order_id`, `code`, `title`, `percent`, `amount`, `priority`, `position`, `base_amount`, `process`, `base_real_amount`) VALUES (:yp0, :yp1, :yp2, :yp3, :yp4, :yp5, :yp6, :yp7, :yp8, :yp9, :yp10)
Thank you
3 answers
Hi there,
1062 Duplicate entry ‘1615’ for key ‘PRIMARY’. The SQL statement executed was: INSERT INTO `sales_order_tax` (`tax_id`, `order_id`, `code`, `title`, `percent`, `amount`, `priority`, `position`, `base_amount`, `process`, `base_real_amount`) VALUES (:yp0, :yp1, :yp2, :yp3, :yp4, :yp5, :yp6, :yp7, :yp8, :yp9, :yp10)
You can try with these steps:
+ Run the following SQL query in your M2 database:
Delete From sales_order_tax Where tax_id = 1615;
+ Once done, you continue with the data migration in step #7 by running the CLI command:
php -f bin/ubdatamigration run --step=7;
Regards,
Mall.
Thanks for that it worked and went through a ways and now gives this error.
Status: fail
Message: CDbCommand failed to execute the SQL statement: SQLSTATE[HY000]: General error: 1366 Incorrect decimal value: ” for column ’embroidery_price’ at row 1. The SQL statement executed was: INSERT INTO `quote_item` (`quote_id`, `no_discount`, `weight`, `qty`, `price`, `base_price`, `discount_percent`, `discount_amount`, `base_discount_amount`, `tax_percent`, `tax_amount`, `base_tax_amount`, `row_total`, `base_row_total`, `row_total_with_discount`, `row_weight`, `free_shipping`, `item_id`, `created_at`, `updated_at`, `product_id`, `store_id`, `is_virtual`, `sku`, `name`, `is_qty_decimal`, `embroidery_price`, `product_type`, `original_custom_price`, `price_incl_tax`, `base_price_incl_tax`, `row_total_incl_tax`, `base_row_total_incl_tax`, `discount_tax_compensation_amount`, `base_discount_tax_compensation_amount`, `weee_tax_applied`, `weee_tax_applied_amount`, `weee_tax_applied_row_amount`, `weee_tax_disposition`, `weee_tax_row_disposition`, `base_weee_tax_applied_amount`, `base_weee_tax_disposition`, `base_weee_tax_row_disposition`) VALUES (:yp0, :yp1, :yp2, :yp3, :yp4, :yp5, :yp6, :yp7, :yp8, :yp9, :yp10, :yp11, :yp12, :yp13, :yp14, :yp15, :yp16, :yp17, :yp18, :yp19, :yp20, :yp21, :yp22, :yp23, :yp24, :yp25, :yp26, :yp27, :yp28, :yp29, :yp30, :yp31, :yp32, :yp33, :yp34, :yp35, :yp36, :yp37, :yp38, :yp39, :yp40, :yp41, :yp42)
ubuntu@ip-172-31-17-186:/var/www/magento$ Status: fail
Hi there,
1366 Incorrect decimal value: ” for column ’embroidery_price’ at row 1. The SQL statement executed was: INSERT INTO `quote_item` (`quote_id`, `no_discount`, `weight`, `qty`, `price`,
That issue related to a custom field named ‘embroidery_price‘. It seems that it was added manually by your developer or added by a third-party extension which you are using in your M2 site.
Please check the settings of that custom field in the ‘quote‘ table in your M2 database. Please make sure that all the settings are correct and you have to set a default value for that field.
Once done, you can continue with the data migration in step #7.
Regards,
Mall.
