[Koha-bugs] [Bug 7241] circulation action logs record biblionumber instead of item number

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

http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=7241

Paul Poulain <paul.poulain at biblibre.com> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
             Status|Pushed to Master            |ASSIGNED

--- Comment #24 from Paul Poulain <paul.poulain at biblibre.com> ---
Well, Thinking of it a little bit more, I've reverted the patch.

Having history badly broken for existing instances is really bad, because we
will never be able to fix the problem properly once action_logs contains mixed
informations (biblio & items)

And I've an easy proposal to fix what can be fixed:
The following SQL:
UPDATE action_logs SET object=(SELECT itemnumber FROM items WHERE biblionumber=
action_logs.object LIMIT 1) WHERE module='CIRCULATION' AND action in
('ISSUE','RETURN');

Set the 1st item number (as we can't know which item was circulated once things
have been anonymised). It's better than nothing.

I propose that you submit a new patch including an updatedatabase with this SQL

Thanks

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