webman group报错问题解决办法

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