Bug 29134: (follow-up) Specify which borrowernumber
authorNick Clemens <nick@bywatersolutions.com>
Fri, 8 Oct 2021 14:42:48 +0000 (14:42 +0000)
committerKyle M Hall <kyle@bywatersolutions.com>
Tue, 26 Oct 2021 12:42:42 +0000 (08:42 -0400)
commitda3d5c958fa228289938dd2bbed369f03c03e9fb
tree46209ed6f529134e691e187e5acc7b5d287cb266
parentbf1275b959a8e6907a5cea63e408eeccd2d2acb7
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!
C4/Utils/DataTables/Members.pm