[Koha-bugs] [Bug 31727] Orphan records in circulation_rules and false positives after attempt to fix values to be empty or zeroes instead of missing

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

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

David Nind <david at davidnind.com> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
                 CC|                            |david at davidnind.com

--- Comment #9 from David Nind <david at davidnind.com> ---
Created attachment 141618
  -->
https://bugs.koha-community.org/bugzilla3/attachment.cgi?id=141618&action=edit
Bug 31727 - Database query results from testing

I've had a go at testing (using KTD).

After step 9, I have one extra rule - I'm not sure if this is an issue.

If it isn't an issue, I'm happy to sign off.

What I did:

1. Changed default circulation and fines rule:
   - Suspension in days (day): 2
   - Max. suspension duration (day): 5
   - Suspension charging interval: 1

2. Default checkout, hold and return policy
   - Standard rule for all libraries:
     . Total current checkouts allowed: 20
     . Total current on-site checkouts allowed: 20
     . Maximum total holds allowed (count): 25
     . Hold policy: From any library
     . Hold pickup library match: Not set
     . Return policy: Not set

3. Created "Default checkout, hold and return policy" rules for Franklin,
Midway, and Springfield:
   - Just used different numbers for the first 3 settings
   - Set hold policy differently for all three

4. Result for step 3 - 47 rows/rules [see attachment].

5. Result for step 5 - now have 63 rows/rules: 47 + 15 (3 libraries x 5 extra
rules) + 1 (extra rule for unseenrenewalsallowed for NULL - see row 51) [see
attachment].

6. Result for step 9 - now have 48 row/rules: still have one extra rule - row
51 [see attachment].

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