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@gmail.com Reporter: dswhite42@yahoo.com QA Contact: testopia@bugs.koha-community.org CC: m.de.rooy@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.