From a90ff2a26a0188a31de59851fc4d54cd312b4c8f Mon Sep 17 00:00:00 2001 From: Jonathan Druart Date: Mon, 12 Aug 2013 12:55:57 +0200 Subject: [PATCH] Bug 9811: use count(primary_key) instead of count(*) --- C4/Utils/DataTables/Members.pm | 4 ++-- 1 file changed, 2 insertions(+), 2 deletions(-) diff --git a/C4/Utils/DataTables/Members.pm b/C4/Utils/DataTables/Members.pm index aeb0eba..e23732a 100644 --- a/C4/Utils/DataTables/Members.pm +++ b/C4/Utils/DataTables/Members.pm @@ -104,13 +104,13 @@ sub search { my $patrons = $sth->fetchall_arrayref({}); # Get the iTotalDisplayRecords DataTable variable - $query = "SELECT COUNT(*) " . $from . ($where ? $where : ""); + $query = "SELECT COUNT(borrowers.borrowernumber) " . $from . ($where ? $where : ""); $sth = $dbh->prepare($query); $sth->execute(@where_args); ($iTotalDisplayRecords) = $sth->fetchrow_array; # Get the iTotalRecords DataTable variable - $query = "SELECT COUNT(*) FROM borrowers"; + $query = "SELECT COUNT(borrowers.borrowernumber) FROM borrowers"; $sth = $dbh->prepare($query); $sth->execute; ($iTotalRecords) = $sth->fetchrow_array; -- 1.7.10.4