From df90cce970769d368c222b3fe69409572c7da27b Mon Sep 17 00:00:00 2001 From: Kyle M Hall Date: Mon, 4 Jan 2021 08:12:25 -0500 Subject: [PATCH] Bug 27276: Fix syntax error Signed-off-by: Kyle M Hall Signed-off-by: Jonathan Druart (cherry picked from commit 4f112b782b706d906fb39dd0d7a708f7d12da45f) Signed-off-by: Fridolin Somers (cherry picked from commit 289068c0d5c6ea8a45551a27aa8075d59ed6e759) Signed-off-by: Andrew Fuerste-Henry (cherry picked from commit 9a1447ac2b2868f2d813af98f3d4afb2118c4249) Signed-off-by: Victor Grousset/tuxayo --- misc/maintenance/borrowers-force-messaging-defaults.pl | 3 ++- 1 file changed, 2 insertions(+), 1 deletion(-) diff --git a/misc/maintenance/borrowers-force-messaging-defaults.pl b/misc/maintenance/borrowers-force-messaging-defaults.pl index c9a1ef727f..0e30596879 100755 --- a/misc/maintenance/borrowers-force-messaging-defaults.pl +++ b/misc/maintenance/borrowers-force-messaging-defaults.pl @@ -50,7 +50,8 @@ sub force_borrower_messaging_defaults { my $sql = q|SELECT DISTINCT bo.borrowernumber, bo.categorycode FROM borrowers bo LEFT JOIN borrower_message_preferences mp USING (borrowernumber) -WHERE 1| +WHERE 1|; + if ( $since ) { $sql .= " AND bo.dateenrolled >= ?"; } -- 2.39.2