X-Git-Url: http://git.freeside.biz/gitweb/?a=blobdiff_plain;ds=sidebyside;f=FS%2FFS%2Fcust_main.pm;h=b828542a778bdd127941634d95d68cfa0f56be2f;hb=8a79ead8b600494b214d7492dab043d5dfc96587;hp=a39ac34c9433dec0914d31192c099a076152cca5;hpb=fdbee9ee821385bfbd9578f940eeb8ca74cb9eff;p=freeside.git diff --git a/FS/FS/cust_main.pm b/FS/FS/cust_main.pm index a39ac34c9..b828542a7 100644 --- a/FS/FS/cust_main.pm +++ b/FS/FS/cust_main.pm @@ -8434,7 +8434,7 @@ sub queued_bill { sub _upgrade_data { #class method my ($class, %opts) = @_; - my $sql = 'UPDATE h_cust_main SET paycvv = NULL'; + my $sql = 'UPDATE h_cust_main SET paycvv = NULL WHERE paycvv IS NOT NULL'; my $sth = dbh->prepare($sql) or die dbh->errstr; $sth->execute or die $sth->errstr;