Laravel 5 – “syntax error or access violation 1055 in group by” Solved
In this post we will give you information about Laravel 5 – “syntax error or access violation 1055 in group by” Solved. Hear we will give you detail about Laravel 5 – “syntax error or access violation 1055 in group by” SolvedAnd how to use it also give you demo for it if it is necessary.
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’)
Laravel 5 - Class 'Input' not found issue?
In this post we will give you information about Laravel 5 - Class 'Input' not found issue?. Hear we will give you detail about Laravel 5 - Class 'Input' not found issue?And how to use it also give you demo for it if it is necessary.
When i start to work on Laravel 5.2 at that time i fetch this problem "Class 'Input' not found". When i copy my old controller code from laravel 5.1 version that time i found this issue, but i also could use Input insted to Request but i want to use Input as it is. But at last found solution. you have to just use following aliase on your controller.
use IlluminateSupportFacadesInput as Input
Hope this code and post will helped you for implement Laravel 5 - Class 'Input' not found issue?. if you need any help or any feedback give it in comment section or you have good idea about this post you can give it comment section. Your comment will help us for help you more and improve us. we will give you this type of more interesting post in featured also so, For more interesting post and code Keep reading our blogs
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…
Hope this code and post will helped you for implement Laravel 5 – “syntax error or access violation 1055 in group by” Solved. if you need any help or any feedback give it in comment section or you have good idea about this post you can give it comment section. Your comment will help us for help you more and improve us. we will give you this type of more interesting post in featured also so, For more interesting post and code Keep reading our blogs