SQLSTATE[42000]: Syntax error or access violation: 1140 Mixing of GROUP columns (MIN(),MAX(),COUNT(),...) with no GROUP columns is illegal if there is no GROUP BY clause (SQL: select `user_all`.*, GROUP_CONCAT(user_data.userkey SEPARATOR ', ') AS dat from

SQLSTATE[42000]: Syntax error or access violation: 1140 Mixing of GROUP columns (MIN(),MAX(),COUNT(),...) with no GROUP columns is illegal if there is no GROUP BY clause (SQL: select `user_all`.*, GROUP_CONCAT(user_data.userkey SEPARATOR ', ') AS dat from

Comment

0

// Config/Database.php // Change Strict true to false if you are useing any Group Function 'mysql' => [ 'driver' => 'mysql', 'url' => env('DATABASE_URL'), 'host' => env('DB_HOST', '127.0.0.1'), 'port' => env('DB_PORT', '3306'), 'database' => env('DB_DATABASE', 'forge'), 'username' => env('DB_USERNAME', 'forge'), 'password' => env('DB_PASSWORD', ''), 'unix_socket' => env('DB_SOCKET', ''), 'charset' => 'utf8mb4', 'collation' => 'utf8mb4_unicode_ci', 'prefix' => '', 'prefix_indexes' => true, 'strict' => false, 'engine' => null, 'options' => extension_loaded('pdo_mysql') ? array_filter([ PDO::MYSQL_ATTR_SSL_CA => env('MYSQL_ATTR_SSL_CA'), ]) : [], ],

Popularity 4/10 Helpfulness 1/10 Language whatever

Source: Grepper

Tags: clause group group-by mixing select separator syntax-error whatever

Share

Link to this answer
Share Copy Link

Contributed on Mar 22 2024

Mahakal Shyam

0 Answers  Avg Quality 2/10

---

Closely Related Answers

SQLSTATE[42000]: Syntax error or access violation: 1140 Mixing of GROUP columns (MIN(),MAX(),COUNT(),...) with no GROUP columns is illegal if there is no GROUP BY clause

Comment

0

#database.php 'strict' => false after that you can use group by on a single column too.

Popularity 9/10 Helpfulness 3/10 Language sql

Source: Grepper

Tags: clause cl

Share

Link to this answer
Share Copy Link

Contributed on Dec 10 2020

Tyagi420

0 Answers  Avg Quality 2/10

---