summaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorIvan Kohler <ivan@freeside.biz>2016-03-11 19:34:35 -0800
committerIvan Kohler <ivan@freeside.biz>2016-03-11 19:34:35 -0800
commit3df10fe3f94cbae6c6bb247ccc1137d71bc44bbb (patch)
treea663e738c5a1eb677831f4df18a1938f58bbb277
parent943f3ff4145a0ce2ef946aba3f0ba4aa495f224e (diff)
fix customer package browse selection, RT#39822
-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 13c2945b8..792c05bec 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];