Incorrect datetime value: ” for column ‘deleted_at’ at row 1 Articles

Incorrect datetime value: ” for column ‘deleted_at’ at row 1

by | Jul 20, 2019 | MySQL | 0 comments

Recent days i am working with my live project when i face any problem in my web application, i have to download the whole database and then restoring it to localhost. But facing a lots of problem, like

ERROR 1292 (22007) at line 3236: Incorrect datetime value: ” for column ‘deleted_at’ at row 1

So what is the solution!!

SELECT @@GLOBAL.sql_mode global, @@SESSION.sql_mode session;
SET sql_mode = '';
SET GLOBAL sql_mode = '';

Run this line, it will solve your problem.

0 Comments

Submit a Comment

Your email address will not be published. Required fields are marked *

Name Goes Here

Name Goes Here

Position

Your content goes here. Edit or remove this text inline or in the module Content settings. You can also style every aspect of this content in the module Design settings and even apply custom CSS to this text in the module Advanced settings.