Bug 8786 - problem with print overdue notices
Summary: problem with print overdue notices
Status: CLOSED INVALID
Alias: None
Product: Koha
Classification: Unclassified
Component: Notices (show other bugs)
Version: 3.8
Hardware: All All
: P5 - low critical (vote)
Assignee: Bugs List
QA Contact:
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2012-09-18 20:34 UTC by Melia Meggs
Modified: 2019-06-27 09:24 UTC (History)
2 users (show)

See Also:
Change sponsored?: ---
Patch complexity: ---
Documentation contact:
Documentation submission:
Text to go in the release notes:
Version(s) released in:


Attachments

Note You need to log in before you can comment on or make changes to this bug.
Description Melia Meggs 2012-09-18 20:34:19 UTC
We are seeing some bogus overdue email messages.  I have had complaints about the print overdue notices which are sent to the library when a patron does not have an email address.

Here is an example of an email sent to the library on 9/16:

---------------
Dear  PROBLEM,

The item below is now 6 weeks overdue.  Please return it, or call or email the library if there is a problem. In another 4 weeks, you will receive a bill.

 "The hobbit" by Tolkien, J. R. R
 "The girl who played with fire" by Larsson, Stieg
 "Emily and Einstein" by Lee, Linda Francis

Thank you.

Staff
---------------

The items listed in this email are all overdue, but none of them are 6 weeks overdue and do not warrant receipt of the 2nd overdue notice.  The due dates for each item are:
8/31 - "The hobbit" by Tolkien, J. R. R
8/31 - "The girl who played with fire" by Larsson, Stieg
9/15 - "Emily and Einstein" by Lee, Linda Francis

The notice triggers say that this 2nd overdue notice should be sent at 42 days, but none of these items are 42 days overdue yet.

I also checked the cron job for overdues.pl.  It looks like this:
# OVERDUE NOTICES
0 7 * * *  $KOHA_CRON_PATH/overdue_notices.pl -t -itemscontent title,author,itemcallnumber,barcode,replacementprice

The manual says:
-t | --triggered
This option causes a notice to be generated if and only if an item is overdue by the number of days defined in a notice trigger.

I don't think this is working as expected.  I am marking this as critical since bogus overdue email messages are being generated.
Comment 1 Melia Meggs 2012-09-18 20:36:02 UTC
Also, the notice is using <item></item> tags and not <<items.content>> (I wouldn't expect that to make any difference, but just noting it here in case it helps!)
Comment 2 Paul Poulain 2012-11-21 16:12:44 UTC
Melia, I think we will need more information to find where this problem comes from...
Is it reported for many/all your libraries ? If no, that could be a configuration problem.
Are you sure of your overdues parameters ? (maybe a screenshot of your screen, or a SELECT * FROM overduerules output) ?
Comment 3 Melia Meggs 2012-11-21 20:37:52 UTC
This was only reported by one library, and this week they said that they haven't had any further problems since being upgraded to 3.8.5.  We never found the cause of this problem, but I think at this point we can consider this resolved since no other libraries have reported this behavior.