Hello,
I’ve gotten the following error when I attempt to migrate the “Migrate Others” data.
“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 ‘amante’ LIMIT 1′ at line 1. The SQL statement executed was: SELECT * FROM `mgjb_email_template` `t` WHERE template_code = ‘Nuovo ordine d’amante’ LIMIT 1”
Do you have any suggestion?
1 answer
Hi there,
That because your database has some special chars in the value of the template_code in table email_template. To handle that, you could do followings steps:
-- Download the php file at HERE
-- Uploaded replace downloaded file to the file at: pub/ub-tool/protected/controllers/Step8Controller.php
-- Once done, you can continue data migration in the step #8
Regards,
Mall.
