diff options
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.')' |