[Koha] koha lost/missing items

2013-04-22 Thread schnydszch
I have Koha 3.10.4 installed in debian server. Whenever I set status to an item in moredetail.pl as lost it does not reflect that it's lost. And when I try to edit the item in additem.pl in 952$1, it also does not reflect. The framework for the particular book is Fast-add Framework and I check the

Re: [Koha] Marc framework errors

2013-04-22 Thread rfblanchard
This is probably to specific a problem to be useful to anyone but here goes: This problem was caused by a bug in how 'Toad For mysql' deals with tiny int values in version 6.3.0.642. When I exported marc_subfield_structure from a clean koha and imported into my upgraded koha I got the error above.

[Koha] Unexpected report results - returning old data

2013-04-22 Thread Elaine Bradtke
I'm running Koha 3.10.02 We have a report that looks for 6XX fields that are not linked to authorities and spits out a list of the unauthorized headings. It was very useful a few months ago in helping us find and correct an error with some imported data. We're about to import another big batch o

Re: [Koha] Marc framework errors

2013-04-22 Thread Paul
At 10:44 AM 4/22/2013 -0700, rfblanchard wrote: This is probably to specific a problem to be useful to anyone but here goes: This problem was caused by a bug in how 'Toad For mysql' deals with tiny int values in version 6.3.0.642. When I exported marc_subfield_structure from a clean koha and impo

[Koha] Report Help

2013-04-22 Thread Nicole Engard
I'm looking to change this report around. It shows patrons with their guarantor information. I want a report that shows me the guarantees for each guarantor instead. SELECT p.categorycode, p.dateofbirth, p.cardnumber, p.surname, p.firstname, p.dateexpiry, IFNULL(concat(g.surname, ', ', g.first

Re: [Koha] Report Help

2013-04-22 Thread Bernardo Gonzalez Kriegel
Nicole, you want for each guarantor it's guarantees, Q: it's ok to repeat guarantor information on each guarantee tuple? you could use something like this (put any data you want in first select, and change order by if needed) SELECT IFNULL(concat(g.surname, ', ', g.firstname, ' (',g.cardnumber,

[Koha] Opac can't show non-latin characters correctly

2013-04-22 Thread Peter Zhao
Hi, Warmly greetings. Could anyone know why in the "Refine your search" column area of OPAC can not show non-latin characters ? But in the other area of the OPAC can show non-latin characters. Anyone know how to fix this problem? Thanks a lot. Peter ___