@@ -, +, @@ NOW() --- C4/Reserves.pm | 15 +++++++++++---- 1 file changed, 11 insertions(+), 4 deletions(-) --- a/C4/Reserves.pm +++ a/C4/Reserves.pm @@ -1375,20 +1375,27 @@ sub ModReserveAffect { } else { # affect the reserve to Waiting as well. - my $item = C4::Items::GetItem( $itemnumber ); - my $maxpickupdate = GetMaxPickupDate( undef, $item ); $query = " UPDATE reserves SET priority = 0, found = 'W', waitingdate = NOW(), - maxpickupdate = ?, itemnumber = ? WHERE borrowernumber = ? AND biblionumber = ? "; $sth = $dbh->prepare($query); - $sth->execute( $maxpickupdate, $itemnumber, $borrowernumber,$biblionumber); + $sth->execute( $itemnumber, $borrowernumber,$biblionumber); + my $item = C4::Items::GetItem( $itemnumber ); + $query = " + UPDATE reserves + SET maxpickupdate = ? + WHERE borrowernumber = ? + AND biblionumber = ? + "; + my $maxpickupdate = GetMaxPickupDate( undef, $item ); + $sth = $dbh->prepare($query); + $sth->execute( $maxpickupdate, $borrowernumber, $biblionumber ); } _koha_notify_reserve( $itemnumber, $borrowernumber, $biblionumber ) if ( !$transferToDo && !$already_on_shelf ); --