https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=44120 Bug ID: 44120 Summary: admin/auth_tag_structure.pl fails with ONLY_FULL_GROUP_BY when creating the structure of an authority type Initiative type: --- Sponsorship --- status: Product: Koha Version: Main Hardware: All OS: All Status: NEW Severity: normal Priority: P5 - low Component: MARC Authority data support Assignee: koha-bugs@lists.koha-community.org Reporter: martin.renvoize@openfifth.co.uk QA Contact: testopia@bugs.koha-community.org Target Milestone: --- Creating the MARC structure of an authority type that has none yet (Administration > Authority types > MARC structure) fails with: DBI Exception: DBD::mysql::st execute failed: 'koha_kohadev.auth_types.authtypetext' isn't in GROUP BY The page lists the existing structures to copy from, with this query in admin/auth_tag_structure.pl (op authtype_create): select count(*),auth_tag_structure.authtypecode,authtypetext from auth_tag_structure,auth_types where auth_types.authtypecode=auth_tag_structure.authtypecode group by auth_tag_structure.authtypecode It selects authtypetext but only groups by authtypecode, which is rejected when the SQL mode includes ONLY_FULL_GROUP_BY. That is the case with strict_sql_modes set to 1 in koha-conf.xml, the default of KTD. To reproduce: 1. Use an instance with strict_sql_modes = 1 2. Add an authority type in Administration > Authority types 3. Click on its MARC structure Found while testing bug 40883 (see comment 5). -- You are receiving this mail because: You are the assignee for the bug. You are watching all bug changes.