CDbCommand failed to execute the SQL statement:

Hello,
in Step 5:
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 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
Robert
 
Sorry for my Bad English
 

3 answers

Profile photo of Mall Staff 110580.00 $tone December 20, 2018
Public

Hi there,

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.
Regards,
Mall.

#1
Profile photo of ubdev Staff 39580.00 $tone December 21, 2018
Public

Hi Robert, 
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. 
Regards,
Ubertheme team

#3

Please login or Register to Submit Answer

Written By

Comments