Syntax error or access violation: 1055 Error
發表於 : 2018-07-04 11:07:37
https://stackoverflow.com/questions/409 ... 1055-error
up vote
59
down vote
This is probably a SQL_MODE problem. In your config/database.php, in the connection, change
As in
up vote
59
down vote
This is probably a SQL_MODE problem. In your config/database.php, in the connection, change
代碼: 選擇全部
strict => false
代碼: 選擇全部
'mysql' => [
'driver' => 'mysql',
'host' => env('DB_HOST', 'localhost'),
'port' => env('DB_PORT', '3306'),
'database' => env('DB_DATABASE', 'forge'),
'username' => env('DB_USERNAME', 'forge'),
'password' => env('DB_PASSWORD', ''),
'charset' => 'utf8',
'collation' => 'utf8_unicode_ci',
'prefix' => '',
'strict' => false,
'engine' => null,
],