I am getting error while migrating products

CDbCommand failed to execute the SQL statement: SQLSTATE[22007]: Invalid datetime format: 1292 Incorrect datetime value: ‘0000-00-00 00:00:00’ for column ‘created_at’ at row 1. The SQL statement executed was: INSERT INTO `catalog_product_entity` (`attribute_set_id`, `type_id`, `has_options`, `required_options`, `sku`, `created_at`, `updated_at`) VALUES (:yp0, :yp1, :yp2, :yp3, :yp4, :yp5, :yp6)

  1. I solved this issue run this UPDATE `catalog_product_entity` SET `created_at` = NULL WHERE `created_at` = '0000-00-00 00:00:00' sql query on M1 database

3 answers

Profile photo of Mall Staff 184060.00 $tone October 18, 2019
Public

Hi there,

I solved this issue run this UPDATE `catalog_product_entity` SET `created_at` = NULL WHERE `created_at` = ‘0000-00-00 00:00:00’ sql query on M1 database

Yes, lets continue with that workaround and contact me if your need further assistance.
Regards,
Mall.

#1
Profile photo of ubdev Staff 98550.00 $tone October 21, 2019
Public

Hi there, 
We close this ticket for now. Please submit a new one in case you have any additional question. 
Regards,
Ubertheme team

#3

Please login or Register to Submit Answer

Written By

Comments