Claim date is being interpolated into sql string but
without the necessary quotes resulting in a date of
0 being set.
interpolation into sql strings should be avoided
---
C4/Serials.pm | 2 +-
1 files changed, 1 insertions(+), 1 deletions(-)
diff --git a/C4/Serials.pm b/C4/Serials.pm
index 032246c..8779433 100644
--- a/C4/Serials.pm
+++ b/C4/Serials.pm
@@ -287,7 +287,7 @@ sub UpdateClaimdateIssues {
my $dbh = C4::Context->dbh;
$date = strftime( "%Y-%m-%d", localtime ) unless ($date);
my $query = "
- UPDATE serial SET claimdate=$date,status=7
+ UPDATE serial SET claimdate=\'$date\',status=7
WHERE serialid in (" . join( ",", @$serialids ) . ")";
my $rq = $dbh->prepare($query);
$rq->execute;
--
1.7.2
_______________________________________________
Koha-patches mailing list
[email protected]
http://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-patches
