https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=38606 Bug ID: 38606 Summary: Suggestion title search returns 500 error Change sponsored?: --- Product: Koha Version: 23.11 Hardware: All OS: All Status: NEW Severity: minor Priority: P5 - low Component: Acquisitions Assignee: koha-bugs@lists.koha-community.org Reporter: jonathan.field@ptfs-europe.com QA Contact: testopia@bugs.koha-community.org If you create a basket and add an orderline from a suggestion, you get a suggestions search bar at the top which allows you to search by title, author and publisher. Author and publisher search fine but title returns a 500 error. The logs suggest the title in the SQL query is not unique DBIx::Class::Storage::DBI::_dbh_execute(): DBI Exception: DBD::mysql::st execute failed: Column 'title' in where clause is ambiguous at /usr/share/koha/lib/Koha/Objects.pm line 401 title is, of course, in both the suggestions table and the borrowers table, the query doesn't seem to make this distinction. -- You are receiving this mail because: You are the assignee for the bug. You are watching all bug changes.