Syntax error or access violation: 1055 'adminlte3.orders.name' isn't in GROUP BY

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);

Or this? https://stackoverflow.com/questions/40917189/laravel-syntax-error-or-access-violation-1055-error — jewishmoses, Jul 11 '20 at 19:03

score 0 · Answer 1 · answered Jul 11 '20 at 18:54

0

In config\database.php, "mysql" array

Set 'strict' => false

answered Jul 11 '20 at 18:54

Kongulov

1,156
2
9
19

A lot of thanks...., Its working – Abdul Mazid Afiq Jul 12 '20 at 03:50
But return 1 row, have multiple row – Abdul Mazid Afiq Jul 12 '20 at 04:10

Syntax error or access violation: 1055 'adminlte3.orders.name' isn't in GROUP BY

1 Answers1