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)
-
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
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.
thanks for your support
Hi there,
We close this ticket for now. Please submit a new one in case you have any additional question.
Regards,
Ubertheme team