https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=21593 --- Comment #1 from Nick Clemens <nick@bywatersolutions.com> --- Created attachment 80800 --> https://bugs.koha-community.org/bugzilla3/attachment.cgi?id=80800&action=edit Bug 21593: Remove GROUP BY from GetAuthValueDropbox With new MYSQL modes we are permitted only full group by. In this case I don't think we need a GROUP BY at all To test: 1 - Try to pay a fine or create a borrower 2 - Internal server error 3 - Apply patch 4 - Page should load 5 - Test various authorised values ot ensure they work e.g. Set bsort1 and bsort2 to have some authorised values with and without branch limits set PAYMENT_TYPE to have some values with and without branch limits -- You are receiving this mail because: You are the assignee for the bug. You are watching all bug changes.