[Koha-bugs] [Bug 2934] New: Wrong datatype causes artificial limit to label batch id's

[bugzilla-daemon at pippin.metavore.com]

http://bugs.koha.org/cgi-bin/bugzilla/show_bug.cgi?id=2934

           Summary: Wrong datatype causes artificial limit to label batch
                    id's
           Product: Koha
           Version: rel_3_0
          Platform: PC
        OS/Version: All
            Status: NEW
          Severity: normal
          Priority: P3
         Component: Database
        AssignedTo: galen.charlton at liblime.com
        ReportedBy: cnighswonger at foundations.edu
         QAContact: koha-bugs at lists.koha.org


labels.batch_id being typed as varchar(10) causes 'SELECT MAX(DISTINCT
batch_id) FROM labels;' to always return a value of '99' once the value of the
field reaches 100.

labels.batch_id should be int as the value is always an integer. This corrects
the problem.

I'm submitting a patch for this built against the current 3.0.x branch. It
should be ported forward to the current 3.1 branch as well.




------- You are receiving this mail because: -------
You are the QA contact for the bug, or are watching the QA contact.