Bug 8060 - Wrong length for category_code in borrower_attribute_types
Summary: Wrong length for category_code in borrower_attribute_types
Status: CLOSED FIXED
Alias: None
Product: Koha
Classification: Unclassified
Component: Patrons (show other bugs)
Version: Main
Hardware: All All
: P5 - low normal (vote)
Assignee: Kyle M Hall
QA Contact:
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2012-05-08 22:31 UTC by Gaetan Boisson
Modified: 2015-06-04 23:23 UTC (History)
2 users (show)

See Also:
Change sponsored?: ---
Patch complexity: ---
Documentation contact:
Documentation submission:
Text to go in the release notes:
Version(s) released in:


Attachments

Note You need to log in before you can comment on or make changes to this bug.
Description Gaetan Boisson 2012-05-08 22:31:21 UTC
The category_code column in the borrower_attribute_types which is a varchar(1) is meant to refer to the categorycode column in the categories table which is a varchar(10).

Category codes get truncated when trying to restrict an extended attribute to a specified category, breaking the functionnality unless the categorycode is one letter long.
Comment 1 Katrin Fischer 2014-11-02 09:19:17 UTC
borrower_attribute_types.category_code is varchar(10) now.