Breaking News: Grepper is joining You.com. Read the official announcement!

Syntax error or access violation: 1055 'u873490575_besomewhere.reservations.id' isn't in GROUP BY

Doubtful Dove answered on December 9, 2021 Popularity 1/10 Helpfulness 1/10

answer Syntax error or access violation: 1055 'u873490575_besomewhere.reservations.id' isn't in GROUP BY

Syntax error or access violation: 1055 'u873490575_besomewhere.reservations.id' isn't in GROUP BY

Comment

'mysql' => [
       ...
       ....
       'strict' => true,
       'modes' => [
            //'ONLY_FULL_GROUP_BY', // Disable this to allow grouping by one column
            'STRICT_TRANS_TABLES',
            'NO_ZERO_IN_DATE',
            'NO_ZERO_DATE',
            'ERROR_FOR_DIVISION_BY_ZERO',
            'NO_AUTO_CREATE_USER',
            'NO_ENGINE_SUBSTITUTION'
        ],
 ]

Popularity 1/10 Helpfulness 1/10 Language whatever

Source: stackoverflow.com

Tags: group-by syntax-error whatever

Link to this answer
Share Copy Link