SQLSTATE[42000]: Syntax error or access violation: 1055 for groupby in laravel

Question

I want to group all duplicate rows but I got error

Here is below error

Illuminate\Database\QueryException: SQLSTATE[42000]: Syntax error or access violation: 1055 'car_web.dependencies.id' isn't in GROUP BY (SQL: select * from dependencies where make_dep = 3 group by model_dep) in file C:\xampp\htdocs\car-parts-web\vendor\laravel\framework\src\Illuminate\Database\Connection.php on line 671

I also change in database.php file

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

but give same error

here is below my query

$data = DB::table('dependencies')
        ->where('make_dep', '=', $make)
        ->groupBy('model_dep')
        ->get();

You typically GROUP BY the same columns as you SELECT, except those who are arguments tp set functions. — jarlh
– jarlh, Commented Sep 21, 2020 at 11:47
After changed, have you clear the caches? php artisan config:cache — Dilip Hirapara
– Dilip Hirapara, Commented Sep 21, 2020 at 11:48
try in database.php inside mysql array 'strict' => false, make it false and try — Kamlesh Paul
– Kamlesh Paul, Commented Sep 21, 2020 at 11:59

wittich · Accepted Answer · 2024-01-30 20:08:39Z

3

You are confused in GROUP BY statement because in GROUP BY we need to use any aggregate function like SUM, COUNT, ... .

If you want to remove duplicate rows you can simply use DISTINCT method, if you want to group data you need any aggregate function.

edited Jan 30, 2024 at 20:08

wittich

2,3412 gold badges32 silver badges52 bronze badges

answered Sep 21, 2020 at 12:08

Shahrukh

4983 silver badges15 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

SQLSTATE[42000]: Syntax error or access violation: 1055 for groupby in laravel

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related