http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=8002 Priority: P5 - low Change sponsored?: --- Bug ID: 8002 CC: gmcharlt@gmail.com Assignee: paul.poulain@biblibre.com Summary: Can't add patron attribute type in newer installation QA Contact: koha.sekjal@gmail.com Severity: major Classification: Unclassified OS: All Reporter: oleonard@myacpl.org Hardware: All Status: NEW Version: master Component: System Administration Product: Koha The patch for Bug 7154 (Group borrower attributes and link between patron category and attribute) contains this in updatedatabase.pl: $dbh->do("ALTER TABLE borrower_attribute_types ADD COLUMN category_code VARCHAR(10) NULL DEFAULT NULL AFTER `display_checkout`"); ...which allows borrower_attribute_types.category_code to be NULL. However, the addition to kohastructure.sql includes: `category_code` VARCHAR(1) NOT NULL DEFAULT '',-- defines a category for an attribute_type ...which requires that it /not/ be NULL. Users of new installations will find that they cannot add patron attribute types if they don't limit it to a patron category. After trying to add a record without a patron category limit the user will be told the operation was successful but the entry will not be saved. An error appears in the log: patron-attr-types.pl: DBD::mysql::st execute failed: Column 'category_code' cannot be null at /home/oleonard/kohaclone/C4/Members/AttributeTypes.pm line 220 -- You are receiving this mail because: You are watching all bug changes.