@@ -, +, @@ MySQLisms, replace by CAST(now() AS date). --- C4/Reserves.pm | 2 +- 1 files changed, 1 insertions(+), 1 deletions(-) --- a/C4/Reserves.pm +++ a/C4/Reserves.pm @@ -912,7 +912,7 @@ sub AutoUnsuspendReserves { my $dbh = C4::Context->dbh; - my $query = "UPDATE reserves SET suspend = 0, suspend_until = NULL WHERE DATE( suspend_until ) < DATE( CURDATE() )"; + my $query = "UPDATE reserves SET suspend = 0, suspend_until = NULL WHERE DATE( suspend_until ) < CAST(now() AS date)"; my $sth = $dbh->prepare( $query ); $sth->execute(); --