https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=25335 Bug ID: 25335 Summary: Use of an authorised value in a marc subfield causes strict mode SQL error Change sponsored?: --- Product: Koha Version: master Hardware: All OS: All Status: NEW Severity: major Priority: P5 - low Component: Cataloging Assignee: koha-bugs@lists.koha-community.org Reporter: andrew@bywatersolutions.com QA Contact: testopia@bugs.koha-community.org CC: m.de.rooy@rijksmuseum.nl To recreate: - Edit your default framework, connect any subfield outside of the 952 to an authorised value (for example, connect the 942$n to the Yes_No auth value) - Find a record in that framework - Edit the record and find your subfield - The subfield shows a dropdown with no contents - check plack log, see "DBD::mysql::st execute failed: 'koha_kohadev.authorised_values.authorised_value' isn't in GROUP BY " -- You are receiving this mail because: You are watching all bug changes. You are the assignee for the bug.