summaryrefslogtreecommitdiff
path: root/FS/FS/cust_main/Packages.pm
diff options
context:
space:
mode:
authorIvan Kohler <ivan@freeside.biz>2016-03-11 19:34:39 -0800
committerIvan Kohler <ivan@freeside.biz>2016-03-11 19:34:39 -0800
commit8be1c9f4cf65aea5218abb49c2123a796fa86fab (patch)
tree2f7b529f90af2e6560b7305fe53da4907a3dafe8 /FS/FS/cust_main/Packages.pm
parent7b8c690b5f4a7b071d4592e133575c88f7027497 (diff)
fix customer package browse selection, RT#39822
Diffstat (limited to 'FS/FS/cust_main/Packages.pm')
-rw-r--r--FS/FS/cust_main/Packages.pm2
1 files changed, 1 insertions, 1 deletions
diff --git a/FS/FS/cust_main/Packages.pm b/FS/FS/cust_main/Packages.pm
index 13c2945..792c05b 100644
--- a/FS/FS/cust_main/Packages.pm
+++ b/FS/FS/cust_main/Packages.pm
@@ -730,7 +730,7 @@ sub num_pkgs {
}
$sql = "AND $sql" if $sql && $sql !~ /^\s*$/ && $sql !~ /^\s*AND/i;
my $sth = dbh->prepare(
- "SELECT COUNT(*) FROM cust_pkg $addl_from WHERE custnum = ? $sql"
+ "SELECT COUNT(*) FROM cust_pkg $addl_from WHERE cust_pkg.custnum = ? $sql"
) or die dbh->errstr;
$sth->execute($self->custnum) or die $sth->errstr;
$sth->fetchrow_arrayref->[0];