From: ivan Date: Tue, 31 Mar 2009 19:51:54 +0000 (+0000) Subject: really fix notify for Pg 8.3 X-Git-Tag: root_of_svc_elec_features~1316 X-Git-Url: http://git.freeside.biz/gitweb/?p=freeside.git;a=commitdiff_plain;h=7889bec2b0f951c053b06ef45fbc60dacd3f8a88 really fix notify for Pg 8.3 --- diff --git a/FS/FS/Cron/notify.pm b/FS/FS/Cron/notify.pm index c67fcc19a..5b0e186ad 100644 --- a/FS/FS/Cron/notify.pm +++ b/FS/FS/Cron/notify.pm @@ -62,7 +62,7 @@ END 0 = ( select count(*) from cust_pkg_option where cust_pkg.pkgnum = cust_pkg_option.pkgnum and cust_pkg_option.optionname = 'impending_recur_notification_sent' - and cust_pkg_option.optionvalue = 1 + and CAST( cust_pkg_option.optionvalue AS INTEGER ) = 1 ) END