]> git.koha-community.org Git - koha.git/commit
Bug 29134: (follow-up) Specify which borrowernumber
authorNick Clemens <nick@bywatersolutions.com>
Fri, 8 Oct 2021 14:42:48 +0000 (14:42 +0000)
committerFridolin Somers <fridolin.somers@biblibre.com>
Tue, 26 Oct 2021 06:09:40 +0000 (20:09 -1000)
commit591ffce832f061f46d2ef642898f5891c0fe7827
tree47e257e0f1c36492a7eaf671d3b79d316fcb8d00
parentbf620d629ad5f781bcfa1e7d0086ed278764cb06
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!

Signed-off-by: Jonathan Druart <jonathan.druart@bugs.koha-community.org>
Signed-off-by: Fridolin Somers <fridolin.somers@biblibre.com>
C4/Utils/DataTables/Members.pm