Bug 13048 - Serial Error when NULL date encountered
Summary: Serial Error when NULL date encountered
Status: CLOSED FIXED
Alias: None
Product: Koha
Classification: Unclassified
Component: Serials (show other bugs)
Version: 3.14
Hardware: All All
: P5 - low critical (vote)
Assignee: Bugs List
QA Contact: Testopia
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2014-10-08 23:30 UTC by Joy Nelson
Modified: 2019-06-27 09:24 UTC (History)
3 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 Joy Nelson 2014-10-08 23:30:49 UTC
We have a number of libraries experiencing the following error:

Date::Calc::Add_Delta_YM(): not a valid date at /home/koha/kohaclone/C4/Serials.pm line 2626, <DATA> line 522.

When we investigate it appears that there is no serial.planneddate value.  It is either NULL or there is no entry in the serial table for the subscriptionid.  

It appears that Koha is not handling 'bad data' well in the serials module in this case.
Comment 1 Katrin Fischer 2014-11-06 07:19:48 UTC
Hi Joy, 

I haven't seen this happening and haven't managed to create a serial issue without planned date - do you have some more information on it? On which page does it happen? Is it migrated data or date added to Koha manually?
Comment 2 Joy Nelson 2014-11-06 15:55:03 UTC
Katrin-
I have seen this in a lot of migrated data.  Which is an issue only because previously that date wasn't required for serial functionality.  And now the system is throwing errors and is unusable for them.

However, I have had newer sites complain of this which makes me think they have someone created a serial without that information.  I'll see if I can replicate this.

joy


(In reply to Katrin Fischer from comment #1)
> Hi Joy, 
> 
> I haven't seen this happening and haven't managed to create a serial issue
> without planned date - do you have some more information on it? On which
> page does it happen? Is it migrated data or date added to Koha manually?
Comment 3 Jonathan Druart 2015-07-10 15:29:48 UTC
Joy, are you able to give more info to reproduce this issue?
Comment 4 Owen Leonard 2016-06-22 16:28:30 UTC
I'm going to assume this is no longer an issue since no follow-up information has been provided.