From 34e746227f67c976e0c1babe7d21d60afce14d94 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 --- 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.24.1 (Apple Git-126)