Step 4 SQL Errors

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

Profile photo of Mall Staff 115660.00 $tone August 6, 2019
Public

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.
 

#
Profile photo of Mall Staff 115660.00 $tone August 6, 2019
Public

Hi there,

http://prntscr.com/op4ro6

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.

#1
Profile photo of Alisson Paganini 30.00 $tone August 6, 2019
Public

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

#2
Profile photo of Alisson Paganini 30.00 $tone August 6, 2019
Public

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

#3
Profile photo of ubdev Staff 44240.00 $tone August 7, 2019
Public

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

#4

Please login or Register to Submit Answer

Written By

Comments