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: [email protected]
Reporter: [email protected]
QA Contact: [email protected]
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.
_______________________________________________
Koha-bugs mailing list
[email protected]
http://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-bugs
website : http://www.koha-community.org/
git : http://git.koha-community.org/
bugs : http://bugs.koha-community.org/
