Getting this error in step 8, sun from command line.
ALL choices selected.
Status: fail
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 all_groups = 0 AND website_id = 3 AND customer_group_id = 4 AND qty = 1 LIMI’ at line 1. The SQL statement executed was: SELECT * FROM `catalog_product_entity_tier_price` `t` WHERE entity_id = AND all_groups = 0 AND website_id = 3 AND customer_group_id = 4 AND qty = 1 LIMIT 1
-
Toby ⋅440.00 $tone July 3, 2017
I was already using tool version 3.0.9Did download and upload the file.New error:Status: failMessage: 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 sort_order = 0 LIMIT 1' at line 1. The SQL statement executed was: SELECT * FROM `catalogrule_product` `t` WHERE rule_id = 1 AND from_time = 0 AND to_time = 0 AND website_id = 2 AND customer_group_id = 6 AND product_id = AND sort_order = 0 LIMIT 1
Toby ⋅440.00 $tone
July 3, 2017
3 answers
Hi Toby,
What version of our tool in your working now? That issue because your database has some records with bad data in the table named catalog_product_entity_tier_price.
To handle that, let do steps as bellow: (the first, make sure you are using v3.0.9 of our tool)
Step 1: Download the php file at HERE
Step 2: Upload replace it to the file at path: pub/ub-tool/protected/controllers/Step8Controller.php
Step 3: Once done, you can continue with data migration in the step #8 of our tool.
Regards,
Mall.
I already used the 3.0.9 version, uploaded the new file, and now I get this error:
Status: fail
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 sort_order = 0 LIMIT 1’ at line 1. The SQL statement executed was: SELECT * FROM `catalogrule_product` `t` WHERE rule_id = 1 AND from_time = 0 AND to_time = 0 AND website_id = 2 AND customer_group_id = 6 AND product_id = AND sort_order = 0 LIMIT 1
Hi there,
SELECT * FROM `catalogrule_product` `t` WHERE rule_id = 1 AND from_time = 0 AND to_time = 0 AND website_id = 2 AND customer_group_id = 6 AND product_id = AND sort_order = 0 LIMIT 1
That is one more case of bad data in the table catalogrule_product of your database.
Let’s download the php file at HERE
And replace downloaded file to the file at: pub/ub-tool/protected/controllers/Step8Controller.php
Once done, you can continue with data migration in the step #8.
Regards,
Mall.
