https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=35190
Bug ID: 35190
Summary: additional_fields table should allow null values for
authorised_value_category
Change sponsored?: ---
Product: Koha
Version: master
Hardware: All
OS: All
Status: NEW
Severity: normal
Priority: P5 - low
Component: Architecture, internals, and plumbing
Assignee: [email protected]
Reporter: [email protected]
QA Contact: [email protected]
Blocks: 29390
When creating an Additional Field in the staff interface, the UI explicitly
allows the Additional Field not to be linked to an authorized value. However,
the database doesn't allow NULL values for authorised_value_category in the
additional_fields table. Instead, an empty string is inserted into the database
if the user chooses not to link an authorized value. This is not good practice,
and does not allow a foreign key constraint to be properly implemented.
Referenced Bugs:
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=29390
[Bug 29390] Authorised values: Add a few missing foreign keys
--
You are receiving this mail because:
You are watching all bug changes.
_______________________________________________
Koha-bugs mailing list
[email protected]
https://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-bugs
website : http://www.koha-community.org/
git : http://git.koha-community.org/
bugs : http://bugs.koha-community.org/
