Step 5 error:

when running step 5 I see the following error:

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

Looks like there is a product without an ID?
any ideas?

3 answers

Profile photo of Mall Staff 153110.00 $tone October 1, 2020

Hi there,

Looks like there is a product without an ID?

Yes, to solve that issue you can try with these steps:

+ Open the PHP file at: pub/ub-tool/protected/controllers/Step5Controller.php
and find the code line:

$condition = "entity_id = {$associatedProductId2} AND attribute_id = {$attributeId2}";

and replace it with: 

if (empty($associatedProductId2)) {
$condition = "entity_id = {$associatedProductId2} AND attribute_id = {$attributeId2}";

+ Once done, you continue with the data migration in step #5.
And let me how it goes then.


Profile photo of ubdev Staff 71680.00 $tone October 4, 2020

Hi there,
We’re glad that it helped. 
We’re for getting back to you a little bit late since we’ve just been back from our weekend. 
If you have any additional questions, please submit a new ticket, we will follow up with you then.
Ubertheme team 


Please login or Register to Submit Answer

Written By