From 22b5e8c1c6f06479af2fddf8fc69e09331073248 Mon Sep 17 00:00:00 2001 From: Chris Sharp Date: Thu, 11 Oct 2012 19:33:16 -0400 Subject: [PATCH] Adding a WHERE clause to prevent timeout of juv-to-adult function Signed-off-by: Chris Sharp Signed-off-by: Galen Charlton --- .../lib/OpenILS/Application/Storage/Publisher/actor.pm | 3 ++- 1 file changed, 2 insertions(+), 1 deletion(-) diff --git a/Open-ILS/src/perlmods/lib/OpenILS/Application/Storage/Publisher/actor.pm b/Open-ILS/src/perlmods/lib/OpenILS/Application/Storage/Publisher/actor.pm index d41dfcc735..8fa6c448c0 100644 --- a/Open-ILS/src/perlmods/lib/OpenILS/Application/Storage/Publisher/actor.pm +++ b/Open-ILS/src/perlmods/lib/OpenILS/Application/Storage/Publisher/actor.pm @@ -32,7 +32,8 @@ sub juv_to_adult { my $sql = <<" SQL"; UPDATE actor.usr SET juvenile = FALSE - WHERE AGE(dob) > ?::INTERVAL; + WHERE AGE(dob) > ?::INTERVAL + AND juvenile IS TRUE; SQL my $sth = actor::user->db_Main->prepare_cached($sql); -- 2.43.2