[Koha-bugs] [Bug 31193] New: API error when receiving orders
bugzilla-daemon at bugs.koha-community.org
bugzilla-daemon at bugs.koha-community.org
Wed Jul 20 07:34:28 CEST 2022
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=31193
Bug ID: 31193
Summary: API error when receiving orders
Change sponsored?: ---
Product: Koha
Version: 21.11
Hardware: All
OS: All
Status: NEW
Severity: minor
Priority: P5 - low
Component: Acquisitions
Assignee: koha-bugs at lists.koha-community.org
Reporter: aleisha at catalyst.net.nz
QA Contact: testopia at bugs.koha-community.org
We've noticed that when receiving orders, we can't seem to filter the results
using the search boxes in the pending orders table.
When we type in the 'summary search' filter for example, this error shows in
the console:
GET
https://toi-ohomai-admin.test.mykoha.co.nz/api/v1/acquisitions/orders?only_active=1&_page=1&_per_page=20&_match=contains&_order_by=+basket.name
[HTTP/1.1 500 Internal Server Error 173ms]
DataTables warning: table id=pending_orders - Ajax error. For more information
about this error, please see http://datatables.net/tn/7
And the API error log shows:
[2022/07/20 16:02:28] [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' at /usr/share/perl5/Data/Page.pm line 50>>
Koha::REST::Plugin::Exceptions::ANON
/usr/share/koha/lib/Koha/REST/Plugin/Exceptions.pm (73)
The biblioitem.title field doesn't exist. I imagine this is something to do
with the code in Koha/REST/V1/Acquisitions/Orders.pm
Can anyone else reproduce this bug? Do we know a fix?
--
You are receiving this mail because:
You are the assignee for the bug.
You are watching all bug changes.
More information about the Koha-bugs
mailing list