From 5855b015430505568a3e2d9da90e3afa06a5abb8 Mon Sep 17 00:00:00 2001 From: Marcel de Rooy Date: Wed, 14 Mar 2018 13:22:46 +0100 Subject: [PATCH] Bug 19454: (QA follow-up) Fix selection on categorycode A follow-up on a preceding report introduced a join instead of a subquery. This made the categorycode ambiguous. Test plan: See former patches. Signed-off-by: Marcel de Rooy Signed-off-by: Katrin Fischer Signed-off-by: Jonathan Druart --- misc/maintenance/borrowers-force-messaging-defaults.pl | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) diff --git a/misc/maintenance/borrowers-force-messaging-defaults.pl b/misc/maintenance/borrowers-force-messaging-defaults.pl index e327834be9..d88d3870e2 100755 --- a/misc/maintenance/borrowers-force-messaging-defaults.pl +++ b/misc/maintenance/borrowers-force-messaging-defaults.pl @@ -57,7 +57,7 @@ WHERE bo.dateenrolled >= ?|; if( $no_overwrite ) { $sql .= " AND mp.borrowernumber IS NULL"; } - $sql .= " AND categorycode = ?" if $category; + $sql .= " AND bo.categorycode = ?" if $category; my $sth = $dbh->prepare($sql); $sth->execute($since, $category || () ); my $cnt = 0; -- 2.39.5