SQLSTATE[42000] error product migrate

When migrating products it says following error, please help:

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 

1 answer

Profile photo of Mall Staff 184060.00 $tone November 23, 2018

Hi there,


It seems your M1’s database has some bad records in table ‘catalog_product_entity_datetime’. I need a closer look on that issue before provide you workaround to solve that, let’s provide me information about your instance:
+ Admin credentials and URL to back-end
+ SSH credentials and path to M2 folder
I will help to check further and get back you then.


Please login or Register to Submit Answer

Written By