php – 升级到laravel 5.3之后不工作的组

发布时间：2020-12-14 19:36:21 所属栏目：大数据来源：网络整理

导读：这是在laravel 5.2上运行的代码 $menus = CmsMenuItem::groupBy('menu_id')-get(); 但现在它抛出了错误 SQLSTATE[42000]: Syntax error or access violation: 1055 Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated colu

这是在laravel 5.2上运行的代码

$menus = CmsMenuItem::groupBy('menu_id')->get();

但现在它抛出了错误

SQLSTATE[42000]: Syntax error or access violation: 1055 Expression #1
of SELECT list is not in GROUP BY clause and contains nonaggregated
column ‘convertifier_cms.cms_menu_items.id’ which is not functionally
dependent on columns in GROUP BY clause; this is incompatible with
sql_mode=only_full_group_by (SQL: select * from ‘cms_menu_items’ group
by ‘menu_id’)

我也试过了

`strict => false`

在database.php但没有效果

解决方法

试试这个数据库配置.

'mysql' => [
            'driver' => 'mysql','host' => env('DB_HOST','localhost'),'port' => env('DB_PORT','3306'),'database' => env('DB_DATABASE','forge'),'username' => env('DB_USERNAME','password' => env('DB_PASSWORD',''),'charset' => 'utf8','collation' => 'utf8_unicode_ci','prefix' => '','strict' => false,'engine' => null,],

并以这种方式使用查询

$menus =DB::table('cms_menu_item')
    ->select('*')
    ->groupBy('menu_id')
    ->get();

（编辑：李大同）

【声明】本站内容均来自网络，其相关言论仅代表作者个人观点，不代表本站立场。若无意侵犯到您的权利，请及时与联系站长删除相关内容!