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.