diff options
| author | Mark Wells <mark@freeside.biz> | 2016-11-17 00:54:04 -0800 |
|---|---|---|
| committer | Mark Wells <mark@freeside.biz> | 2016-11-17 00:54:48 -0800 |
| commit | 765301c50ceefa897cc9541edb46adca568cb692 (patch) | |
| tree | 20137103b81098903aefa67ec71da586682a03c0 /FS/FS/cust_location.pm | |
| parent | 2b76dd3be38311e9144a3f2017dfdaec6261fff3 (diff) | |
skip tax district update on disabled locations
Diffstat (limited to 'FS/FS/cust_location.pm')
| -rw-r--r-- | FS/FS/cust_location.pm | 2 |
1 files changed, 1 insertions, 1 deletions
diff --git a/FS/FS/cust_location.pm b/FS/FS/cust_location.pm index a9660d8..e1b8533 100644 --- a/FS/FS/cust_location.pm +++ b/FS/FS/cust_location.pm @@ -937,7 +937,7 @@ sub _upgrade_data { next if $field eq 'disabled'; foreach my $location (qsearch({ table => 'cust_location', - extra_sql => " WHERE $field LIKE ' %' OR $field LIKE '% '" + extra_sql => " WHERE disabled IS NULL AND ($field LIKE ' %' OR $field LIKE '% ')" })) { my $error = $location->replace; die "$error (fixing whitespace in $field, locationnum ".$location->locationnum.')' |