How to fix syntax error or access violation while use Group by

above error appear if you apply groupby in controller function is given below figure

Solution 1:In config/database.php at “mysql” change : ‘strict’ => true, to false

reference :https://stackoverflow.com/questions/49635699/laravel-distinct-on-join-results-not-working-in-query-builder

now Your bug resolved

Rakesh K
Tagged : /
0 0 votes
Article Rating
Subscribe
Notify of
guest

0 Comments
Inline Feedbacks
View all comments
0
Would love your thoughts, please comment.x
()
x