ubertheme / module-ubdatamigration

This is a module for Magento 2. This allow migrate data from Magento 1.x to Magento 2.x
https://www.ubertheme.com/magento-extensions-2-x/magento-2-data-migration-pro?utm_source=github&utm_medium=repo&utm_campaign=magento_migration_ce
48 stars 37 forks source link

Step 7 Issue - Migrate Sales Data #19

Open ducatimonster900ie opened 8 years ago

ducatimonster900ie commented 8 years ago

Hello

I get the following error when trying to complete the Step 7:

CDbException

CDbCommand failed to execute the SQL statement: SQLSTATE[22007]: Invalid datetime format: 1292 Incorrect datetime value: '0000-00-00 00:00:00' for column 'converted_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, entity_id, created_at, converted_at, base_currency_code, store_currency_code, quote_currency_code, checkout_method, customer_tax_class_id, remote_ip, applied_rule_ids, reserved_order_id, global_currency_code, base_to_global_rate, base_to_quote_rate, subtotal, base_subtotal, subtotal_with_discount, base_subtotal_with_discount, is_changed) 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)

It seems there is an incorrect datetime default value that is not accepted by Magento2 DB. Can you please help me solve this issue?

Thanks.

ub_data_migration___magento_admin_e_macintosh_hd_ _ssh_root_vbox-centos7_local_ _135x41 CDbException.pdf