CODEWITHSUNDEEP
phpmysqllaraveldatabase-migration
F_Bass
F_Bass

Reputation: 371

1067 Invalid default value for date 0000-00-00 00:00:00 in Laravel even after removing NO_ZERO_DATE and NO_ZERO_IN_DATE values from sql_mode

I'm trying to run a Laravel migration which is failing at this line

$table->dateTime('start_date')->nullable()->default('0000-00-00 00:00:00');

And I'm getting the following error:

1067 Invalid default value for 'start_date'

even after removing NO_ZERO_DATE and NO_ZERO_IN_DATE values from sql_mode.

I'm using XAMPP, and I ran the following commands:

SET GLOBAL sql_mode=''

SET SESSION sql_mode=''

SET sql_mode=''

I also removed them from the my.ini xampp file, but even after all that, I'm getting the error.

I also tried changing the collation from utf8_general_ci to latin1_swedish_ci but same result. Anyone got any insight on what could be happening?

Upvotes: 0

Views: 470

Answers (1)

Василий Пивоваров
Василий Пивоваров

Reputation: 335

You can check configuration file in config/database.php in params strict => false should be.

Upvotes: 1

Related Questions