Error 1064 in step 5

Hi, Here is the error log. We have more than 2700 products, and the product links have been processed, and while it comes to product super links, it has errors after a few cycle. Please note, I read the Q&A section, and thought just delteing entity_id 2118 (useless product) will work, but again, the same error message occured for entity_id 2119. Please help.
2020/03/19 23:43:46 -- [Processing][run] Step #5 migration completed with 100 Product Links;
2020/03/19 23:43:53 -- [Processing][run] Step #5 migration completed with 52 Product Links;
2020/03/19 23:43:54 -- [Processing][run] Step #5 migration completed with 100 Product Super Links;
2020/03/19 23:43:55 -- [Processing][run] Step #5 migration completed with 100 Product Super Links;
2020/03/19 23:43:56 -- [Processing][run] Step #5 migration completed with 100 Product Super Links;
2020/03/19 23:43:57 -- [Processing][run] Step #5 migration completed with 100 Product Super Links;
2020/03/19 23:43:59 -- [Processing][run] Step #5 migration completed with 100 Product Super Links;
2020/03/19 23:44:00 -- [Processing][run] Step #5 migration completed with 100 Product Super Links;
2020/03/19 23:44:01 -- [Processing][run] Step #5 migration completed with 76 Product Super Links;
2020/03/19 23:44:08 [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 = 2118 LIMIT 1’ at line 1
2020/03/20 00:41:00 [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 = 2118 LIMIT 1’ at line 1
After entity_id 2118 (the whole product, not in any individual table) is deleted, same error occurred for the next record:
2020/03/20 00:41:00 [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 = 2119 LIMIT 1’ at line 1

3 answers

Profile photo of Mall Staff 184060.00 $tone March 20, 2020
Public

Hi there,

2020/03/20 00:41:00 [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 = 2119 LIMIT 1’ at line 1

That issue because your M1 database has at least one bad data record in table ‘catalog_product_super_attribute_pricing‘. These data records has relation with a none exists attribute options in table ‘eav_attribute_option‘.
To solve that issue, you can do steps as following:
+ Run following SQL in your M1 database to delete the bad data records I 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);

+ Once done, you can continue with data migration in step #5 by run CLI command:
php -f bin/ubdatamigration run --step=5;
Regards,
Mall.

#1
Profile photo of Joshua Denne 200.00 $tone March 20, 2020
Public

Thanks, looks good, 3 record deleted, and the CLI command successfully restarted the process. Just wondering if we can still use the graphic interface to continute the step 5, and the following steps?
Thanks for your help.
 
Josh

#2
Profile photo of Mall Staff 184060.00 $tone March 20, 2020
Public

Hi Josh,

 Just wondering if we can still use the graphic interface to continute the step 5, and the following steps?

You can continue with the UI dashboard of our tool. However, for better performance you can run the CLI command as suggested in my reply #2.

Regards,
Mall.

#3

Please login or Register to Submit Answer

Written By

Comments