Bug 29134: (follow-up) Specify which borrowernumber
authorNick Clemens <nick@bywatersolutions.com>
Fri, 8 Oct 2021 14:42:48 +0000 (14:42 +0000)
committerJonathan Druart <jonathan.druart@bugs.koha-community.org>
Fri, 8 Oct 2021 14:48:22 +0000 (16:48 +0200)
commit67ead5e7aef49f44b4744f8a85a35a28931b10d9
tree8b62cfddd8188ced4666e72c140b6046bdd56fa5
parent5eca355cbc37d44fc9eeefeacb777d59dc1c7a1e
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>
C4/Utils/DataTables/Members.pm