Overdue items that aren't yet overdue
This last week we upgraded to the latest release, 3.8.3, and we now have a strange problem where when you create a print slip in a patron's file, they will have the overdue section with a book that is due today even through the time for it to become overdue is in another 8 hours time. Being at a school, we have the kids return books as a class on the exact day it is due so it isn't overdue until we get past the due date. In past versions all the books were listed as on loan but never overdue unless the date and time were past - but now the unique case of when the date = today, it is always listed as overdue. Is there an easy way to fix this? Perhaps some setting somewhere? We've had a look around over the past couple of days and all we found was the template which is definitely set out right still. FYI - exact description of the librarian "This morning we noticed that books due back today appear as "overdues" on the print slip (student borrower card/print button). This wasn't the case yesterday." The difference between 'this morning' and 'yesterday' in the librarian's comment is that we upgraded Koha overnight. Thanks for your help in advance. Regards, Seth Mayo IT Technical Manager Email: smayo@stpeters.nsw.edu.au ------------------------------------------------------- St Peter's Anglican Primary School Howe Street Campbelltown NSW 2560 PH: 02 4627 2990 DID: 02 8203 1368 Website: http://www.stpeters.nsw.edu.au
On 7 August 2012 09:48, Seth Mayo <smayo@stpeters.nsw.edu.au> wrote:
This last week we upgraded to the latest release, 3.8.3, and we now have a strange problem where when you create a print slip in a patron's file, they will have the overdue section with a book that is due today even through the time for it to become overdue is in another 8 hours time. Being at a school, we have the kids return books as a class on the exact day it is due so it isn't overdue until we get past the due date. In past versions all the books were listed as on loan but never overdue unless the date and time were past - but now the unique case of when the date = today, it is always listed as overdue.
Is there an easy way to fix this? Perhaps some setting somewhere? We've had a look around over the past couple of days and all we found was the template which is definitely set out right still.
FYI - exact description of the librarian "This morning we noticed that books due back today appear as "overdues" on the print slip (student borrower card/print button). This wasn't the case yesterday." The difference between 'this morning' and 'yesterday' in the librarian's comment is that we upgraded Koha overnight.
Thanks for your help in advance.
Hi Seth You have just run into something similar to http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=8182 I think. Can you check the database, and see what the due date of the items are? Chris
This doesn't seem to the be same issue (although when you sent that back I was convinced it was too). Database entry of an item due back today: borrowernumber itemnumber date_due branchcode issuingbranch returndate lastreneweddate return renewals timestamp issuedate [image: Edit]<http://tux-koha/phpmyadmin/tbl_change.php?db=kohadb&table=issues&where_clause=%60issues%60.%60itemnumber%60+%3D+2840&clause_is_unique=1&sql_query=SELECT+%2A++FROM+%60issues%60+WHERE+%60itemnumber%60+%3D+2840&goto=sql.php&token=a0fa7fa0b1a68b6414a648fa3cdb6da5> [image: Delete]<http://tux-koha/phpmyadmin/sql.php?db=kohadb&table=issues&sql_query=DELETE+FROM+%60kohadb%60.%60issues%60+WHERE+%60issues%60.%60itemnumber%60+%3D+2840&zero_rows=The+row+has+been+deleted&goto=sql.php%3Fdb%3Dkohadb%26table%3Dissues%26sql_query%3DSELECT%2B%252A%2B%2BFROM%2B%2560issues%2560%2BWHERE%2B%2560itemnumber%2560%2B%253D%2B2840%26zero_rows%3DThe%2Brow%2Bhas%2Bbeen%2Bdeleted%26goto%3Dsql.php%253Fdb%253Dkohadb%2526amp%253Btable%253Dissues%2526amp%253Btoken%253Da0fa7fa0b1a68b6414a648fa3cdb6da5%2526amp%253Bsql_query%253DSELECT%252B%25252A%252B%252BFROM%252B%252560issues%252560%252BWHERE%252B%252560itemnumber%252560%252B%25253D%252B2840%26token%3Da0fa7fa0b1a68b6414a648fa3cdb6da5&token=a0fa7fa0b1a68b6414a648fa3cdb6da5> 611 2840 2012-08-07 23:59:00 SPAS *NULL* *NULL* *NULL* *NULL* *NULL* 2012-07-31 09:38:46 2012-07-31 09:38:00 23:59:00 is the time entry on this item rather than the 00:00:00. However, issuing a print slip still results in the item coming up as overdue. Any other ideas? Seth Mayo IT Technical Manager Email: smayo@stpeters.nsw.edu.au ------------------------------------------------------- St Peter's Anglican Primary School Howe Street Campbelltown NSW 2560 PH: 02 4627 2990 DID: 02 8203 1368 Website: http://www.stpeters.nsw.edu.au On 7 August 2012 08:07, Chris Cormack <chris@bigballofwax.co.nz> wrote:
This last week we upgraded to the latest release, 3.8.3, and we now have a strange problem where when you create a print slip in a patron's file,
On 7 August 2012 09:48, Seth Mayo <smayo@stpeters.nsw.edu.au> wrote: they
will have the overdue section with a book that is due today even through the time for it to become overdue is in another 8 hours time. Being at a school, we have the kids return books as a class on the exact day it is due so it isn't overdue until we get past the due date. In past versions all the books were listed as on loan but never overdue unless the date and time were past - but now the unique case of when the date = today, it is always listed as overdue.
Is there an easy way to fix this? Perhaps some setting somewhere? We've had a look around over the past couple of days and all we found was the template which is definitely set out right still.
FYI - exact description of the librarian "This morning we noticed that books due back today appear as "overdues" on the print slip (student borrower card/print button). This wasn't the case yesterday." The difference between 'this morning' and 'yesterday' in the librarian's comment is that we upgraded Koha overnight.
Thanks for your help in advance.
Hi Seth
You have just run into something similar to http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=8182 I think.
Can you check the database, and see what the due date of the items are?
Chris
participants (2)
-
Chris Cormack -
Seth Mayo