Back to Questions Page

Step 5 : error mysql

0 Comment April 17, 2020
Vote Up
0
Vote Down
Resolved
Public
Technical Question
Profile photo of magepulsar magepulsar asked April 17, 2020

Hi,
I have this error while step 5 :
2020/04/17 10:49:25 -- [Processing][run] Step #5 migration completed with 100 Product Super Links;2020/04/17 10:49:25 -- [Processing][run] Step #5 migration completed with 100 Product Super Links;2020/04/17 10:49:25 -- [Processing][run] Step #5 migration completed with 100 Product Super Links;2020/04/17 10:49:26 -- [Processing][run] Step #5 migration completed with 100 Product Super Links;2020/04/17 10:49:26 -- [Processing][run] Step #5 migration completed with 49 Product Super Links;2020/04/17 10:49:27 -- [Processing][run] Step #5 migration completed with 100 Product Super Attributes;
2020/04/17 10:49:28 [error] [ub_data_migration] 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 ‘AND entity_id = 642 LIMIT 1’ at line 1
You can help me for find solution quickly ? 
Thank for you help.

1 answer

Vote Up
0
Vote Down
Profile photo of magepulsar ⋅50.00 $tone April 17, 2020
Public

 
The following query resolved the issue

DELETE FROM catalog_product_super_attribute_pricing WHERE value_index IS NULL OR value_index = '' OR value_index NOT IN (SELECT option_id FROM eav_attribute_option);
#1

Please login or Register to Submit Answer

Written By

Further Reading

Comments