[Bug 16584] New: All SQL queries should be compatible to 'ONLY_FULL_GROUP_BY'.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=16584 Bug ID: 16584 Summary: All SQL queries should be compatible to 'ONLY_FULL_GROUP_BY'. Change sponsored?: --- Product: Koha Version: 3.22 Hardware: All OS: All Status: NEW Severity: enhancement Priority: P5 - low Component: Database Assignee: gmcharlt@gmail.com Reporter: ngson2000@yahoo.com QA Contact: testopia@bugs.koha-community.org As the mode 'ONLY_FULL_GROUP_BY' is ON by default on MySQL 5.7, non ONLY_FULL_GROUP_BY queries in Koha will be rejected. This caused several issue including the error when adding a new patron even the patron categories exist. -- You are receiving this mail because: You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=16584 Katrin Fischer <katrin.fischer@bsz-bw.de> changed: What |Removed |Added ---------------------------------------------------------------------------- CC| |gk.bmsit@gmail.com --- Comment #1 from Katrin Fischer <katrin.fischer@bsz-bw.de> --- *** Bug 16564 has been marked as a duplicate of this bug. *** -- You are receiving this mail because: You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=16584 Jonathan Druart <jonathan.druart@bugs.koha-community.org> changed: What |Removed |Added ---------------------------------------------------------------------------- CC| |jonathan.druart@bugs.koha-c | |ommunity.org -- You are receiving this mail because: You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=16584 Katrin Fischer <katrin.fischer@bsz-bw.de> changed: What |Removed |Added ---------------------------------------------------------------------------- CC| |katrin.fischer@bsz-bw.de Resolution|--- |DUPLICATE Status|NEW |RESOLVED Version|3.22 |master --- Comment #2 from Katrin Fischer <katrin.fischer@bsz-bw.de> --- Marking this duplicate to the omnibus bug for supporting newer MySQL versions. *** This bug has been marked as a duplicate of bug 17258 *** -- You are receiving this mail because: You are watching all bug changes.
participants (1)
-
bugzilla-daemon＠bugs.koha-community.org