[Koha-bugs] [Bug 21599] Incorrect decimal value: '' for column 'defaultreplacecost' - Cannot create item type
bugzilla-daemon at bugs.koha-community.org
bugzilla-daemon at bugs.koha-community.org
Thu Oct 18 14:52:40 CEST 2018
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=21599
Claire Gravely <claire_gravely at hotmail.com> changed:
What |Removed |Added
----------------------------------------------------------------------------
Attachment #80805|0 |1
is obsolete| |
--- Comment #3 from Claire Gravely <claire_gravely at hotmail.com> ---
Created attachment 80828
-->
https://bugs.koha-community.org/bugzilla3/attachment.cgi?id=80828&action=edit
Bug 21599: Fix item type creation by defining default values
Same as what we have in Koha::Patron->new, empty strings should not be
inserted in integer or date column type
DBD::mysql::st execute failed: Incorrect decimal value: '' for column
'defaultreplacecost' at row 1 [for Statement "INSERT INTO `itemtypes` (
`checkinmsg`, `checkinmsgtype`, `defaultreplacecost`, `description`,
`hideinopac`, `imageurl`, `itemtype`, `notforloan`, `processfee`,
`rentalcharge`, `searchcategory`, `sip_media_type`, `summary`) VALUES ( ?, ?,
?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ? )" with ParamValues: 0="", 1="message", 2="",
3="xx", 4=0, 5='', 6="XX", 7=0, 8="", 9="", 10="", 11=undef, 12=""] at
/usr/share/perl5/DBIx/Class/Storage/DBI.pm line 1832.
Test plan:
Create a new itemtype
Signed-off-by: Claire Gravely <claire.gravely at bsz-bw.de>
--
You are receiving this mail because:
You are watching all bug changes.
More information about the Koha-bugs
mailing list