CODE EXAMPLE FOR PHP

Syntax error or access violation: 1055

 'QLSTATE[42000]: Syntax error or access violation: 1055  in GROUP BY'
// f you get the above error, add the following into your database.php file in the config folder:
'mysql' => [
    'strict' => true,
    'modes' => [
        'STRICT_TRANS_TABLES',
        'NO_ZERO_IN_DATE',
        'NO_ZERO_DATE',
        'ERROR_FOR_DIVISION_BY_ZERO',
        'NO_AUTO_CREATE_USER',
        'NO_ENGINE_SUBSTITUTION'
    ],
]