Error on step 6

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

Profile photo of Mall Staff 184060.00 $tone December 22, 2019
Public

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.

#1
Profile photo of ubdev Staff 98590.00 $tone December 22, 2019
Public

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

#3

Please login or Register to Submit Answer

Written By

Comments