[Koha-bugs] [Bug 24010] Number of issues to display to staff accepts non-integer values

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

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

--- Comment #19 from Owen Leonard <oleonard at myacpl.org> ---
The atomicupdate file needs to be updated to use our current syntax, and I
think it needs this addition:

If you've got existing subscriptions but you didn't specify a number for
staffdisplaycount and opacdisplaycount, those columns will contain an empty
string.

The database update checks to see if the columns can be updated to INT and
aborts if not.  But it should be reasonable to start by updating empty entries
to make them NULL isn't it?

update subscriptions set staffdisplaycount = NULL where staffdisplaycount = '';

update subscriptions set opacdisplaycount = NULL where opacdisplaycount = '';

Then the db update can proceed automatically even if there are existing blank
values.

If that's correct, can someone take a crack at updating the atomicupdate file?

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