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
Senior Software Engineer at Cotocus pvt Ltd
Hi I am Rakesh Experienced Web Developer with a demonstrated history of working in the information technology and services industry.
Latest posts by Rakesh K (see all)
- Laravel Error:Integrity constraint violation - May 22, 2021
- Call to a member function createtoken() on null - May 14, 2021
- How to Store Multiple Records using Checkbox in Laravel? - May 12, 2021