Bug 41406

Summary: Error when accessing MARC structure for a new authority type
Product: Koha Reporter: David Nind <david>
Component: CatalogingAssignee: Bugs List <koha-bugs>
Status: NEW --- QA Contact: Testopia <testopia>
Severity: normal    
Priority: P5 - low CC: m.de.rooy
Version: Main   
Hardware: All   
OS: All   
GIT URL: Initiative type: ---
Sponsorship status: --- Comma delimited list of Sponsors:
Crowdfunding goal: 0 Patch complexity: ---
Documentation contact: Documentation submission:
Text to go in the release notes:
Version(s) released in:
Circulation function:

Description David Nind 2025-12-08 19:56:31 UTC
I get this error after creating a new authority type and going to Actions > MARC structure (for a MARC21 instance):
 CGI::Compile::ROOT::kohadevbox_koha_admin_auth_tag_structure_2epl::auth_tag_structure_2epl(): DBI Exception: DBD::mysql::st execute failed: 'koha_kohadev.auth_types.authtypetext' isn't in GROUP BY at /usr/share/perl5/CGI/Emulate/PSGI.pm line 30
 at /usr/share/perl5/DBIx/Class/Exception.pm line 77

Steps to reproduce:
1. Go to Koha administration > Catalog > Authority types
2. Create a new authority type:
   - + New authority type
   - Authority type: anything, for example: MYAUTHTYPE
   - Description: anything, for example: A new authority type
   - Summary: no text required
   - Authority field to copy: 100 (same as used by Personal Name authority type)
3. For the new authority framework, select Actions > MARC structure
4. You get the error above
5. Note that I can export an existing authority type and then import it into the new authority type, then Actions > MARC structure works