Amber -- I suspect you are using an older version of Koha. Please specify. A broader fix might be to upgrade the system. The specific fix would be to look at the mysql query from the new version and compare to your version. In my 3.0(beta) version of Koha, looking at the page: /cgi-bin/koha/circ/overdue.pl Before getting filters and sorting clauses added, the query starts as: SELECT date_due,concat(surname,' ', firstname) as borrower, borrowers.phone, borrowers.email,issues.itemnumber, items.barcode, biblio.title, biblio.author, borrowers.borrowernumber, biblio.biblionumber, borrowers.branchcode FROM issues LEFT JOIN borrowers ON (issues.borrowernumber=borrowers.borrowernumber) LEFT JOIN items ON ( issues.itemnumber=items.itemnumber) LEFT JOIN biblioitems ON (biblioitems.biblioitemnumber=items.biblioitemnumber) LEFT JOIN biblio ON ( biblio.biblionumber=items.biblionumber) Your query might not be doing LEFT JOINs, for example. --joe atzberger On Sun, Mar 30, 2008 at 11:56 PM, Amber <library@mountainviewics.org> wrote:
My overdue items report shows a lot of extra names of people who don't have any overdue books. There are over 30 names of people who don't have overdue books listed. Some of the names are repeated three or four times. Has anyone else had this problem? Do you know how to fix it?
Thanks! Amber Amland
Amber Amland
Librarian Mountainview ICS library@mountainviewics.org