Step 5 : error mysql

Resolved

Public

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.

UB Data Migration Pro

1 answer

Vote Up

Vote Down

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);