From 4eea3585b1e6a183e3fdcd6d163060813356c130 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 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 Signed-off-by: Nick Clemens --- 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 1279c4acc0..eb4ef7b54f 100755 --- a/admin/smart-rules.pl +++ b/admin/smart-rules.pl @@ -306,7 +306,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.39.2