[Koha-bugs] [Bug 22275] New: 18.06.00.060 DB update fails (incomplete/incorrect defaults)

[bugzilla-daemon at bugs.koha-community.org]

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=22275

            Bug ID: 22275
           Summary: 18.06.00.060 DB update fails (incomplete/incorrect
                    defaults)
 Change sponsored?: ---
           Product: Koha
           Version: 18.11
          Hardware: All
                OS: All
            Status: NEW
          Severity: major
          Priority: P5 - low
         Component: Label/patron card printing
          Assignee: cnighswonger at foundations.edu
          Reporter: oliver.behnke at aei.mpg.de
        QA Contact: testopia at bugs.koha-community.org
  Target Milestone: ---

The DB schema changes in
https://bugs.koha-community.org/bugzilla3/attachment.cgi?id=82289 are
incomplete/incorrect.

1) Table "class_sources" gets its "class_split_rule" pre-filled with all
existing "class_sort_rule" counterparts, yet the "class_split_rules" table is
only filled with fixed presets. Thus adding the "class_source_ibfk_2"
constraint will fail as soon as there are more sort rules than split rules,
that is, as soon as there are any custom sort rules.

2) The "class_split_rules" preset values are apparently copied from the
"class_sort_rules" rules, leaving the "sorting rules" fragment in their
descriptions. Those are presumably meant to be called "splitting rules".

Best,
Oliver

-- 
You are receiving this mail because:
You are watching all bug changes.