From 30ce47a436eed93870e9b4a396a8c134e1a423a8 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. --- C4/Items.pm | 15 ++++++++------- 1 file changed, 8 insertions(+), 7 deletions(-) diff --git a/C4/Items.pm b/C4/Items.pm index feed7b0..a1e3b05 100644 --- a/C4/Items.pm +++ b/C4/Items.pm @@ -2278,13 +2278,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.1.0