Getting error during migrate sales data

I am  getting  error  when migrate sales data step 7 in pro version 

CDbCommand failed to execute the SQL statement: SQLSTATE[HY000]: General error: 1366 Incorrect string value: ‘\xE2\x80’ for column ‘telephone’ at row 1 

Thank you 
Mona Bishnoi

1 answer

Profile photo of Mall Staff 141850.00 $tone June 23, 2020
Public

Hi Mona,

CDbCommand failed to execute the SQL statement: SQLSTATE[HY000]: General error: 1366 Incorrect string value: ‘\xE2\x80’ for column ‘telephone’ at row 1 

Please try with these steps:

+ Run the following SQL query in your M1 database:

Update sales_flat_quote_address set telephone = convert(binary convert(telephone using latin1) using utf8);

+ Once done, you continue with the data migration in step #7 using this command:
php -f bin/ubdatamigration run --step=7;

Regards,
Mall.

#1

Please login or Register to Submit Answer

Written By

Comments