X-Git-Url: https://git.sesse.net/?a=blobdiff_plain;f=clients%2Fdhcptail.pl;h=6a529de940caa23aa252afe5e4b5972f6c41c754;hb=684a6cca9932fd57dcab4bb4edda01d6867c5159;hp=a1e1c624fa0511a11677980020bf9f2adfdf1a11;hpb=5541bedcc39044e899a10f9dc47b755a9b51d503;p=nms

diff --git a/clients/dhcptail.pl b/clients/dhcptail.pl
index a1e1c62..6a529de 100755
--- a/clients/dhcptail.pl
+++ b/clients/dhcptail.pl
@@ -7,7 +7,7 @@ use strict;
 use warnings;
 
 # WARNING: CHANGE THIS! :-P
-my $year = 2006;
+my $year = 2007;
 
 my %months = (
 	Jan => 1,
@@ -31,7 +31,7 @@ while (<>) {
 
 	if (!defined($dbh) || !$dbh->ping) {
 		$dbh = nms::db_connect();
-		$q = $dbh->prepare("UPDATE dhcp SET last_ack=? WHERE inet ? << network AND ( last_ack < ? OR last_ack IS NULL )")
+		$q = $dbh->prepare("UPDATE dhcp SET last_ack=? WHERE ?::inet << network AND ( last_ack < ? OR last_ack IS NULL )")
 			or die "Couldn't prepare query";
 	}