Hi
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?
Thanks
3 answers
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)) {
continue;
}
$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.
Regards,
Mall.
Thanks.
That has worked
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.
Regards,
Ubertheme team
