[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

Jonathan Druart <jonathan.druart+koha at gmail.com> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
           Keywords|additional_work_needed      |

--- Comment #16 from Jonathan Druart <jonathan.druart+koha at gmail.com> ---
(In reply to Nick Clemens from comment #14)
> Created attachment 125978 [details] [review]
> 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!

Pushed to master.

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