Laravel - migration error, nullable default?

Question

In the migration I have the following line:

$table->date('end_date')->nullable()->change();

For some reason this dont work anymore when I moved from homestead to valet.

Error I get when I run the migration via console:

SQLSTATE[42000]: Syntax error or access violation: 1067 Invalid default value for 'end_date'

Answer 1

try $table->date('end_date')->nullable()->default(null)->change();. Maybe your db version doesn't accept 0000:00:00 zeros