Saidqb
Saidqb Hanya sekedar bercerita dengan damai

Laravel Database

sql_mode=only_full_group_by in Laravel Laravel Eloquent?

Source

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',
    ],
],

Rating:

comments powered by Disqus