From: ivan <ivan>
Date: Thu, 4 Feb 2010 04:48:48 +0000 (+0000)
Subject: fix SQL error with date field when using this condition, RT#7218
X-Git-Tag: root_of_svc_elec_features~490
X-Git-Url: http://git.freeside.biz/gitweb/?p=freeside.git;a=commitdiff_plain;h=bd1c27e102584213471743d155b8f27d0d0f5bd9

fix SQL error with date field when using this condition, RT#7218
---

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";