Back to Questions Page

sql errot while import products

0 Comment February 20, 2017
Vote Up
0
Vote Down
Answered
Public
Technical Question
Profile photo of steelwave steelwave asked February 20, 2017

Hello, 
I had to reimport my product on a fressh install.
I ahve this error when I import some products:
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 ‘mk AND entity_name = ‘eav_attribute_option” at line 1

Thanks.
Regards

3 answers

Vote Up
0
Vote Down
Profile photo of Mall ⋅ Staff ⋅184060.00 $tone February 20, 2017
Public

Hi steelwave,
That issue maybe come from your bad data or your MySQL settings. I need a closer look to detect the root of issue, let’s provide me the admin, ssh credentials and web root folder path of your Magento2.
I will check further and help you out.
Regards,
Mall.

#1

Please login or Register to Submit Answer

Written By

Further Reading

Comments