diff options
author | Ivan Kohler <ivan@freeside.biz> | 2015-02-03 07:18:45 -0800 |
---|---|---|
committer | Ivan Kohler <ivan@freeside.biz> | 2015-02-03 07:18:45 -0800 |
commit | aeb90ade381fc3d5477db0334048c2af623fccfe (patch) | |
tree | d1540f5ccef513d10193c124fa6aeaae743ba107 /FS/FS/phone_avail.pm | |
parent | 167dbdad01e2c1b62fd9be43cc05212e8c874a02 (diff) | |
parent | d9edf24e9d3e1fd87a23359a7679ef6d6637c00d (diff) |
contacts can be shared among customers / "duplicate contact emails", RT#27943
Diffstat (limited to 'FS/FS/phone_avail.pm')
-rw-r--r-- | FS/FS/phone_avail.pm | 4 |
1 files changed, 2 insertions, 2 deletions
diff --git a/FS/FS/phone_avail.pm b/FS/FS/phone_avail.pm index 52bbdeb..ae8526c 100644 --- a/FS/FS/phone_avail.pm +++ b/FS/FS/phone_avail.pm @@ -283,8 +283,8 @@ sub _upgrade_data { my $sth = dbh->prepare( 'UPDATE phone_avail SET svcnum = NULL WHERE svcnum IS NOT NULL - AND 0 = ( SELECT COUNT(*) FROM svc_phone - WHERE phone_avail.svcnum = svc_phone.svcnum )' + AND NOT EXISTS ( SELECT 1 FROM svc_phone + WHERE phone_avail.svcnum = svc_phone.svcnum )' ) or die dbh->errstr; $sth->execute or die $sth->errstr; |