From 16249f5067b95b7e4d493079a7739ea0ac8a5bf9 Mon Sep 17 00:00:00 2001 From: Katrin Fischer Date: Sat, 6 Apr 2019 10:19:14 +0000 Subject: [PATCH] Bug 22648: Fix typo in SQL in smart-rules.pl Fixes 2 SQL statements for setting the maximum number of checkouts possible. To test: - In 18.11 - Verify that setting Default checkout, hold and return policy works - Verfiy that setting Default checkout, ohld and return policy by patron category works Signed-off-by: Martin Renvoize --- admin/smart-rules.pl | 4 ++-- 1 file changed, 2 insertions(+), 2 deletions(-) diff --git a/admin/smart-rules.pl b/admin/smart-rules.pl index fcb5b7efb1..5cba4e2152 100755 --- a/admin/smart-rules.pl +++ b/admin/smart-rules.pl @@ -317,7 +317,7 @@ elsif ($op eq "add-branch-cat") { my $sth_update = $dbh->prepare(q| UPDATE default_circ_rules SET maxissueqty = ?, - maxonsiteissueqty = ?, + maxonsiteissueqty = ? |); $sth_search->execute(); @@ -349,7 +349,7 @@ elsif ($op eq "add-branch-cat") { my $sth_update = $dbh->prepare(q| UPDATE default_borrower_circ_rules SET maxissueqty = ?, - maxonsiteissueqty = ?, + maxonsiteissueqty = ? WHERE categorycode = ? |); $sth_search->execute($categorycode); -- 2.20.1