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
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.
Hi Mall,
Thanks for the quick response that has worked now and everything has migrated across
Hi there,
Yes, lets contact me if you need further assistance.
Regards,
Mall.
