http://bugs.koha.org/cgi-bin/bugzilla3/show_bug.cgi?id=4036 Owen Leonard <oleonard@myacpl.org> changed: What |Removed |Added ---------------------------------------------------------------------------- CC| |henridamien@koha-fr.org --- Comment #1 from Owen Leonard <oleonard@myacpl.org> 2010-01-11 16:19:46 --- In the relevant portion of Members.pm (line 572): my $sth = $dbh->prepare( "SELECT COUNT(*) as latedocs FROM issues WHERE borrowernumber = ? AND date_due < now()" ); If I try a similar query: mysql> select date_due,returndate,issuedate from issues WHERE borrowernumber = 51 and date_due < now(); +------------+------------+------------+ | date_due | returndate | issuedate | +------------+------------+------------+ | 2010-01-11 | NULL | 2009-12-28 | | 2010-01-11 | NULL | 2009-12-28 | | 2010-01-11 | NULL | 2009-12-28 | | 2010-01-11 | NULL | 2009-12-28 | | 2010-01-11 | NULL | 2009-12-28 | | 2010-01-11 | NULL | 2009-12-28 | +------------+------------+------------+ Is it correct that IsMemberBlocked() should return -1 if my checkouts are due today? -- Configure bugmail: http://bugs.koha.org/cgi-bin/bugzilla3/userprefs.cgi?tab=email ------- You are receiving this mail because: ------- You are watching all bug changes.