php - SQLSTATE[42000] : Syntax error or access violation: 1055

Question

我正在使用 Laravel 5.5 我添加了这个依赖项来制作简单的搜索引擎

https://github.com/nicolaslopezj/searchable

但是当我尝试搜索任何东西时遇到问题

SQLSTATE[42000]: Syntax error or access violation: 1055 'myreview.movies.name' isn't in GROUP BY (SQL: select count() as aggregate from (select movies., max((case when LOWER(movies.name) LIKE car then 150 else 0 end) + (case when LOWER(movies.name) LIKE car% then 50 else 0 end) + (case when LOWER(movies.name) LIKE %car% then 10 else 0 end) + (case when LOWER(movies.description) LIKE car then 150 else 0 end) + (case when LOWER(movies.description) LIKE car% then 50 else 0 end)

我已经尝试过更改 mysql 数据库更改为 mysql 5.7 后，我正在使用 mariadb 10.2，它工作正常

但我的 cpanel 服务器上有 mariadb

帮我看看这个谢谢

Answer 1

1. 打开config/database.php

2. 将值 strict 从 true 更改为 false

   'mysql' => [
       'driver' => 'mysql',
       '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' => '',
       'strict' => false,
       'engine' => null,
   ],
   

3. 保存

您可以在我的帖子中阅读全文=> How to Fix SQLSTATE[42000]: Syntax error or access violation: 1055