From 2ed639cfb4a2bb57888fcbf3cd678d36d6a5325c Mon Sep 17 00:00:00 2001 From: Jonathan Druart Date: Fri, 10 Jul 2015 15:18:48 +0100 Subject: [PATCH] Bug 8723: Update hold_fill_targets, tmp_holdsqueue and linktracker tables Same as previous patch for 3 other tables. Test plan: Same as before but the hold should exist to the 3 tables before the move. Signed-off-by: Nick Clemens Signed-off-by: Katrin Fischer Signed-off-by: Tomas Cohen Arazi (cherry picked from commit c7a6745bc0e0241e5f39a12e2ff4e17678288b14) Signed-off-by: Chris Cormack (cherry picked from commit 74e6691cf84e51b20832b45cf7520aec85788771) Signed-off-by: Liz Rea --- C4/Items.pm | 15 ++++++++------- 1 file changed, 8 insertions(+), 7 deletions(-) diff --git a/C4/Items.pm b/C4/Items.pm index bf42277ddb..f3d492e1fb 100644 --- a/C4/Items.pm +++ b/C4/Items.pm @@ -2257,13 +2257,14 @@ sub MoveItemFromBiblio { C4::Acquisition::ModOrder($order); } - # Update holds - $dbh->do( q| - UPDATE reserves - SET biblionumber = ? - WHERE itemnumber = ? - |, undef, $tobiblio, $itemnumber ); - + # Update reserves, hold_fill_targets, tmp_holdsqueue and linktracker tables + for my $table_name ( qw( reserves hold_fill_targets tmp_holdsqueue linktracker ) ) { + $dbh->do( qq| + UPDATE $table_name + SET biblionumber = ? + WHERE itemnumber = ? + |, undef, $tobiblio, $itemnumber ); + } return $tobiblio; } return; -- 2.39.5