[Koha] Fines coming back after being paid. Calendar holidays problem?
Answering my own question… Our support company PTFS Europe have cracked this one. Apparently this has been seen with other 18.11 sites. The problem is with the fines.pl script taking hours and hours to run. Seems the job gets the total number of days between the due date and now. Then it iterates through every day checking if it is a holiday and if it is, decrements the total number of days. The problem is that it is only checking a couple of days a second. We have lots of “old” fines- back to 2013 and the checking was taking ages. PTFS have advised there's a caching mechanism that the problematic part of the fines calculation should be using but wasn't. They have now enable memcached to start using the cache. This allows the fine calculation to cache a particularly expensive query, reducing the time to calculate a 7 year old fine from 53s to 4s. Apparently a line has been added to our koha-conf file to cause memcached to start using the cache. Fingers crossed that fines.pl will now run correctly overnight. Ray Delahunty. This email and any attachments are intended solely for the addressee and may contain confidential information. If you are not the intended recipient of this email and/or its attachments you must not take any action based upon them and you must not copy or show them to anyone. Please send the email back to us and immediately and permanently delete it and its attachments. Where this email is unrelated to the business of University of the Arts London or of any of its group companies the opinions expressed in it are the opinions of the sender and do not necessarily constitute those of University of the Arts London (or the relevant group company). Where the sender's signature indicates that the email is sent on behalf of UAL Short Courses Limited the following also applies: UAL Short Courses Limited is a company registered in England and Wales under company number 02361261. Registered Office: University of the Arts London, 272 High Holborn, London WC1V 7EY ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz https://lists.katipo.co.nz/mailman/listinfo/koha
[Koha] Searching Error alphabetically, again
Hello everybody, We are using koha 19.05.02 in spanish, before that 18.xx. After the upgrade, when we try search, i.e: A or a, the result is: (By title) 1. La la la 2. Nam 3. Icaro el enfermo 4. Agatha 5. Album As you can see, it is not in order. It was working ok before the upgrade. We checked the sort-string-utf.chr and the word-string-utf.chr and everything is it OK. Any Help? Thanks -- *Luis Moisés Rojas P.* ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz https://lists.katipo.co.nz/mailman/listinfo/koha
[Koha] Fines coming back after being paid. Calendar holidays problem?
We are receiving reports of fines returning to user accounts the day after they have been paid, or even soon after the payment was made. Our software support company is investigating and they have noticed the fines.pl script is overrunning. They have put some logging on the crontab entry in the meantime and have suggested we clear down the "closed days" (special holidays, repeatable holidays) on our system as they suggest this may be a cause of the fines job overrunning. Apparently the fines job references the calendar as it runs, and when the number of calendar entries builds up there may be problems. The special holidays count for previous years have been removed (420 lines) leaving this year and the next two, with a total count of 350 lines. We are not yet in a situation where we can raise this in Bugzilla, but I thought I'd ask if anyone else had encountered such a problem. Ray Delahunty University of the Arts London This email and any attachments are intended solely for the addressee and may contain confidential information. If you are not the intended recipient of this email and/or its attachments you must not take any action based upon them and you must not copy or show them to anyone. Please send the email back to us and immediately and permanently delete it and its attachments. Where this email is unrelated to the business of University of the Arts London or of any of its group companies the opinions expressed in it are the opinions of the sender and do not necessarily constitute those of University of the Arts London (or the relevant group company). Where the sender's signature indicates that the email is sent on behalf of UAL Short Courses Limited the following also applies: UAL Short Courses Limited is a company registered in England and Wales under company number 02361261. Registered Office: University of the Arts London, 272 High Holborn, London WC1V 7EY ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz https://lists.katipo.co.nz/mailman/listinfo/koha