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

bugzilla-daemon at bugs.koha-community.org bugzilla-daemon at bugs.koha-community.org
Tue Sep 4 12:19:11 CEST 2018


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

--- Comment #3 from Fridolin SOMERS <fridolin.somers at biblibre.com> ---
Created attachment 78385
  -->
https://bugs.koha-community.org/bugzilla3/attachment.cgi?id=78385&action=edit
Bug 5458: increase ccode column to varchar 80

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.

This patch increases ccode column to varchar 80, like location.

Test plan :
1) Check there is on item field a subfield with authorised value category CCODE
2) Check this subfield is linked with database column items.ccode
3) Create an authorised values in category CCODE with 'DOCUMENTATION'
4) Edit an item on ccode and choose 'DOCUMENTATION'
5) Save item
6) Look at items.ccode in database or export in MARCXML
7) Without patch the value is troncated to 'DOCUMENTAT', not with patch

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


More information about the Koha-bugs mailing list