[Koha] My Overdue Items Report is adding extra names

[Joe Atzberger]

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 at 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 at mountainviewics.org
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.katipo.co.nz/pipermail/koha/attachments/20080402/3e36b3a8/attachment.htm