in Step 5:
CDbCommand failed to execute the SQL statement: SQLSTATE: 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 attribute_id = 79 AND store_id = 0 LIMIT 1’ at line 1. The SQL statement executed was: SELECT * FROM `catalog_product_entity_datetime` `t` WHERE entity_id = AND attribute_id = 79 AND store_id = 0 LIMIT 1
I become this Error -- in the SQL Statement missing entity_id value.
What can i do?
Give it a way to Find the entrys in m1 databases and repair this or give it a another way
Sorry for my Bad English
LIMIT 1’ at line 1. The SQL statement executed was: SELECT * FROM `catalog_product_entity_datetime` `t` WHERE entity_id = AND attribute_id = 79 AND store_id = 0 LIMIT 1
It seem your M1 database has some bad records in table catalog_product_super_link
Let’s try with steps below:
+ Download the PHP file at Here
+ And upload replace to the file at path: pub/ub-tool/protected/controllers/Step5Controller.php
+ Once done, continue with data migration in the step #5
And tell me know how it goes.
Thanks this Works!
I wish you and your Team Merry Christmas
Glad that it helps.
We wish you and your family a Happy Christmas too.
Meanwhile, in case you missed, we’re offering a special Xmas Sale at present. Please take a look at our other Magento 2 extensions (like UB Mega Menu, UB One Step Checkout …) to see if they are a good fit for your project. It gives you a big 25% saving for those extensions. The offer is available within today only.