From 10164196fb8f7ca98f6762b095e633797c04ee66 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 --- .../src/perlmods/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 1cb3dce467..2840396cb0 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.11.0