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@lists.koha-community.org Reporter: aleisha@catalyst.net.nz QA Contact: testopia@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.