summaryrefslogtreecommitdiff
path: root/FS
diff options
context:
space:
mode:
authorivan <ivan>2011-08-05 03:27:16 +0000
committerivan <ivan>2011-08-05 03:27:16 +0000
commitb7d483c833537c23e031a222f72cc48edf15f349 (patch)
tree85965f7bd27231a302d5dc81719fa466fa60bf67 /FS
parent3ad0080229de463ef00f26ce384729f3303360ad (diff)
fix billday condition without a delay option causing the event to never run, RT#13915
Diffstat (limited to 'FS')
-rw-r--r--FS/FS/part_event/Condition.pm5
1 files changed, 4 insertions, 1 deletions
diff --git a/FS/FS/part_event/Condition.pm b/FS/FS/part_event/Condition.pm
index efe0d3cf3..b62440750 100644
--- a/FS/FS/part_event/Condition.pm
+++ b/FS/FS/part_event/Condition.pm
@@ -469,7 +469,10 @@ sub condition_sql_option_integer {
my $integer = ($driver_name =~ /^mysql/) ? 'UNSIGNED INTEGER' : 'INTEGER';
- 'CAST('. $class->condition_sql_option($option). " AS $integer )";
+ 'CAST(
+ COALESCE('. $class->condition_sql_option($option).
+ " ,'0') ".
+ " AS $integer )";
}
=head1 NEW CONDITION CLASSES