https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=44120 --- Comment #1 from Martin Renvoize (ashimema) <martin.renvoize@openfifth.co.uk> --- Created attachment 211675 --> https://bugs.koha-community.org/bugzilla3/attachment.cgi?id=211675&action=edit Bug 44120: Fix the GROUP BY of the query listing the authority frameworks to copy Creating the MARC structure of an authority type that has none yet lists the existing structures to copy from. The query selected auth_types.authtypetext but only grouped by the authtypecode, which fails with "'auth_types.authtypetext' isn't in GROUP BY" when the SQL mode includes ONLY_FULL_GROUP_BY, which is the case with strict_sql_modes. Group by the authtypetext too. To test: 1. Make sure strict_sql_modes is 1 in koha-conf.xml (the KTD default) 2. Add an authority type in Administration > Authority types 3. Click on its MARC structure: without the patch the page fails with "'auth_types.authtypetext' isn't in GROUP BY", with it you can choose the structure to copy 4. cypress run --spec t/cypress/integration/Admin/AuthTagStructure_spec.ts -- You are receiving this mail because: You are watching all bug changes. You are the assignee for the bug.