Mengatasi Laravel Syntax error or access violation: 1055

[Illuminate\Database\QueryException]

SQLSTATE[42000]: Syntax error or access violation: 1055 'kredit_analisa.p_pengajuan.pokok_pinjaman' isn't in GROUP BY (SQL: select `p_pengajuan`.* from `p_pengajuan` inner join `p_status` on `p_status`.`pengajuan_id` = `p_pengajuan`.`id` and `p_status`.`status` = survei and `p_status`.`deleted_at` is null left join p_status as p_status_now on `p_status_now`.`pengajuan_id` = `p_pengajuan`.`id` and `p_status`.`tanggal` < `p_status_now`.`tanggal` and `p_status_now`.`deleted_at` is null where `p_status_now`.`tanggal` is null and `p_pengajuan`.`deleted_at ` is null group by `p_pengajuan`.`id` limit 0 offset 0)

[PDOException]SQLSTATE[42000]: Syntax error or access violation: 1055 'kredit_analisa.p_pengajuan.pokok_pinjaman' isn't in GROUP BY

Cara :

nonaktifkan strict mode di driver MySQL Laravel. Buka file config/database.php
ubah

'strict' => true,

menjadi

'strict' => false,

Location: Merauke, Kec. Merauke, Kabupaten Merauke, Papua, Indonesia

Berbagi :