X-Git-Url: http://git.freeside.biz/gitweb/?p=freeside.git;a=blobdiff_plain;f=FS%2FFS%2Fcust_location.pm;h=e1b853383da4c9efff1a031d90d769e9287a625e;hp=a9660d86cef558e313b2f0fbfae23c2f759883e3;hb=50ccf7c4c7a6416922c95eebea84b547d1235817;hpb=f7b5454b52807d21d563db95a5da3a6ed0bddb25

diff --git a/FS/FS/cust_location.pm b/FS/FS/cust_location.pm
index a9660d86c..e1b853383 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.')'