diff options
author | ivan <ivan> | 2011-08-05 03:27:16 +0000 |
---|---|---|
committer | ivan <ivan> | 2011-08-05 03:27:16 +0000 |
commit | b7d483c833537c23e031a222f72cc48edf15f349 (patch) | |
tree | 85965f7bd27231a302d5dc81719fa466fa60bf67 /FS | |
parent | 3ad0080229de463ef00f26ce384729f3303360ad (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.pm | 5 |
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 |