From ac9c72f93c499e47616b1d5a5668481995597d0d Mon Sep 17 00:00:00 2001 From: Jonathan Druart Date: Tue, 25 Nov 2014 10:01:05 +0100 Subject: [PATCH 3/3] Bug 11814: Fix sql parameters order Oops, bad paramaters passed on executing the sql query produced unexpected behaviors. Signed-off-by: Paola Rossi --- C4/Serials.pm | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) diff --git a/C4/Serials.pm b/C4/Serials.pm index 8b54af3..6542d7e 100644 --- a/C4/Serials.pm +++ b/C4/Serials.pm @@ -340,7 +340,7 @@ sub UpdateClaimdateIssues { WHERE serialid in (" . join( ",", map { '?' } @$serialids ) . ") "; my $rq = $dbh->prepare($query); - $rq->execute($date, @$serialids, CLAIMED); + $rq->execute($date, CLAIMED, @$serialids); return $rq->rows; } -- 1.7.10.4