[Koha-bugs] [Bug 5458] New: length of items.ccode disagrees with authorised_values.authorised_value

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

http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=5458

           Summary: length of items.ccode disagrees with
                    authorised_values.authorised_value
 Change sponsored?: ---
           Product: Koha
           Version: unspecified
          Platform: All
        OS/Version: All
            Status: NEW
          Severity: normal
          Priority: P5
         Component: Database
        AssignedTo: gmcharlt at gmail.com
        ReportedBy: pete.huerter at gmail.com
         QAContact: koha-bugs at lists.koha-community.org
   Estimated Hours: 0.0


Koha allows you to define an authorised value having length 80, but then you
can't use it.

Here is why:

The SQL field items.ccode is a varchar(10).

The SQL field authorised_values.authorised_value is a varchar(80).

Therefore the authorised value is truncated to length 10 in items.ccode and the
mapping from authorised value to description string fails in Koha.

Not sure how this change will "bubble up" in Koha but the change to the table
schema seems straightforward:  increase the size of items.ccode to varchar(80).
 This is preferable to shortening authorised_values.authorised_value since we
have many category codes (CCODE) that are longer than length 10.

-- 
Configure bugmail: http://bugs.koha-community.org/bugzilla3/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are the QA contact for the bug.