From 3df10fe3f94cbae6c6bb247ccc1137d71bc44bbb Mon Sep 17 00:00:00 2001 From: Ivan Kohler Date: Fri, 11 Mar 2016 19:34:35 -0800 Subject: [PATCH] fix customer package browse selection, RT#39822 --- FS/FS/cust_main/Packages.pm | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) 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]; -- 2.11.0