Bug 30501 - sysprefs.sql has an error
Summary: sysprefs.sql has an error
Alias: None
Product: Koha
Classification: Unclassified
Component: Architecture, internals, and plumbing (show other bugs)
Version: Main
Hardware: All All
: P1 - high critical (vote)
Assignee: Bugs List
QA Contact: Martin Renvoize
Depends on: 29990
  Show dependency treegraph
Reported: 2022-04-08 20:44 UTC by Lucas Gass
Modified: 2022-12-12 21:24 UTC (History)
2 users (show)

See Also:
Change sponsored?: ---
Patch complexity: ---
Documentation contact:
Documentation submission:
Text to go in the release notes:
Version(s) released in:

Bug 30501: Fix typo in sysprefs.sql (1.78 KB, patch)
2022-04-08 21:09 UTC, Lucas Gass
Details | Diff | Splinter Review
Bug 30501: Fix typo in sysprefs.sql (1.85 KB, patch)
2022-04-11 11:46 UTC, Martin Renvoize
Details | Diff | Splinter Review

Note You need to log in before you can comment on or make changes to this bug.
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 🦄