phphub
phphub copied to clipboard
执行php artisan migrate --seed的时候报错
[Illuminate\Database\QueryException]
SQLSTATE[42000]: Syntax error or access violation: 1067 Invalid default val
ue for 'created_at' (SQL: create table site_statuses (id int unsigned n
ot null auto_increment primary key, day varchar(255) not null, created_a t timestamp default 0 not null, updated_at timestamp default 0 not null)
default character set utf8 collate utf8_unicode_ci)
[PDOException] SQLSTATE[42000]: Syntax error or access violation: 1067 Invalid default val ue for 'created_at'
把以往问题看了一遍,找到了答案
database.php里面添加'strict'=>true
'mysql' => array( 'driver' => 'mysql', 'host' => getenv('DB_HOST') ?: 'localhost', 'database' => getenv('DB_NAME') ?: 'phphub', 'username' => getenv('DB_USERNAME') ?: 'root', 'password' => getenv('DB_PASSWORD') ?: '', 'charset' => 'utf8', 'collation' => 'utf8_unicode_ci', 'prefix' => '', 'strict' => true,
),