]> 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)
committerVictor Grousset/tuxayo <victor@tuxayo.net>
Tue, 26 Oct 2021 21:37:23 +0000 (23:37 +0200)
commit1eb9e0393b5429116510710375834bf715d424c3
tree961622e642528abe6c6e637497877fc2de3cede4
parent346898f2b1847cf035ba56dd4d40dbb4f122eaec
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>
(cherry picked from commit 591ffce832f061f46d2ef642898f5891c0fe7827)
Signed-off-by: Victor Grousset/tuxayo <victor@tuxayo.net>
C4/Utils/DataTables/Members.pm