* Scott Daniels (scott@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