Bug 30501

Summary: sysprefs.sql has an error
Product: Koha Reporter: Lucas Gass <lucas>
Component: Architecture, internals, and plumbingAssignee: Bugs List <koha-bugs>
Status: CLOSED FIXED QA Contact: Martin Renvoize <martin.renvoize>
Severity: critical    
Priority: P1 - high CC: kyle, martin.renvoize
Version: master   
Hardware: All   
OS: All   
Change sponsored?: --- Patch complexity: ---
Documentation contact: Documentation submission:
Text to go in the release notes:
Version(s) released in:
22.05.00
Bug Depends on: 29990    
Bug Blocks:    
Attachments: Bug 30501: Fix typo in sysprefs.sql
Bug 30501: Fix typo in sysprefs.sql

Description Lucas Gass 2022-04-08 20:44:08 UTC
If you try to run updatedatabase or reset_all you'll get an error from sysprefs.sql.

I think it's because of this line:

('ShowHeadingUse', '0', NULL, 'Show whether authority record contains an established heading that conforms to descriptive cataloguing rules, and can therefore be used as a main/added entry, or subject, or series title', 'YesNo'
Comment 1 Lucas Gass 2022-04-08 21:09:34 UTC
Created attachment 133125 [details] [review]
Bug 30501: Fix typo in sysprefs.sql
Comment 2 Martin Renvoize 2022-04-11 11:46:52 UTC
Created attachment 133149 [details] [review]
Bug 30501: Fix typo in sysprefs.sql

Signed-off-by: Martin Renvoize <martin.renvoize@ptfs-europe.com>
Comment 3 Martin Renvoize 2022-04-11 11:48:14 UTC
This matches the follow-up in bug 29990 and works perfectly.

I'm Passing QA and promoting to critical as it stop k-t-d from starting among other things.. we need this pushed asap
Comment 4 Fridolin Somers 2022-04-11 13:29:21 UTC
Pushed to master for 22.05, thanks to everybody involved 🦄