[Koha-bugs] [Bug 34063] items.paidfor and deleteditems.paidfor still sometimes exist

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

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

--- Comment #12 from David Cook <dcook at prosentient.com.au> ---
(In reply to Pedro Amorim from comment #11)
> Imo this issue needs to be handled by sys admins on systems that require it
> fixed.
> I think it's very unlikely to have data in this column, and even more
> unlikely for this data to be actually real and utilized data, however just
> dropping the column entirely would open a precedent and at the end of the
> day, someone may in fact be using it for some odd reason.
> 
> As a compromise I've submitted a patch that shows a warning in the about ->
> system information page to help guide sys admins in fixing it. This is just
> an idea, let me know if it makes sense or follow up if it you think it can
> be improved!

Yeah it's a tough one. The sad thing is that there's lots of possible
discrepancies in the Koha database, especially for ones that have been upgraded
many times over the years. That was my motivation for bug 34064 which adds an
"audit_database.pl" script to Koha 23.11. 

I wonder if we could couple audit_database.pl with about.pl indirectly. Like a
weekly cronjob that audits the database behind the scenes and updates something
that about.pl could check/display without having to do the calculations itself
in real time.

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