[Koha-bugs] [Bug 2635] New: Adding non-digit chars to cost fields in items causes data corruption
bugzilla-daemon at pippin.metavore.com
bugzilla-daemon at pippin.metavore.com
Tue Sep 23 22:50:59 CEST 2008
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 at foundations.edu
ReportedBy: cnighswonger at foundations.edu
QAContact: koha-bugs at 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.
More information about the Koha-bugs
mailing list