Laravel - 迁移错误，可以为空的默认值？

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