diff options
| author | ivan <ivan> | 2011-08-05 03:27:15 +0000 |
|---|---|---|
| committer | ivan <ivan> | 2011-08-05 03:27:15 +0000 |
| commit | ac62d1f855e6c6de100872c81956fbbf092fcb88 (patch) | |
| tree | 530f8a08d2134a405f18a2fea1b887047c734c56 | |
| parent | faef4c382220dcda940e41b575aecee358d1e0c8 (diff) | |
fix billday condition without a delay option causing the event to never run, RT#13915
| -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 |