Hello
When we try and run the UB Data migration tool to migrate M1 to M2 we get this error on the 8th Step ‘Others’.
Error 500
CDbCommand failed to execute the SQL statement: SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ‘) OR customer_id IS NULL)’ at line 1
Best Regards
Alexander
3 answers
Hi there,
Seem you have not select all customer groups in the step #6? Let’s try select all customer groups in the step #6 and tell me know how it goes.
Regards,
Mall.
That worked like a charm =)
But now we get this problem on step #7 sales. Any ideas?
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
Best Regards
Alexander
Hi there,
But now we get this problem on step #7 sales. Any ideas?
That because your database has bad data in the sales data section. Let’s try steps as bellow:
-- Down load the php file at https://drive.google.com/file/d/0B4UfTo5yHHTKMWUwYlFaekp4aG8/view?usp=sharing
-- And upload replace it to the file at: pub/ub-tool/protected/controllers/Step7Controller.php
-- Once done, let’ continue with data migration in the step #7
And tell me know how it goes.
Regards,
Mall.
