[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