我把我的项目从5.2升级到了laravel 5.3.现在，当我想要运行php artisan migrate时，我收到错误:
SQLSTATE[22007]: Invalid datetime format: 1292 Incorrect datetime value: '0000-00-00 00:00:00' for column 'created_at' at row 1 (SQL: alter table 100 add 101 timestamp null).
My migration:
Schema::table(Models::table('messages'), function (Blueprint $table) {
$table->softDeletes();
});
在蓝图中.php:
public function softDeletes()
{
return $this->timestamp('deleted_at')->nullable();
}
Laravel 5.3在默认情况下更新为使用MySQL"严格"模式，其中包括NO_ZERO_DATE模式.
问题是，您的现有数据被允许将"0000-00-00:00:00"作为日期时间值.但是，现在您的连接使用的sql模式不允许该值(NO_ZERO_DATE).当您试图更改表以添加deleted_at列时，它会抱怨created_at列中存在数据冲突.
The ideal solution would be to fix all the data in the database. That is, go through your database and update your datetime/timestamp fields so that they are nullable, and convert their data from '0000-00-00 00:00:00' to null.
但是，快速选项是在数据库连接上禁用"严格"模式.打开config/database.php文件，确保数据库连接显示'strict' => false.