Hello There,
I am receiving the below error on step 6.
Step 6 has made it almost all of the way through we have 103.409 of the 120,000 customers migrated.
Any help would be greatly appreciated.
CDbCommand failed to execute the SQL statement: SQLSTATE[22007]: Invalid datetime format: 1292 Incorrect datetime value: ‘0000-00-00 00:00:00’ for column ‘created_at’ at row 1. The SQL statement executed was: INSERT INTO `customer_address_entity` (`is_active`, `entity_id`, `parent_id`, `created_at`, `updated_at`, `country_id`, `firstname`, `lastname`, `street`, `telephone`, `city`) VALUES (:yp0, :yp1, :yp2, :yp3, :yp4, :yp5, :yp6, :yp7, :yp8, :yp9, :yp10)
Thank you
3 answers
Hi there,
CDbCommand failed to execute the SQL statement: SQLSTATE[22007]: Invalid datetime format: 1292 Incorrect datetime value: ‘0000-00-00 00:00:00’ for column ‘created_at’ at row 1. The SQL statement executed was: INSERT INTO `customer_address_entity` (`is_active`, `entity_id`,
Lets try with these steps:
+ Run the following SQL query in your M1 database:
Update customer_address_entity Set created_at = '2019-12-23 00:00:00' Where created_at = '0000-00-00 00:00:00';
+ Once done, you can continue with the data migration in step #6 by running the CLI command:
php -f bin/ubdatamigration run --step=6;
And tell me know how it goes then.
Regards,
Mall.
This worked.
Thank you
Hi there,
Glad that it helps.
Please continue with the migration process. If you come across any other issue, please pause the process and let us know the details of issue, we will follow up further with you.
Regards,
Ubertheme team
