From 2c5836d332fce3c4d32768a1f3cd16dea52c8c0e Mon Sep 17 00:00:00 2001 From: Jonathan Druart Date: Tue, 25 Nov 2014 10:01:05 +0100 Subject: [PATCH] Bug 11814: Fix sql parameters order Oops, bad paramaters passed on executing the sql query produced unexpected behaviors. --- 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; } -- 2.1.0