On step 5 I’m getting an error in the log:
2016/11/18 15:50:48 [error] [ub_data_migration] 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 MariaDB server version for the right syntax to use near ‘N Style Bobby Pins -- 2″ -- 1/2 lb’ LIMIT 1′ at line 1
Seems to me that the fields aren’t handled safly as ‘ terminated an sql statement. This seems like a very basic bug in the module. Please post a work around.
3 answers
This is a snippet from log file.
2016/11/18 15:47:36 [info] [ub_data_migration] (Continued) migrated data in step #5 ok with 100 Products.
2016/11/18 15:47:46 [info] [ub_data_migration] Continue running step #5
2016/11/18 15:47:46 [info] [ub_data_migration] (Continued) migrated data in step #5 ok with 100 Products.
2016/11/18 15:48:06 [info] [ub_data_migration] Continue running step #5
2016/11/18 15:48:06 [info] [ub_data_migration] (Continued) migrated data in step #5 ok with 100 Products.
2016/11/18 15:48:18 [info] [ub_data_migration] Continue running step #5
2016/11/18 15:48:18 [info] [ub_data_migration] (Continued) migrated data in step #5 ok with 100 Products.
2016/11/18 15:48:30 [info] [ub_data_migration] Continue running step #5
2016/11/18 15:48:30 [info] [ub_data_migration] (Continued) migrated data in step #5 ok with 100 Products.
2016/11/18 15:48:39 [info] [ub_data_migration] Continue running step #5
2016/11/18 15:48:39 [info] [ub_data_migration] (Continued) migrated data in step #5 ok with 100 Products.
2016/11/18 15:48:47 [info] [ub_data_migration] Continue running step #5
2016/11/18 15:48:47 [info] [ub_data_migration] (Continued) migrated data in step #5 ok with 100 Products.
2016/11/18 15:48:53 [info] [ub_data_migration] Continue running step #5
2016/11/18 15:48:53 [info] [ub_data_migration] (Continued) migrated data in step #5 ok with 100 Products.
2016/11/18 15:49:23 [info] [ub_data_migration] Continue running step #5
2016/11/18 15:49:23 [info] [ub_data_migration] (Continued) migrated data in step #5 ok with 100 Products.
2016/11/18 15:49:29 [info] [ub_data_migration] Continue running step #5
2016/11/18 15:49:29 [info] [ub_data_migration] (Continued) migrated data in step #5 ok with 100 Products.
2016/11/18 15:49:43 [info] [ub_data_migration] Continue running step #5
2016/11/18 15:49:43 [info] [ub_data_migration] (Continued) migrated data in step #5 ok with 100 Products.
2016/11/18 15:49:52 [info] [ub_data_migration] Continue running step #5
2016/11/18 15:49:52 [info] [ub_data_migration] (Continued) migrated data in step #5 ok with 100 Products.
2016/11/18 15:50:02 [info] [ub_data_migration] Continue running step #5
2016/11/18 15:50:02 [info] [ub_data_migration] (Continued) migrated data in step #5 ok with 100 Products.
2016/11/18 15:50:41 [info] [ub_data_migration] Continue running step #5
2016/11/18 15:50:41 [info] [ub_data_migration] (Continued) migrated data in step #5 ok with 100 Products.
2016/11/18 15:50:48 [error] [ub_data_migration] 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 MariaDB server version for the right syntax to use near ‘N Style Bobby Pins -- 2″ -- 1/2 lb’ LIMIT 1′ at line 1
Hi marcinmf,
The snippet you shared can’t helps to see the root of issue.
2016/11/18 15:50:48 [error] [ub_data_migration] 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 MariaDB server version for the right syntax to use near ‘N Style Bobby Pins — 2″ — 1/2 lb’ LIMIT 1′ at line 1
It seem comes from you have a bad data with string ‘N Style Bobby Pins — 2″ — 1/2 lb’ in the database of Magento 1.
But we don’t see the context of that issue yet. Let’s provide me the admin and SSH credentials of your Magento 2.
I will check further and help you out.
Regards,
Mall.
