Bug 5086

Summary: claim date broken in serials
Product: Koha Reporter: Katrin Fischer <katrin.fischer>
Component: SerialsAssignee: Colin Campbell <colin.campbell>
Status: CLOSED FIXED QA Contact: Bugs List <koha-bugs>
Severity: normal    
Priority: PATCH-Sent (DO NOT USE) CC: gmcharlt
Version: rel_3_2   
Hardware: All   
OS: All   
URL: /cgi-bin/koha/serials/claims.pl
Change sponsored?: --- Patch complexity: ---
Documentation contact: Documentation submission:
Text to go in the release notes:
Version(s) released in:
Attachments: wrong claim date in serials
Proposed Patch

Description Katrin Fischer 2010-08-04 11:03:04 UTC
Created attachment 2449 [details]
wrong claim date in serials

If you claim issues in serials claim date is set to 0000-00-00.

I tried different dateformat sys pref settings.

Tested with Koha version 3.01.00.145
Comment 1 Colin Campbell 2010-08-04 12:00:52 UTC
The code that sets the date was omitting the necessary quotes around the date
Comment 2 Colin Campbell 2010-08-04 12:01:49 UTC
Created attachment 2451 [details] [review]
Proposed Patch
Comment 3 Galen Charlton 2010-10-06 11:46:48 UTC
Pushed an alternate version of the patch that also removes the SQL injection risk.  Please test and close.
Comment 4 Katrin Fischer 2010-10-10 22:14:21 UTC
Tested successfully with 3.2 RC. Closing bug.