[Koha-bugs] [Bug 32511] Circulation statistics result Error 500 where select Collection, Shelving location, Home library or Holding library

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

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

--- Comment #24 from Hammat wele <hammat.wele at inlibro.com> ---
(In reply to Jonathan Druart from comment #22)
> (In reply to Hammat wele from comment #21)
> > > Do you know the number?
> > > 
> > > That one should especially be available in deleteditems and we need to
> > > figure out what happened there.
> > > 
> > > Either the update patch didn't work... or something got backported that had
> > > it without the change in the db?
> > 
> > The items table has 46 columns and the deleteditems has 45 columns.
> 
> Which column was missing? Which version of Koha?

In my local test database, I intentionally deleted the `deleted_on` column to
be able to reproduce the problem. I got the database structure on which @blou
detected the problem (in Comment 6 ) and the missing column in the deleteditems
table is a column named `paidfor` which is not present in the items table.

I think we added the `paidfor` column in items table and didn't to add it in
deleteditems table. that's where the problem came from.

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