Error in UB data step 8 others

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

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

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.

#
Profile photo of store4geeks 30.00 $tone May 26, 2017
Public

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

#1
Profile photo of Mall Staff 184060.00 $tone May 27, 2017
Public

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.
 

#2

Please login or Register to Submit Answer

Written By

Comments