2017/04/11 07:08:02 -- (Continued) migrated data in step #7 ok with 100 Sales Orders.
2017/04/11 07:08:03 -- Continue running step #72017/04/11 07:08:09 [error] [ub_data_migration] CDbCommand failed to execute the SQL statement: SQLSTATE[22007]: Invalid datetime format: 1292 Incorrect datetime value: ‘0000-00-00 00:00:00’ for column ‘updated_at’ at row 1
-
canvascampusa ⋅260.00 $tone April 11, 2017
Can not get pass the step seven so close - can anyone help - just point me to where to find the correct table.
canvascampusa ⋅260.00 $tone
April 11, 2017
6 answers
Hi there,
Invalid datetime format: 1292 Incorrect datetime value: ‘0000-00-00 00:00:00’ for column ‘updated_at’ at row 1
That issue because your Magento1’s database has some bad data with new rules of Magento2 database structure.
Let’s provide me the admin credentials, ssh credentials, phpmyadmin credentials and web root folder path of your Magento2 site.
I will check further and tell you workaround to solve that later.
Regards,
Mall.
Message: CDbCommand failed to execute the SQL statement: SQLSTATE[22007]: Invalid datetime format: 1292 Incorrect datetime value: ‘0000-00-00 00:00:00’ for column ‘updated_at’ at row 1. The SQL statement executed was: INSERT INTO `quote` (`store_id`, `updated_at`, `is_active`, `is_virtual`, `is_multi_shipping`, `items_count`, `items_qty`, `orig_order_id`, `store_to_base_rate`, `store_to_quote_rate`, `grand_total`, `base_grand_total`, `customer_group_id`, `customer_note_notify`, `customer_is_guest`, `trigger_recollect`, `is_persistent`, `created_at`, `customer_tax_class_id`) VALUES (:yp0, :yp1, :yp2, :yp3, :yp4, :yp5, :yp6, :yp7, :yp8, :yp9, :yp10, :yp11, :yp12, :yp13, :yp14, :yp15, :yp16, :yp17, :yp18)`, `grand_total`, `base_grand_total`, `customer_group_id`, `customer_note_notify`, `customer_is_guest`, `trigger_recollect`, `is_persistent`, `created_at`, `customer_tax_class_id`) VALUES (:yp0, :yp1, :yp2, :yp3, :yp4, :yp5, :yp6, :yp7, :yp8, :yp9, :yp10, :yp11, :yp12, :yp13, :yp14, :yp15, :yp16, :yp17, :yp18)
This is the error message I am getting but I have checked all the sales_flat_quote tables and can not find a bad date. Any suggestions?
Example query I am using to find the bad date --
Select * from sales_flat_quote_shipping_rate where updated_at = ‘0000-00-00 00:00:00’ or updated_at is null
Got by the date issue -- but now I am running into the following error --
Processing in step #7………………………………………………………………………………………….(Continued) migrated data in step #7 ok with 100 Sales Orders.
Processing in step #7…………………………………………………………………………………….
Status: fail
Message: CDbCommand failed to execute the SQL statement: SQLSTATE[HY000]: General error: 1366 Incorrect string value: ‘\xE4\xBC’ for column ‘firstname’ 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`, `created_at`, `customer_id`, `customer_address_id`, `address_type`, `firstname`, `lastname`, `company`, `street`, `city`, `region`, `postcode`, `country_id`, `telephone`, `shipping_method`, `shipping_description`, `shipping_tax_amount`, `base_shipping_tax_amount`, `applied_taxes`, `shipping_discount_amount`, `base_shipping_discount_amount`, `subtotal_incl_tax`, `shipping_incl_tax`, `base_shipping_incl_tax`, `free_shipping`) 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)
update sales_flat_quote_address set firstname =
convert(binary convert(firstname using latin1) using utf8);
this query fixed it
