Syntax error or access violation: 1055 Error

[yehlu]

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

代碼: 選擇全部

strict => false

As in

代碼: 選擇全部

'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,
],