[Koha] Koha MySQL Statement

[Nicole Engard]

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 at 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 at gmail.com>
> To: Susan Bennett <susan.bennett at geaugalibrary.info>
> Cc: ahtshun83 <tony_ykt at yahoo.com>; koha at 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 at 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 at 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 at lists.katipo.co.nz
>>> http://lists.katipo.co.nz/mailman/listinfo/koha
>>
>>
>> _______________________________________________
>> Koha mailing list
>> Koha at lists.katipo.co.nz
>> http://lists.katipo.co.nz/mailman/listinfo/koha
>>
>>
>
>