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: [email protected]
          Reporter: [email protected]
        QA Contact: [email protected]

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.
_______________________________________________
Koha-bugs mailing list
[email protected]
https://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/

Reply via email to