From bd1c27e102584213471743d155b8f27d0d0f5bd9 Mon Sep 17 00:00:00 2001
From: ivan <ivan>
Date: Thu, 4 Feb 2010 04:48:48 +0000
Subject: [PATCH] fix SQL error with date field when using this condition,
 RT#7218

---
 FS/FS/part_event/Condition/every.pm | 2 +-
 1 file changed, 1 insertion(+), 1 deletion(-)

diff --git a/FS/FS/part_event/Condition/every.pm b/FS/FS/part_event/Condition/every.pm
index 3408b0aa9..1910674f8 100644
--- a/FS/FS/part_event/Condition/every.pm
+++ b/FS/FS/part_event/Condition/every.pm
@@ -50,7 +50,7 @@ sub condition {
     or die "unparsable retry_delay: $retry_delay";
   my $date_after = $time - $1 * $after{$2};
 
-  my $sth = dbh->prepare("$sql AND date > ?") # AND status = 'failed' "
+  my $sth = dbh->prepare("$sql AND _date > ?") # AND status = 'failed' "
     or die  dbh->errstr. " preparing: $sql";
   $sth->execute($self->eventpart, $tablenum, $date_after)
     or die $sth->errstr. " executing: $sql";
-- 
2.11.0