Laravel Database
sql_mode=only_full_group_by in Laravel Laravel Eloquent?
I solved this problem by adding the “modes” option and setting only the modes I wanted to be enabled in config => database.php:
1
2
3
4
5
6
7
8
9
10
11
'mysql' => [
...
'modes' => [
'STRICT_ALL_TABLES',
'ERROR_FOR_DIVISION_BY_ZERO',
'NO_ZERO_DATE',
'NO_ZERO_IN_DATE',
'NO_AUTO_CREATE_USER',
],
],