Bug 41745

Summary: syspref's types need cleaning
Product: Koha Reporter: Jonathan Druart <jonathan.druart>
Component: Architecture, internals, and plumbingAssignee: Jonathan Druart <jonathan.druart>
Status: NEW --- QA Contact: Testopia <testopia>
Severity: normal    
Priority: P5 - low CC: david, dcook
Version: unspecified   
Hardware: All   
OS: All   
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:
Bug Depends on: 41682    
Bug Blocks:    

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.