Hi
I have hit an issue with step 5:
[Processing][run] Step #5 migration completed with 100 Product Super Attributes;
........................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................
Status: fail
Message: 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 = 5520 LIMIT 1' at line 1. The SQL statement executed was: SELECT * FROM `catalog_product_entity_int` `t` WHERE attribute_id = 174 AND value = AND entity_id = 5520 LIMIT 1
I note this ticket: https://www.ubertheme.com/question/step-5-error-mysql/
Will this fix work?
And if so do I need to reset step 5 or simply try running it again?
Finally, I’m slightly concerned about having to run this on M1…. Should I be?
Thanks
1 answer
Hi there,
I note this ticket: https://www.ubertheme.com/question/step-5-error-mysql/
Will this fix work?
Yes, you can run the SQL query (indicated in reply #1 in that ticket) in your M1 database to solve the issue you mentioned.
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);
And then, you continue with the data migration in step #5 by running the CLI command:
php -f bin/ubdatamigration run --step=5;
Regards,
Mall.