[Koha-bugs] [Bug 10185] updatedatabase.pl remove all reserves
bugzilla-daemon at bugs.koha-community.org
bugzilla-daemon at bugs.koha-community.org
Tue May 7 08:45:19 CEST 2013
http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=10185
--- Comment #14 from Katrin Fischer <katrin.fischer at bsz-bw.de> ---
Created attachment 17973
-->
http://bugs.koha-community.org/bugzilla3/attachment.cgi?id=17973&action=edit
[PASSED QA] Bug 10185: Add missing columns in update 3.09.00.025
Signed-off-by: Katrin Fischer <Katrin.Fischer.83 at web.de>
SQL only changes fixing an important database update.
IMPORTANT: Patches must be backported to all versions containing
the database update 3.09.00.025.
I used the test plan provided by Julian with some additions:
1/ Do a fresh 3.8 install
2/ Do some reserves
3/ Check your old_reserves table is empty
4/ Update your sources to 3.10
5/ Run updatedatabase.pl
6/ Your reserves table is now empty!
I made sure I had item level and title level holds, also
suspended holds.
I repeated the test with entries in my old_reserves table
(cancelled and filled holds) to make sure this is also still
working correctly.
Before the patch we lost all suspended holds and when the
old_reserves table was empty also all holds in general.
After the patch the reserve_id is added but the other data
in both tables is not altered.
NOTE: Adding the reserve_id first to old_reserves and then
to reserves we are missing one id in between.
old_reserves: 1,2,3
reserves: 5,6
--
You are receiving this mail because:
You are watching all bug changes.
More information about the Koha-bugs
mailing list