[Koha-bugs] [Bug 28869] New: If authorized values for STACK (shelving control number) are > 127 things explode

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

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=28869

            Bug ID: 28869
           Summary: If authorized values for STACK (shelving control
                    number) are > 127 things explode
 Change sponsored?: ---
           Product: Koha
           Version: master
          Hardware: All
                OS: All
            Status: NEW
          Severity: normal
          Priority: P5 - low
         Component: Staff Client
          Assignee: koha-bugs at lists.koha-community.org
          Reporter: lucas at bywatersolutions.com
        QA Contact: testopia at bugs.koha-community.org
                CC: gmcharlt at gmail.com

The A.V. category of STACK maps to items.stack. In the schema (for master) it
claims items.stack but if I 'describe items' it tells me it is tinyint(1).


Tinyint can be anything between -128 and 127. 


To recreate:
-Add AV's for STACK that are greater than 127. 
-Edit an item and attempt to change the shelving control number to that value.
-See an error
-Add AV's less than 127
-Edit an item, things seem to work fine. 


Should items.stack be int?

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