Bug 23029 - Add authority type GEN_SUBDIV
Summary: Add authority type GEN_SUBDIV
Status: NEW
Alias: None
Product: Koha
Classification: Unclassified
Component: Searching (show other bugs)
Version: Main
Hardware: All All
: P5 - low enhancement (vote)
Assignee: Bugs List
QA Contact: Testopia
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2019-05-31 19:52 UTC by Craig
Modified: 2019-12-07 10:32 UTC (History)
2 users (show)

See Also:
Change sponsored?: ---
Patch complexity: ---
Documentation contact:
Documentation submission:
Text to go in the release notes:
Version(s) released in:


Attachments
Bug 23029: Remove "Truncated incorrect DOUBLE value: '01e'" from marcrecord2csv.t (1.47 KB, patch)
2019-11-13 09:52 UTC, Jonathan Druart
Details | Diff | Splinter Review

Note You need to log in before you can comment on or make changes to this bug.
Description Craig 2019-05-31 19:52:26 UTC
Koha 18.11 on Ubuntu 16.04 (MariaDb) with Plack.
================================================

I recently discovered that the Library of Congress released their 2014 authorities as a free, open-access dataset in Marc8, xml, and Utf8 formats. This is great! (https://www.loc.gov/cds/products/MDSConnect-subject_authorities.html)

I have completed batch uploading the file successfully into Koha (about 320,000 records) and reindexed Zebra.

Part of the authority file includes free-floating subdivisions, identified by the presence of a MARC21 authority tag 180.

I discovered an "Internal Server Error" page if I attempted to click on the Details button of any of these sub-divisions' records in the OPAC authority browse results page. My Plack error log reported the following error each time I attempted to access the authorities details page from the OPAC:

"Can't call method "authtypetext" on an undefined value at /usr/share/koha/opac/cgi-bin/opac/opac-authoritiesdetail.pl line 89."

I corrected this error by creating a new Authority Type using the pre-populated value found in field 942 within these free-floating subdivision records (i.e., "GEN_SUBDIV") and assigning tag 180 as the "authority field to copy"

Once created, I was able to access the OPAC details page, as expected, and all free-floating subdivisions were re-indexed as free-floating subdivisions. They also became selectable as an authority type from the drop-down menu in the Authority Search.

For a detailed explanation of the above, see: http://craigbutosi.ca/2019/05/31/plack-error-authority-file-free-floating-subdivisions-koha-18-11/

The Authority Type GEN_SUBDIV should be defined in order to prevent the Plack error from occurring.
Comment 1 Jonathan Druart 2019-11-13 09:52:30 UTC
Created attachment 95354 [details] [review]
Bug 23029: Remove "Truncated incorrect DOUBLE value: '01e'" from marcrecord2csv.t

marc_subfield_structure.tagfield is a varchar(3)
Comment 2 Jonathan Druart 2019-12-03 08:39:37 UTC
Comment on attachment 95354 [details] [review]
Bug 23029: Remove "Truncated incorrect DOUBLE value: '01e'" from marcrecord2csv.t

Wrong bug report, that was for bug 24029.