Hello, when I perform the migration from step 4 to migrate all categories the following error appears
http://prntscr.com/op4ro6
please, help me
5 answers
Hi there,
Let retry with steps below:
+ Run below SQL in your M2 database:
ALTER TABLE `ub_migrate_step` CHANGE `setting_data` `setting_data` LONGBLOB NULL DEFAULT NULL COMMENT 'Settings Data';
+ Once done, reset the step #4 by run CLI command:
php -f bin/ubdatamigration reset --step=4
+ And then, back to back-end dashboard in step #4 of our migration tool and try again.
Regards,
Mall.
Hi there,
That issue because your M1 database has pretty big volume of categories. Lets do steps below:
+ Run below SQL in your M2 database:
ALTER TABLE `ub_migrate_step` CHANGE `setting_data` `setting_data` BLOB NULL DEFAULT NULL COMMENT 'Settings Data';
+ Once done, reset the step #4 by run CLI command:
php -f bin/ubdatamigration reset --step=4
+ And then, back to back-end dashboard in step #4 of our migration tool and try again.
Regards,
Mall.
I ran the command in the M2 database as I said to do, right after I ran the CLI in ssh and even doing all these procedures, the error continues
my max_input_vars is the :9000
Hello thanks for the last answer worked perfectly. But when I arrive at the migrateing data step I have several errors like
https://prnt.sc/op6nw1
my version of magento is: 2.1.17
Step 2: Property “Mage2StoreGroup.code” is not defined.
step 3: 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 ‘)’ at line 1. The SQL statement executed was: SELECT * FROM `eav_attribute_label“ t` WHERE attribute_id = 1 AND store_id IN ()
step 4: 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 ‘)’ at line 1. The SQL statement executed was: SELECT * FROM `catalog_category_entity_datetime“ t` WHERE entity_id = 2 AND store_id 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 ‘)’ at line 1. The SQL statement executed was: SELECT * FROM `catalog_product_entity_int“ t` WHERE entity_id = 2 AND store_id IN ()
step 7: 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 ‘)’ at line 1. The SQL statement executed was: SELECT * FROM `salesrule_label“ t` WHERE rule_id = 1 AND store_id IN ()
step 8: 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 ‘) OR store_id IS NULL’ at line 1. The SQL statement executed was: SELECT COUNT (*) FROM `review_entity_summary“ t` WHERE store_id IN ( ) OR store_id IS NULL
Please. help me
Hi Alisson,
We wonder if you have another paid profile at Ubertheme? We could not keep track of your purchase.
If you’re working on your client project, please help to instruct your client to post the issue under the paid profile.
Our technical support requires active subscription though.
Sincerely,
Ubertheme team