MySQL 5.7.5 (or Higher) Compatibility

[syabah]

Jika menggunakan MySQL 5.7.5 ke atas, muncul error pada modul "Sirkulasi > Daftar Keterlambatan".

ERROR
MySQL Server said : Expression #1 of ORDER BY clause is not in GROUP BY clause and contains nonaggregated column 'manggisid_perpus.l.due_date' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by

[slims]

versi php yang digunakan?SLiMS | library automation with styleOn Jan 23, 2017 17:53, Syaiful Bachri <notifications@github.com> wrote:Jika menggunakan MySQL 5.7.5 ke atas, muncul error pada modul "Sirkulasi > Daftar Keterlambatan". ERROR MySQL Server said : Expression #1 of ORDER BY clause is not in GROUP BY clause and contains nonaggregated column 'manggisid_perpus.l.due_date' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by —You are receiving this because you are subscribed to this thread.Reply to this email directly, view it on GitHub, or mute the thread.

[syabah]

PHP yang digunakan versi 5.5. Dicoba hingga PHP 7.0 tetap berjalan dengan lancar selama MySQL tetap menggunakan versi 5.6.

[slims]

terima kasih, akan kami jadikan catatan.SLiMS | library automation with styleOn Jan 23, 2017 7:56 PM, Syaiful Bachri <notifications@github.com> wrote:PHP yang digunakan versi 5.5. Dicoba hingga PHP 7.0 tetap berjalan dengan lancar selama MySQL tetap menggunakan versi 5.6. —You are receiving this because you commented.Reply to this email directly, view it on GitHub, or mute the thread.

[sutriadi]

Mohon informasi OS yang dipakai berserta versi dan arsitekturnya, juga untuk versi arsitektur masing-masing aplikasi pendukung (webserver, database dan php).

[syabah]

OS: Ubuntu 16.04
PHP: v7.0
DB: MySQL 5.7.5