Tony, First, it's spelled Koha (not KOHA) - read here: http://bywatersolutions.com/?p=690 Next, I'm not sure how to help you with this specific problem so please remember to email the entire list so that someone with more skills than me can help you out. Thanks Nicole On Wed, Nov 10, 2010 at 10:42 PM, Tony Ying <tony_ykt@yahoo.com> wrote:
Dear Nicole,
Hope this email finds you well.
I need your assistance to resolve an issue on my KOHA Library system.
When i do a catalog search,i got this error message "Can't call method "as_usmarc" on an undefined value at /usr/share/koha/lib/C4/Search.pm line 2119."
i ran /usr/share/koha/bin/migration_tools/rebuild_nozebra.pl and it resolved the issue However,when i perform a catalog search using either keyword or barcode again , it will either show me 1 or 2 records or no record is found. In fact, there are records in my Koha.Out of 10 tries, only 1 or 2 times are successfully...
Thanks in advanced.
________________________________ From: Nicole Engard <nengard@gmail.com> To: Susan Bennett <susan.bennett@geaugalibrary.info> Cc: ahtshun83 <tony_ykt@yahoo.com>; koha@lists.katipo.co.nz Sent: Thursday, 8 October 2009 04:48:49 Subject: Re: [Koha] Koha MySQL Statement
Remember that there is a SQL reports list on the wiki- add your reports there and check there first to see if someone else has already written the report you're looking for: http://wiki.koha.org/doku.php?id=sql_library
Nicole
2009/10/7 Susan Bennett <susan.bennett@geaugalibrary.info>:
This is what we use:
SELECT
borrowers.cardnumber,borrowers.surname,borrowers.firstname,borrowers.phone,borrowers.branchcode,borrowers.categorycode,borrowers.address,borrowers.address2,borrowers.city,borrowers.zipcode, items.homebranch, items.holdingbranch,items.itemcallnumber, items.location,
items.ccode,issues.date_due,biblio.author,biblio.title,items.barcode,items.replacementprice FROM borrowers LEFT JOIN issues on (issues.borrowernumber = borrowers.borrowernumber) LEFT JOIN items on (items.itemnumber = issues.itemnumber) LEFT JOIN biblioitems on (items.biblioitemnumber=biblioitems.biblioitemnumber) LEFT JOIN biblio on (biblioitems.biblionumber=biblio.biblionumber) WHERE issues.date_due < DATE_SUB(now(), INTERVAL put in the number of days overdue you are checking for DAY) AND issues.returndate IS NULL ORDER BY borrowers.surname asc
This has more fields then you need but it's easy to take the un-needed ones out. Hope this helps!
Susan Bennett ILS System Administrator Geauga County Public Library 440 286-6811 x 125 440 286-7419 FAX
On Wed, Oct 7, 2009 at 3:54 AM, ahtshun83 <tony_ykt@yahoo.com> wrote:
Hi all,
I would like to extract out a list of patrons who has overdue books which has yet to return. I need the required field such as surname,card number,book borrowed & due date.
is there anyone has a sample of the above script?
appreciated and thank you in advanced -- View this message in context: http://www.nabble.com/Koha-MySQL-Statement-tp25782087p25782087.html Sent from the Koha - Discuss mailing list archive at Nabble.com.
_______________________________________________ Koha mailing list Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
_______________________________________________ Koha mailing list Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha