[Koha-bugs] [Bug 11745] New: Only one "TOPICS" value shown for 650a
bugzilla-daemon at bugs.koha-community.org
bugzilla-daemon at bugs.koha-community.org
Wed Feb 12 05:55:47 CET 2014
http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=11745
Bug ID: 11745
Summary: Only one "TOPICS" value shown for 650a
Change sponsored?: ---
Product: Koha
Version: 3.14
Hardware: All
OS: All
Status: NEW
Severity: normal
Priority: P5 - low
Component: Cataloging
Assignee: gmcharlt at gmail.com
Reporter: dswhite42 at yahoo.com
QA Contact: testopia at bugs.koha-community.org
CC: m.de.rooy at rijksmuseum.nl
In my "authorised_values" table, I have the following rows with a "category" of
"TOPICS":
Biography
Children
History
Music
Science
For each of these rows, the "lib" value is NULL.
However when I go to Intranet -> Cataloging -> New Record -> Default framework,
go to the "6" tab and look at 650a ("Topical term..."), the dropdown box
contains only a single value, "Biography"
Looking at the SQL that generates this dropdown, I see this:
SELECT authorised_value, lib
FROM authorised_values
LEFT JOIN authorised_values_branches ON ( id = av_id )
WHERE category = 'TOPICS'
AND ( branchcode = 'NO_LIBRARY_SET' OR branchcode IS NULL )
GROUP BY lib
ORDER BY lib, lib_opac
My "authorised_values_branches" table is empty. (This is a database upgrade
from 3.00.00.070, and nothing during the installation process populated that
table). The result of that SQL commmand is to just return the first value
("Biography")
If I remove the "GROUP BY lib" clause, then all TOPICS values will populate the
650a dropdown. (My original Koha 3.00.00.070 did not include that "GROUP BY"
clause in addbiblio.pl)
Is this a bug in addbiblio.pl? Or a problem related to the upgrade from
3.00.00.070 -> 3.14.02.000 ?
--
You are receiving this mail because:
You are watching all bug changes.
More information about the Koha-bugs
mailing list