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

Syntax error or access violation: 1055 'earnwvql_cash.offer_setups.id' isn't in GROUP BY (SQL: select * from `offer_setups` group by `section`)

hansal answered on January 31, 2024 Popularity 1/10 Helpfulness 1/10

answer Syntax error or access violation: 1055 'earnwvql_cash.offer_setups.id' isn't in GROUP BY (SQL: select * from `offer_setups` group by `section`)

Syntax error or access violation: 1055 'earnwvql_cash.offer_setups.id' isn't in GROUP BY (SQL: select * from `offer_setups` group by `section`)

Comment

In config\database.php --> "mysql" array

Set 'strict' => false to disable all.

.... or

'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 select syntax-error whatever

Link to this answer
Share Copy Link