error while importing attribute

Hello,
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.
Regads.
Laurent

1 answer

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

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 https://drive.google.com/file/d/0B4UfTo5yHHTKVU9meUUtX3daWkk/view?usp=sharing
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.
Regards,
Mall.
 

#1

Please login or Register to Submit Answer

Written By

Comments