Amber --<br><br>I suspect you are using an older version of Koha. Please specify. <br><br>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. <br>
<br>In my 3.0(beta) version of Koha, looking at the page:<br><div style="margin-left: 40px;">/cgi-bin/koha/circ/overdue.pl<br></div><br>Before getting filters and sorting clauses added, the query starts as:<br><br style="font-family: courier new,monospace;">
<span style="font-family: courier new,monospace;">SELECT date_due,concat(surname,' ', firstname) as borrower, </span><br style="font-family: courier new,monospace;"><span style="font-family: courier new,monospace;"> borrowers.phone, borrowers.email,issues.itemnumber, items.barcode, biblio.title, biblio.author, borrowers.borrowernumber, biblio.biblionumber, borrowers.branchcode </span><br style="font-family: courier new,monospace;">
<span style="font-family: courier new,monospace;">FROM issues</span><br style="font-family: courier new,monospace;"><span style="font-family: courier new,monospace;">LEFT JOIN borrowers ON (issues.borrowernumber=borrowers.borrowernumber)</span><br style="font-family: courier new,monospace;">
<span style="font-family: courier new,monospace;">LEFT JOIN items ON ( issues.itemnumber=items.itemnumber)</span><br style="font-family: courier new,monospace;"><span style="font-family: courier new,monospace;">LEFT JOIN biblioitems ON (biblioitems.biblioitemnumber=items.biblioitemnumber)</span><br style="font-family: courier new,monospace;">
<span style="font-family: courier new,monospace;">LEFT JOIN biblio ON ( biblio.biblionumber=items.biblionumber)</span><br style="font-family: courier new,monospace;"><br>Your query might not be doing LEFT JOINs, for example.<br>
<br>--joe atzberger<br><br><div class="gmail_quote">On Sun, Mar 30, 2008 at 11:56 PM, Amber <<a href="mailto:library@mountainviewics.org">library@mountainviewics.org</a>> wrote:<br><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">
<div link="blue" vlink="purple" lang="EN-US">
<div>
<p><font face="Arial" size="2"><span style="font-size: 10pt; font-family: Arial;">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? <br></span></font></p>
<p><font face="Arial" size="2"><span style="font-size: 10pt; font-family: Arial;">Thanks! <br>Amber Amland</span></font></p>
<p><font face="Monotype Corsiva" size="3"><span style="font-size: 12pt;">Amber Amland</span></font></p><p><font face="Garamond" size="3"><span style="font-size: 12pt; font-family: Garamond;">Librarian<br>Mountainview ICS<br>
<a href="mailto:library@mountainviewics.org" target="_blank">library@mountainviewics.org</a></span></font></p></div></div></blockquote></div>