[Koha-bugs] [Bug 17831] New: Item Search fails on custom subject search field

[bugzilla-daemon at bugs.koha-community.org]

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=17831

            Bug ID: 17831
           Summary: Item Search fails on custom subject search field
 Change sponsored?: ---
           Product: Koha
           Version: master
          Hardware: All
                OS: All
            Status: NEW
          Severity: normal
          Priority: P5 - low
         Component: Searching
          Assignee: gmcharlt at gmail.com
          Reporter: nick at bywatersolutions.com
        QA Contact: testopia at bugs.koha-community.org

If I add an Item Search Field:
    Name: Subj
    Label: Subj Head
    MARC field: 650
    MARC subfield: a
    Auth values: N/A

I get an error when doing the item search:
DBD::mysql::st execute failed: Unknown column 'bibliosubject.subject' in 'where
clause' [for Statement "
        SELECT SQL_CALC_FOUND_ROWS items.*
        FROM items
          LEFT JOIN biblio ON biblio.biblionumber = items.biblionumber
          LEFT JOIN biblioitems ON biblioitems.biblioitemnumber =
items.biblioitemnumber
          LEFT JOIN biblio_metadata ON biblio_metadata.biblionumber =
biblio.biblionumber
          WHERE 1
     AND (bibliosubject.subject like ?)  AND biblio_metadata.format = 'marcxml'
AND biblio_metadata.marcflavour = ?  ORDER BY title ASC  LIMIT ?, ? " with
ParamValues: 0="juvnile%", 1='MARC21', 2=0, 3=20] at
/home/vagrant/kohaclone/C4/Items.pm line 2798.

-- 
You are receiving this mail because:
You are watching all bug changes.