语法错误或访问冲突：1055 'adminlte3.orders.name'不在分组依据中

Question

DB::table('orders')
->select('orders.id','orders.name', 'orders.phone_number', 'orders.payment_type', 'orders.payment_status', 'orders.payment_status','orders.discount','orders.grand_total','orders.viewed','orders.code','orders.created_at', 'orders.shipping_address','orders.delivery_charge', DB::raw('SUM(order_details.unit_price) As unit_price'))
->groupBy('orders.id')
->leftJoin('order_details', 'order_details.order_id', '=', 'orders.id')  
->paginate($request->per_page);

Answer 1

在configdatabase.php中；mysql"；阵列

设置'strict' => false