[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