Bug 41745 - syspref's types need cleaning
Summary: syspref's types need cleaning
Status: NEW
Alias: None
Product: Koha
Classification: Unclassified
Component: Architecture, internals, and plumbing (show other bugs)
Version: unspecified
Hardware: All All
: P5 - low normal
Assignee: Jonathan Druart
QA Contact: Testopia
URL:
Keywords:
Depends on: 41682
Blocks:
  Show dependency treegraph
 
Reported: 2026-02-02 09:13 UTC by Jonathan Druart
Modified: 2026-02-03 01:17 UTC (History)
2 users (show)

See Also:
GIT URL:
Initiative type: ---
Sponsorship status: ---
Comma delimited list of Sponsors:
Crowdfunding goal: 0
Patch complexity: ---
Documentation contact:
Documentation submission:
Text to go in the release notes:
Version(s) released in:
Circulation function:


Attachments

Note You need to log in before you can comment on or make changes to this bug.
Description Jonathan Druart 2026-02-02 09:13:39 UTC
Clean 'type' and make it an ENUM

> select distinct type from systempreferences;
+-------------------+
| type              |
+-------------------+
| textarea          |
| Free              |
| YesNo             |
| Choice            |
| Integer           |
|                   |
| multiple          |
| ill-backends      |
| ClassSources      |
| NULL              |
| File              |
| multiple_sortable |
| Themes            |
| Languages         |
| Short             |
+-------------------+

NULL, File, Short and empty string are not valid types.