Categories: Solutions

ERROR: Invalid default value for ‘created_at’ [solution]

I got a problem while adding a new column in the database as well as editing the column. The error says invalid default value for ‘created_at’

So I tried to do run this code in this code in the SQL.

SET sql_mode = '';

 

But It didnt work. So I tried the command allowing database to be installed

SET GLOBAL sql_mode = '';

 

And tried again. And it worked!!

jaminrai

Recent Posts

Computer Science Project Report Guidelines and Sample

Guidelines (Click Below to Download) SAMPLE 1 SAMPLE 2

5 months ago

Skype Closes Its Doors After 20 Years: A Look Back and the Apps That Faded with It

After 20 years of transforming global communication, Skype has officially ceased operations. Microsoft, which purchased…

12 months ago

The Duck and the Tortoise: A Tale of Patience and Teamwork

In a serene forest by the edge of a sparkling lake, there lived a cheerful…

1 year ago