X-Git-Url: http://git.freeside.biz/gitweb/?a=blobdiff_plain;f=FS%2FFS%2Fpart_pkg_option.pm;h=142622bf5cdeaeb91de42188020b887a1c7b2c19;hb=3c54c844c665ed108c7892a154fd3972fab1f3e5;hp=3cb330b1f8a3e27ff0509c7f4cd18a2ff3e37664;hpb=624b2d44625f69d71175c3348cae635d580c890b;p=freeside.git diff --git a/FS/FS/part_pkg_option.pm b/FS/FS/part_pkg_option.pm index 3cb330b1f..142622bf5 100644 --- a/FS/FS/part_pkg_option.pm +++ b/FS/FS/part_pkg_option.pm @@ -137,6 +137,10 @@ sub _upgrade_data { # class method $sth = dbh->prepare($sql) or die dbh->errstr; $sth->execute or die $sth->errstr; + $sql = "UPDATE part_pkg_option SET optionvalue = NULL WHERE ". + "optionname = 'contract_end_months' AND optionvalue = '(none)'"; + $sth = dbh->prepare($sql) or die dbh->errstr; + $sth->execute or die $sth->errstr; ''; }