https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=24010
--- Comment #19 from Owen Leonard <[email protected]> --- 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. _______________________________________________ Koha-bugs mailing list [email protected] https://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-bugs website : http://www.koha-community.org/ git : http://git.koha-community.org/ bugs : http://bugs.koha-community.org/
