Bug 41834

Summary: Remove systempreferences's options, explanation and type DB values
Product: Koha Reporter: Jonathan Druart <jonathan.druart>
Component: Architecture, internals, and plumbingAssignee: Jonathan Druart <jonathan.druart>
Status: ASSIGNED --- QA Contact: Testopia <testopia>
Severity: enhancement    
Priority: P5 - low CC: david, dcook, tomascohen
Version: unspecified   
Hardware: All   
OS: All   
See Also: https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=41800
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=41745
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=41746
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: 41837, 41833    
Bug Blocks:    
Attachments: Bug 41834: Set systempreferences's options, explanation and type to NULL

Description Jonathan Druart 2026-02-12 09:56:19 UTC
We currently have to set options, explanation and type in sysprefs.sql and the atomic/dbrev files.
However we (almost) never use them, we rely on the values in the yml files.

We could remove them and don't require them when when add new sysprefs.

It will avoid the mess we currently have (mismatch between new and updated installations, see bug 41682 and bug 41800).
Comment 1 Jonathan Druart 2026-03-02 15:59:47 UTC
Created attachment 194343 [details] [review]
Bug 41834: Set systempreferences's options, explanation and type to NULL

Patch from commit 637b6a5
Comment 2 David Cook 2026-03-02 22:53:30 UTC
This sounds really good. It drives me a bit crazy that we duplicate things between the DB and the YAML files.