error

We get this SQL error on step 7 Migrate Sales
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

3 answers

Profile photo of Mall Staff 184060.00 $tone April 26, 2017
Public

Hi there,

Invalid datetime format: 1292 Incorrect datetime value: ‘0000-00-00 00:00:00’ for column ‘updated_at’ at row 1

That issue come from your MySQL settings in version 5.7.x and your Magento1’s database has some bad data with new rules of Magento2 database in the sales data section.
To handle that, let do steps as bellow:
Step 1: Download the php file at https://drive.google.com/file/d/0B4UfTo5yHHTKMWUwYlFaekp4aG8/view?usp=sharing
Step 2: Upload replace downloaded file to the file at location: pub/ub-tool/protected/controllers/Step7Controller.php
And then, you can continue with data migration in the step #7.
Regards,
Mall.
 
 

#1

Please login or Register to Submit Answer

Written By

Comments