* Ian Walls (ian.walls@bywatersolutions.com) wrote:
after performing a search that returns many, many results, limiting to available will reduce the results to less than a page's worth (far fewer than are actually available)
On Fri, May 7, 2010 at 3:23 PM, Chris Cormack <chrisc@catalyst.net.nz> wrote:
If you get a chance could you try running the misc/migration/fix_onloan.pl script. And also update items set onloan = NULL WHERE onloan = '0000-00-00'
I see this problem in my test system running HEAD. I followed both these suggestions and there was no effect. The script produced a few lines of output (like "Onloan : 2010-03-04 for 768 / 1432"). The sql statement affected 0 rows. -- Owen -- Web Developer Athens County Public Libraries http://www.myacpl.org