[Koha-bugs] [Bug 11221] New patrons are created with invalid dateofbirth value if field is left empty

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

http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=11221

Katrin Fischer <katrin.fischer at bsz-bw.de> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
  Attachment #22978|0                           |1
        is obsolete|                            |
  Attachment #22979|0                           |1
        is obsolete|                            |

--- Comment #5 from Katrin Fischer <katrin.fischer at bsz-bw.de> ---
Created attachment 22993
  -->
http://bugs.koha-community.org/bugzilla3/attachment.cgi?id=22993&action=edit
[PASSED QA] Bug 11221: SQLHelper::_filter_hash does not manage well dates

The default values for date fields is undef, so if a date field contains
an empty string, we should insert NULL in the DB.
The format_date_in_iso routine should be only called if a date is
defined, is not equal to an empty string and does not match the iso
regex.

Partial test plan:
1. Create a new patron. Leave dateofbirth empty.
2. Save the record.
3. Open the record for editing.
4. Save the record without making changes.
5. Koha gives no error.

Signed-off-by: Chris Cormack <chris at bigballofwax.co.nz>
Signed-off-by: Katrin Fischer <Katrin.Fischer.83 at web.de>
Passes all tests and QA script.
Now when no date is given NULL is saved to the database.

Tested:
- Adding a patron without date of birth
- Editing the patron, entering a date of birth
- Editing the patron, deleting date of birth
All worked as expected.

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