[Koha-bugs] [Bug 30677] Unknown column 'biblioitem.title' in 'where clause' 500 error in API /api/v1/acquisitions/orders

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

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

--- Comment #1 from Andrew Nugged <nugged at gmail.com> ---
Created attachment 134612
  -->
https://bugs.koha-community.org/bugzilla3/attachment.cgi?id=134612&action=edit
Bug 30677: Make s/// change only proper strings.

To reproduce / test:

1. List form Test Koha all available acquisitions orders
   https://koha-kktest.lib.helsinki.fi/cgi-bin/koha/acqui/histsearch.pl
   with any (empty) search request to list them all,
2. open browser's JS console, to see Ajax errors (500),
   or run in parallel 'tail -F -n0 /var/log/koha/*/*-error.log',
3. start typing in Search field to sub-filter-out ajax-generated
   search results any existing word in orders below,
4. see that search dies with (in log: 

       [ERROR] GET /api/v1/acquisitions/orders: unhandled exception
(DBIx::Class::Exception)<<DBIx::Class::Storage::DBI::_dbh_execute(): DBI
Exception: DBD::mysql::st execute failed: Unknown column 'biblioitem.title' in
'where clause'

5. apply the patch,
6. start typing in Search field to sub-filter-out ajax-generated
   search results: it should filter our what you want.

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