From e2261e177bc9f5308185d91783ca128000c6fd87 Mon Sep 17 00:00:00 2001 From: Andrew Dolgov Date: Tue, 16 Apr 2013 20:34:20 +0400 Subject: implement old log entry purging in update_daemon_common; add some more error types; tweak error log display --- include/rssfuncs.php | 14 ++++++++++++++ 1 file changed, 14 insertions(+) (limited to 'include/rssfuncs.php') diff --git a/include/rssfuncs.php b/include/rssfuncs.php index b3bf25849..0a20f5d8e 100644 --- a/include/rssfuncs.php +++ b/include/rssfuncs.php @@ -148,6 +148,7 @@ expire_cached_files($debug); expire_lock_files($debug); + expire_error_log($link, $debug); $nf = 0; @@ -1197,6 +1198,19 @@ return $doc->saveXML($node); } + function expire_error_log($link, $debug) { + if ($debug) _debug("Removing old error log entries..."); + + if (DB_TYPE == "pgsql") { + db_query($link, "DELETE FROM ttrss_error_log + WHERE created_at < NOW() - INTERVAL '7 days'"); + } else { + db_query($link, "DELETE FROM ttrss_error_log + WHERE created_at < DATE_SUB(NOW(), INTERVAL 7 DAY)"); + } + + } + function expire_lock_files($debug) { if ($debug) _debug("Removing old lock files..."); -- cgit v1.2.3