@@ -, +, @@ --- C4/Utils/DataTables/Members.pm | 4 ++-- koha-tmpl/intranet-tmpl/prog/en/includes/patron-search.inc | 4 ++-- 2 files changed, 4 insertions(+), 4 deletions(-) --- a/C4/Utils/DataTables/Members.pm +++ a/C4/Utils/DataTables/Members.pm @@ -27,7 +27,7 @@ sub search { } my $dbh = C4::Context->dbh; - my $select = "SELECT SQL_CALC_FOUND_ROWS + my $select = "SELECT borrowers.borrowernumber, borrowers.surname, borrowers.firstname, borrowers.address, borrowers.address2, borrowers.city, borrowers.zipcode, borrowers.country, CAST(borrowers.cardnumber AS UNSIGNED) AS cardnumber, borrowers.dateexpiry, @@ -104,7 +104,7 @@ sub search { my $patrons = $sth->fetchall_arrayref({}); # Get the iTotalDisplayRecords DataTable variable - $query = "SELECT FOUND_ROWS()"; + $query = "SELECT COUNT(*) ". $from . ($where ? $where : ""); $sth = $dbh->prepare($query); $sth->execute; ($iTotalDisplayRecords) = $sth->fetchrow_array; --- a/koha-tmpl/intranet-tmpl/prog/en/includes/patron-search.inc +++ a/koha-tmpl/intranet-tmpl/prog/en/includes/patron-search.inc @@ -91,8 +91,8 @@ [% ELSE %] [% END %] [% END %] -

- [% END %] +

+ [% END %] --