http://bugs.koha.org/cgi-bin/bugzilla/show_bug.cgi?id=2635 Summary: Adding non-digit chars to cost fields in items causes data corruption Product: Koha Version: unspecified Platform: PC URL: cgi-bin/koha/cataloguing/additem.pl OS/Version: All Status: NEW Severity: normal Priority: PATCH-Sent Component: Cataloging AssignedTo: cnighswonger@foundations.edu ReportedBy: cnighswonger@foundations.edu QAContact: koha-bugs@lists.koha.org Adding a non-digit char to either cost field on the add/edit item form causes data corruption due to storing the item cost info in biblioitems.marcxml (longtext) as well as items.cost and items.replacementcost (both integer). Thus if we enter '$10.00' the items fields end up NULL while '$10.00' is stored in the marcxml field. This causes problems when item data is retrieved from the items table rather than the biblioitems.marcxml record. One fix is to check the data submitted for that field for chars other than digits and return an error to the user if such chars exist. I am submitting a patch to do this. ------- You are receiving this mail because: ------- You are the QA contact for the bug, or are watching the QA contact.