Back to Questions Page

Reset Migration Steps – error message

1 Comment June 17, 2017
Vote Up
0
Vote Down
Answered
Public
Technical Question
Profile photo of Heather McMahon Heather asked June 17, 2017

 I’m trying to RE-SET migration, however I get this error:
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 ‘) OR customer_id IS NULL)’ at line 1
I only want to re-migrate category & products, however this tool requires ALL steps to be re-set and when I do that I get the error noted above.

  1. Profile photo of Heather McMahonHeather ⋅50.00 $tone June 17, 2017
    problem at STEP 3 ATTRIBUTES:CDbCommand failed to execute the SQL statement: SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry '11-127' for key 'EAV_ENTITY_ATTRIBUTE_ATTRIBUTE_SET_ID_ATTRIBUTE_ID'

1 answer

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

Hi Heather,
Kindly provide me the admin credentials, ssh credentials and web root path of your Magento2. I will check further issues as you mentioned and reply you more later.
Regards,
Mall.

#1

Please login or Register to Submit Answer

Written By

Further Reading

Comments