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 ?
I cannot reproduce this problem in master.