webman group报错
this is incompatible with sql_mode=only_full_group_by in
解决办法 config/database.php 中修改
'strict' => false,
如下
'mysql' => [
'driver' => 'mysql',
'host' => getenv('DB_HOST'),
'port' => getenv('DB_PORT'),
'database' => getenv('DB_NAME'),
'username' => getenv('DB_USER'),
'password' => getenv('DB_PASSWORD'),
'unix_socket' => '',
'charset' => 'utf8',
'collation' => 'utf8_unicode_ci',
'prefix' => 'self_',
// strict这个配置,改为false,groupby就能用了
'strict' => false,
'engine' => null,
],