implement old log entry purging in update_daemon_common; add some more error types...

[tt-rss.git] / include / rssfuncs.php

diff --git a/include/rssfuncs.php b/include/rssfuncs.php
index b3bf25849d163aaff25d6adb599790caea87280a..0a20f5d8ea4438b7caf1f6ab4bf4ad46a0ad0060 100644 (file)
--- 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...");