[Koha] Availability (& Zebra?)

[Chris Cormack]

* Scott Daniels (scott at tw.co.nz) wrote:
>    Hi Chris,
> 
>    I did run this script during my attempts to fix this, although I didn't do
>    an index afterwards.
>    What I found when I ran this script is it 'broke' the display on the
>    'details' screen. The book items, instead of displaying 'Available' as
>    they had, would now display nothing at all ie, blank. I found this was
>    because the details screen looks for a 'null'  value in order(in onloan)
>    to display available, whereas the script replaced all the null values with
>    0000-00-00. I thought I was on the wrong track at this point and reverted
>    to a backup.
> 
>    I'm happy to try this on your advice... I just have one question first, if
>    I run this script, followed by the reindex, will this correct the display
>    of the availability with the detail screen? Do I run a query to replace
>    all 0000-00-00 with null after indexing?
> 
>    Sorry that was two questions. :)
> 
What I would do, is the fix_onloan.pl script, run the reindex, then if
the detail looks mucked up, run your query.

Chris


-- 
Chris Cormack
Catalyst IT Ltd.
+64 4 803 2238
PO Box 11-053, Manners St, Wellington 6142, New Zealand