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

by

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

More Related Contents:

  1. Laravel 5 PDOException Could Not Find Driver
  2. Laravel-5 ‘LIKE’ equivalent (Eloquent)
  3. Laravel 5.2 – Use a String as a Custom Primary Key for Eloquent Table becomes 0
  4. Laravel 5.5 Error Base table or view already exists: 1050 Table ‘users’ already exists
  5. How Can I Set the Default Value of a Timestamp Column to the Current Timestamp with Laravel Migrations?
  6. Laravel 5.4 on PHP 7.0: PDO Exception – Could not find driver (MySQL)
  7. SQLSTATE[HY000] [2002] php_network_getaddresses: getaddrinfo failed: nodename nor servname provided, or not known
  8. How can I do a migration in laravel 5.5?
  9. laravel 5.3 new Auth::routes()
  10. CONCAT columns with Laravel 5 eloquent
  11. Eloquent groupBy make “SQLSTATE[42000]” with valid SQL query in Laravel 5.3
  12. find in set in laravel ? example
  13. Just using mysql real escape string [closed]
  14. Many-to-many relationships examples
  15. Storing files in database Vs file system
  16. Laravel 5 – redirect to HTTPS
  17. MySQL Join two tables with comma separated values
  18. Laravel Request::all() Should Not Be Called Statically
  19. How to connect to MySQL database in PHP using mysqli extension?
  20. MySQL – Access denied for user [duplicate]
  21. Calling stored procedure with Out parameter using PDO
  22. When *not* to use prepared statements?
  23. How to display an BLOB image stored in MySql database?
  24. Warning: PDO::__construct(): [2002] No such file or directory (trying to connect via unix:///tmp/mysql.sock) in
  25. PHP 7 RC3: How to install missing MySQL PDO
  26. Using utf8mb4 with php and mysql
  27. how do I get month from date in mysql
  28. Can I detect and handle MySQL Warnings with PHP?
  29. How to write a stored procedure in phpMyAdmin?
  30. mysql count into PHP variable

Leave a Comment