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 
 
 
Screenshot:

1 answer

Profile photo of Mall Staff 98400.00 $tone November 23, 2018
Public

Hi there,

https://www.imgdumper.nl/uploads9/5bf72f631fa6d/5bf72f62e3b7a-Schermafbeelding_2018-11-22_om_23.34.24.png

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.
Regards,
Mall.

#1

Please login or Register to Submit Answer

Written By

Comments