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!!

Author: jaminrai