# HG changeset patch # User jbe # Date 1296919087 -3600 # Node ID 4d121276bf0439bc5c688522214eea03f9136357 # Parent 6bf35cfa3ba8749808f949924120b0ba1ef9ba98 Race condition fixed in "check_last_login"() diff -r 6bf35cfa3ba8 -r 4d121276bf04 core.sql --- a/core.sql Sat Feb 05 16:06:19 2011 +0100 +++ b/core.sql Sat Feb 05 16:18:07 2011 +0100 @@ -2077,6 +2077,7 @@ IF "system_setting_row"."member_ttl" NOTNULL THEN UPDATE "member" SET "active" = FALSE WHERE "active" = TRUE + AND "last_login"::date < 'today' AND "last_login_public" < (now() - "system_setting_row"."member_ttl")::date; END IF;