Bug 41406 - Error when accessing MARC structure for a new authority type
Summary: Error when accessing MARC structure for a new authority type
Status: NEW
Alias: None
Product: Koha
Classification: Unclassified
Component: Cataloging (show other bugs)
Version: Main
Hardware: All All
: P5 - low normal
Assignee: Bugs List
QA Contact: Testopia
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2025-12-08 19:56 UTC by David Nind
Modified: 2025-12-08 19:56 UTC (History)
1 user (show)

See Also:
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:


Attachments

Note You need to log in before you can comment on or make changes to this bug.
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