[Koha-bugs] [Bug 34063] New: items.paidfor haunting beyond the grave

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

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

            Bug ID: 34063
           Summary: items.paidfor haunting beyond the grave
 Change sponsored?: ---
           Product: Koha
           Version: master
          Hardware: All
                OS: All
            Status: NEW
          Severity: normal
          Priority: P5 - low
         Component: Architecture, internals, and plumbing
          Assignee: koha-bugs at lists.koha-community.org
          Reporter: dcook at prosentient.com.au
        QA Contact: testopia at bugs.koha-community.org
        Depends on: 26268

Bug 26268 only drops the column items.paidfor if the column is empty. If there
is a value, a warning message is displayed, but the database upgrade completes
successfully.

So you may end up with 47 columns in your items table in Koha 22.11 while the
deleteditems table only has 46 columns.

This will cause scripts like /cgi-bin/koha/reports/issues_stats.pl to bust with
a 500 error since it can't do a * union on those two tables with a different
number of columns.


Referenced Bugs:

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=26268
[Bug 26268] Remove items.paid for once and for all
-- 
You are receiving this mail because:
You are watching all bug changes.
You are the assignee for the bug.