error while importing attribute

I’ve got this error at step 3 when I try to import attributes:
Migrate Data -- UB Data Migration Pro: Allow migrate data from Magento CE 1.x to Magento CE 2.x 

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 ‘Ombrage Migrated’ LIMIT 1′ at line 1

Thanks for your help.

1 answer

Profile photo of Mall Staff 184060.00 $tone February 6, 2017

Hi steelwave,
It seem you have some special chars in the name of the Attribute Sets/Attribute groups in your Magento1 database.
To solve that, let’s do steps as bellow:
Download the php file at
And upload replace it to the file at: pub/ub-tool/protected/controllers/Step3Controller.php
And reset the step #3 and restart data migration in this step.
And tell me know how it goes.


Please login or Register to Submit Answer

Written By