From ec82f25138deeb7c0f2430b668d482510eacbb76 Mon Sep 17 00:00:00 2001 From: Marcel de Rooy Date: Fri, 16 Feb 2018 12:12:12 +0100 Subject: [PATCH] Bug 15524: (QA follow-up) Pass max_holds at the right position in update Content-Type: text/plain; charset=utf-8 When updating max_holds should be before the categorycode in the update query. Things that can be found by testing :) Signed-off-by: Marcel de Rooy --- admin/smart-rules.pl | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) diff --git a/admin/smart-rules.pl b/admin/smart-rules.pl index 3429778..3df93e5 100755 --- a/admin/smart-rules.pl +++ b/admin/smart-rules.pl @@ -304,7 +304,7 @@ elsif ($op eq "add-branch-cat") { $sth_search->execute($categorycode); my $res = $sth_search->fetchrow_hashref(); if ($res->{total}) { - $sth_update->execute( $maxissueqty, $maxonsiteissueqty, $categorycode, $max_holds ); + $sth_update->execute( $maxissueqty, $maxonsiteissueqty, $max_holds, $categorycode ); } else { $sth_insert->execute( $categorycode, $maxissueqty, $maxonsiteissueqty, $max_holds ); } -- 2.1.4