How can I solve incompatible with sql_mode=only_full_group_by in laravel eloquent?

Solution:

I had a similar Problem and solved it by disabling mysql strict mode in the database connection setting.

'connections' => [
    'mysql' => [
        // Behave like MySQL 5.6
        'strict' => false,

        // Behave like MySQL 5.7
        'strict' => true,
    ]
]

You can find even more configuration settings inĀ this blog post by Matt Stauffer