it is fail When transferring order data from magento1. it shows
php -f bin/ubdatamigration run --step=7 --mode=update
Processing in step #7…
Status: fail
Message: CDbCommand failed to execute the SQL statement: SQLSTATE[23000]: Integrity constraint violation: 1062 Dup licate entry ’44’ for key ‘PRIMARY’. The SQL statement executed was: INSERT INTO `salesrule` (`uses_per_customer`, `is_active`, `stop_rules_processing`, `is_advanced`, `sort_order`, `discount_amount`, `discount_step`, `apply_to_ shipping`, `times_used`, `is_rss`, `coupon_type`, `use_auto_generation`, `uses_per_coupon`, `simple_free_shipping` , `rule_id`, `name`, `description`, `from_date`, `conditions_serialized`, `actions_serialized`, `simple_action`) V ALUES (:yp0, :yp1, :yp2, :yp3, :yp4, :yp5, :yp6, :yp7, :yp8, :yp9, :yp10, :yp11, :yp12, :yp13, :yp14, :yp15, :yp16 , :yp17, :yp18, :yp19, :yp20),
this is the the delta migration.
Thank you so much.
-
david elecrow ⋅-10.00 $tone July 26, 2019
after I delete the sales rule (which has the rule_id = 44) in the mage2, it show another error--Status: failMessage: CDbCommand failed to execute the SQL statement: SQLSTATE[HY000]: General error: 1366 Incorrect string value: '\xE9' for column 'city' at row 1. The SQL statement executed was: INSERT INTO `quote_address` (`quote_id`, `updated_at`, `save_in_address_book`, `same_as_billing`, `collect_shipping_rates`, `weight`, `subtotal`, `base_subtotal`, `subtotal_with_discount`, `base_subtotal_with_discount`, `tax_amount`, `base_tax_amount`, `shipping_amount`, `base_shipping_amount`, `discount_amount`, `base_discount_amount`, `grand_total`, `base_grand_total`, `free_shipping`, `created_at`, `customer_id`, `customer_address_id`, `address_type`, `email`, `firstname`, `lastname`, `street`, `city`, `region`, `postcode`, `country_id`, `telephone`, `shipping_tax_amount`, `base_shipping_tax_amount`, `applied_taxes`, `subtotal_incl_tax`, `shipping_incl_tax`, `base_shipping_incl_tax`) 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)
david elecrow ⋅-10.00 $tone
July 26, 2019
3 answers
Hi David,
General error: 1366 Incorrect string value: ‘\xE9’ for column ‘city’ at row 1. The SQL statement executed was: INSERT INTO `quote_address`
That issue was because your M1 database had bad data in the value of ‘city’ field in the table ‘sales_flat_quote_address’. You can run the below SQL in your M1 database to list that bad record at your end:
Select city from sales_flat_quote_address where city regexp '[^ -~]';
And then, you can run the following SQL in your M1 database to fix that bad data record:
Update sales_flat_quote_address set city = convert(binary convert(city using latin1) using utf8);
+ Once done, you can continue with the data migration in the step #7 by running the command:
php -f bin/ubdatamigration run --step=7;
Regards,
Mall.
Hi David,
Message: CDbCommand failed to execute the SQL statement: SQLSTATE[23000]: Integrity constraint violation: 1062 Dup licate entry ’44’ for key ‘PRIMARY’. The SQL statement executed was: INSERT INTO `salesrule` (`uses_per_customer`, `is_active`, `stop_rules_processing`,
That issue occurred because you checked the ‘KEEP ORIGINAL IDs’ setting in the step #7 of our migration tool, while your M2 had at least one sales rule added before data migration.
To continue with the ‘KEEP ORIGINAL IDs’ option, you need to delete the sales rule (which has the rule_id = 44) added in M2.
Once done, you can continue with the data migration in step #7 by running the command:
php -f bin/ubdatamigration run --step=7
Regards,
Mall.
Hi David,
For any new question you might have, please help to add a new reply, instead of posting under the comment section of your original question. It’s hard for us to follow up your questions in the comment section.
Regards,
Ubertheme team
