[Koha-bugs] [Bug 29134] Patron search has poor performance when ExtendedAttributes enabled and many attributes match

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

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

--- Comment #14 from Nick Clemens <nick at bywatersolutions.com> ---
Created attachment 125978
  -->
https://bugs.koha-community.org/bugzilla3/attachment.cgi?id=125978&action=edit
Bug 29134: (follow-up) Specify which borrowernumber

When performing a search that includes permissions we need to specify we are
comparing
the borrowers tabnle borrowernumber

To test:
1 - Browse to Admin->Funds
2 - Edit a fund
3 - Click '+ Add users'
4 - Attempt a search, no results
5 - Check plack-error.log
    C4::Utils::DataTables::Members::search(): DBI Exception: DBD::mysql::st
execute failed: Column 'borrowernumber' in IN/ALL/ANY subquery is ambiguous at
/kohadevbox/koha/svc/members/search line 80
6 - Apply patch
7 - Repeat 1-3
8 - search for 'a'
9 - Result!

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