How can I solve incompatible with sql_mode=only_full_group_by in laravel eloquent?

I had a similar Problem and solved it by disabling mysql strict mode in the database connection setting.

'connections' => [
    'mysql' => [
        // Behave like MySQL 5.6
        'strict' => false,

        // Behave like MySQL 5.7
        'strict' => true,
    ]
]

You can find even more configuration settings in this blog post by Matt Stauffer

Related Contents:

  1. Laravel 5.2 – Use a String as a Custom Primary Key for Eloquent Table becomes 0
  2. How to do this in Laravel, subquery where in
  3. Laravel 5 PDOException Could Not Find Driver [duplicate]
  4. Laravel Check If Related Model Exists
  5. How can I convert many statement mysql to laravel eloquent?
  6. How Can I Set the Default Value of a Timestamp Column to the Current Timestamp with Laravel Migrations?
  7. Laravel-5 ‘LIKE’ equivalent (Eloquent)
  8. Laravel Model with Two Primary Keys update [duplicate]
  9. Laravel 5.4 on PHP 7.0: PDO Exception – Could not find driver (MySQL)
  10. Laravel OrderBy relationship count
  11. Merge ‘with’ and ‘whereHas’ in Laravel 5
  12. Laravel Checking If a Record Exists
  13. Laravel $q->where() between dates
  14. Laravel 5 hasMany relationship on two columns
  15. Laravel 5.5 Error Base table or view already exists: 1050 Table ‘users’ already exists
  16. Difference between Eloquent\Model::get() and all()
  17. SQLSTATE[HY000] [2002] php_network_getaddresses: getaddrinfo failed: nodename nor servname provided, or not known
  18. PDOException “could not find driver”
  19. Best way to INSERT many values in mysqli?
  20. Using PHP 5.5’s password_hash and password_verify function
  21. PHP code to convert a MySQL query to CSV [closed]
  22. Best way to avoid duplicate entry into mysql database
  23. Get the Last Inserted Id Using Laravel Eloquent
  24. Bulk Insertion in Laravel using eloquent ORM
  25. Running MySQL *.sql files in PHP
  26. I need my PHP page to show my BLOB image from mysql database
  27. How to retract a salted password from the Database and auth user?
  28. How can I properly use a PDO object for a parameterized SELECT query
  29. How to insert multiple rows from a single query using eloquent/fluent
  30. mysqli_stmt::bind_param(): Number of elements in type definition string doesn’t match number of bind variables
  31. I cannot get my login form to connect interact properly with mySQL database [closed]
  32. How to search for slash (\) in MySQL? and why escaping (\) not required for where (=) but for Like is required?
  33. displaying an image stored in a mysql blob
  34. Geo-Search (Distance) in PHP/MySQL (Performance)
  35. Warning: mysqli_query() expects parameter 1 to be mysqli, resource given [duplicate]
  36. Concatenating a string and primary key Id while inserting
  37. PHP – Secure member-only pages with a login system
  38. How to bind parameters to a raw DB query in Laravel that’s used on a model?
  39. “Warning: Cannot modify header information – headers already sent by” error [duplicate]
  40. Using LIKE in bindParam for a MySQL PDO Query [duplicate]
  41. Do SQL connections opened with PDO in PHP have to be closed
  42. Calculating distance between zip codes in PHP
  43. How to store NULL values in datetime fields in MySQL?
  44. MySQL retrieve variable from Stored Procedure in PHP PDO
  45. Laravel password validation rule
  46. Warning: PDO::__construct(): [2002] No such file or directory (trying to connect via unix:///tmp/mysql.sock) in
  47. double results in my array ( mysql_fetch_array )
  48. #1193 – Unknown system variable ‘lc_messages’ when trying to login to phpmyadmin
  49. Laravel Eloquent update just if changes have been made
  50. How can I employ “if exists” for creating or dropping an index in MySQL?

Leave a Comment