[Koha-bugs] [Bug 36466] Incorrect date value stored when "Published on" or "Expected on" are empty

[bugzilla-daemon at bugs.koha-community.org]

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=36466

--- Comment #2 from Hammat wele <hammat.wele at inlibro.com> ---
Created attachment 164155
  -->
https://bugs.koha-community.org/bugzilla3/attachment.cgi?id=164155&action=edit
Bug 36466: Incorrect date value stored when 'Published on' or 'Expected on' are
empty

When we edit a serial and we leave the date fields ('Published on' or 'Expected
on') empty
incorrect date are saved in the database 0000-00-00 instade of current date and
we get Error 500

to reproduce
1. Connect to staff interface
2. Go to Serials and create a new subscription
3. Click on Serial collection in the left menu (and note the Subscription
numnber)
4. Select a serial to edit and Click on «Edit serials»
5. In the Serial edition form, delete «Published on > and « Expected on » dates
and save
 ----> Error 500 page is displayed
6. Check the value of «Published on > and « Expected on » dates  in the
database
    select planneddate,publisheddate from serial where
subscriptionid=<Subscription numnber in step 3>;
    ------> planneddate publisheddate have «0000-00-00» value
7. Apply the patch
8. repeat step 2, 3, 4, 5, 6
 ----->  Error 500 page is no more displayed
 -----> «Published on » and « Expected on » field have today date

-- 
You are receiving this mail because:
You are watching all bug changes.