Eloquent groupBy make “SQLSTATE[42000]” with valid SQL query in Laravel 5.3

by

Faced same problem with laravel 5.3
They are trying to enforce strict query writing came with mysql-5.7

However to disabled this just go to config/database.php and change strict flag

'mysql' => [
            .
            .
            .
            'strict' => false,
            //'strict' => true,
            .
            .
        ],

Hope this will solve your problem too.

PS – For details on strict query writing refer to @Shadow’s answer

More Related Contents:

  1. Laravel 5.2 – Use a String as a Custom Primary Key for Eloquent Table becomes 0
  2. Laravel one to many relation with a one to one relation
  3. How to do this in Laravel, subquery where in
  4. Laravel 5 PDOException Could Not Find Driver
  5. Laravel Check If Related Model Exists
  6. How can I convert many statement mysql to laravel eloquent?
  7. Laravel Model with Two Primary Keys update [duplicate]
  8. Laravel OrderBy relationship count
  9. Laravel Checking If a Record Exists
  10. Laravel 5 hasMany relationship on two columns
  11. Laravel $q->where() between dates
  12. How Can I Set the Default Value of a Timestamp Column to the Current Timestamp with Laravel Migrations?
  13. Laravel 5.4 on PHP 7.0: PDO Exception – Could not find driver (MySQL)
  14. Difference between Eloquent\Model::get() and all()
  15. SQLSTATE[HY000] [2002] php_network_getaddresses: getaddrinfo failed: nodename nor servname provided, or not known
  16. Eloquent Parent-Child relationship on same model
  17. Eloquent many-to-many-to-many – how to load distant relation easily
  18. Merge ‘with’ and ‘whereHas’ in Laravel 5
  19. find in set in laravel ? example
  20. Laravel 5.1, Return response to user, then excute some code [closed]
  21. Laravel – only a zero is saved to the database
  22. How to pass data to all views in Laravel 5?
  23. How to change / Custom password field name for Laravel 4 and Laravel 5 user authentication [duplicate]
  24. How to set a default attribute value for a Laravel / Eloquent model?
  25. Order By before Group By using Eloquent (Laravel)
  26. Laravel Socialite: InvalidStateException
  27. Laravel Eloquent get results grouped by days
  28. required_if Laravel 5 validation
  29. Login only if user is active using Laravel
  30. laravel 5 : Class ‘input’ not found

Leave a Comment