Laravel - "Syntax Error or Access Violation 1055 in Group By" - Solved

By Hardik Savani • November 5, 2023

Laravel

Yesterday i was working on my Laravel 5.4 application and when i use group by statement in query builder I found error like as bellow:

SQLSTATE[42000]: Syntax error or access violation: 1055 'admin.products.name' isn't in GROUP BY (SQL: select `products`.*, SUM(products_stock.stock) from `products` inner join `products_stock` on `products_stock`.`product_id` = `products`.`id` group by `products`.`id`)

I was thinking what will be error and why it comes. i thought maybe it comes from mysql. i just add following query using laravel builder as like bellow:

Laravel Query


$data = DB::table("products")
          ->select("products.*",DB::raw("SUM(products_stock.stock)"))
          ->join("products_stock","products_stock.product_id","=","products.id")
          ->groupBy("products.id")
          ->get();

But it's give me error as i add bellow. I searched on google and finally i found solution. You have to open batabase.php configuration file and we have to just "strict" equal to false. So do it like as bellow:

config/database.php


<?php
return [
.....
'connections' => [
		......
		'mysql'[
			.....
			'strict' => false,
			.....
		]
	]
]

I hope it can help you...

We Are Recommending You

Read Now →

ItSolutionStuff.com

Laravel - "Syntax Error or Access Violation 1055 in Group By" - Solved

Hardik Savani

How to Execute Artisan Command from Controller in Laravel?

How to get Keys from Array in PHP Laravel?

We Are Recommending You

Get Array of Ids from Eloquent Models in Laravel

Laravel Group By with Min Value Query Example

Laravel Group By with Max Value Query Example

Laravel Eloquent doesntHave() Condition Example

Laravel Copy Record using Eloquent Replicate Example

Laravel Eloquent updateOrCreate Example

Laravel Eloquent take() and skip() Query Example

Laravel Eloquent whereNotBetween() Query Example

Laravel Eloquent Order By Query Example

Laravel Eloquent exists() and doesntExist() Example

Laravel Create Custom Error Page Example

Laravel Eloquent Order By Random Row Example

How to Execute MySQL Query in Laravel?

Laravel Join with Subquery in Query Builder Example