Edit config\database.php

Disable all strict modes:

'strict' => false,

Keep strict enabled, and disable only ONLY_FULL_GROUP_BY mode:

'mysql' => [
   'strict' => true,
   'modes' => [
        // 'ONLY_FULL_GROUP_BY',
        'STRICT_TRANS_TABLES',
        'NO_ZERO_IN_DATE',
        'NO_ZERO_DATE',
        'ERROR_FOR_DIVISION_BY_ZERO',
        'NO_AUTO_CREATE_USER',
        'NO_ENGINE_SUBSTITUTION'
    ],
]