Return Receipts displaying incorrect due date
- Product: Aleph
- Product Version: 20, 21, 22, 23
- Relevant for Installation Type: Dedicated-Direct, Direct, Local, Total Care
Description
Earlier this week, the library accidentally erased all of their hours and exceptions, so any items they checked out came back with a due date of 01/20/2038.
Now their hours and exceptions have been fixed, but all of the return receipts that are generated for items that were checked out during that time are still showing 01/20/2038 as the due date.
Below is the most recent return receipt. The item was checked out on 09/10/18 12:40 PM when the hours were missing and received the 01/20/38 due date. It was then returned on 09/11/18 06:01 PM. The same item was checked out again 09/12/18 10:05 AM and received a due date of 09/12/18. It was returned 09/12/18 10:06 AM and the circ log says the due date was supposed to print as 09/12/18, but as you can see below the return receipt still used the 01/20/2038 due date.
Call No:: Mac charger
Barcode:: 31122054993303
Due Date:: 01/20/2038
Returned Date:: 09/11/2018
Resolution
The "Due Date" which displays on the receipt is coming from the z36h loan history table. The following SQL was used to determine how many cases there were:
SQL> select z36h_due_date from z36h where z36h_due_date like '2038%';
And the following to correct them:
SQL> update z36h set z36h_due_date = '20180900' where z36h_due_date like '2038%';
Note: You could change them to an actual day (rather than "0900"), if you know what's correct.
- Article last edited: 25-Sep-2018