aboutsummaryrefslogtreecommitdiffstats
diff options
context:
space:
mode:
authorMax Kostikov <max@kostikov.co>2019-11-01 10:46:49 +0100
committerMax Kostikov <max@kostikov.co>2019-11-01 10:46:49 +0100
commit69533ce8f5eb61ea4da2cbed1c91c5c743dc4645 (patch)
treee7108a2cfad474f1450d896815792625881575a3
parent9fac43a3a3f1993e4ffaa543da6a6b3e175fc7f4 (diff)
downloadvolse-hubzilla-69533ce8f5eb61ea4da2cbed1c91c5c743dc4645.tar.gz
volse-hubzilla-69533ce8f5eb61ea4da2cbed1c91c5c743dc4645.tar.bz2
volse-hubzilla-69533ce8f5eb61ea4da2cbed1c91c5c743dc4645.zip
Add missed interval in SQL query
-rw-r--r--Zotlabs/Daemon/Cron.php2
1 files changed, 1 insertions, 1 deletions
diff --git a/Zotlabs/Daemon/Cron.php b/Zotlabs/Daemon/Cron.php
index 94d2b634f..8835d8fca 100644
--- a/Zotlabs/Daemon/Cron.php
+++ b/Zotlabs/Daemon/Cron.php
@@ -97,7 +97,7 @@ class Cron {
// Clean expired photos from cache
- $sql_interval = db_utcnow() . ' - ' . db_quoteinterval(get_config('system','active_expire_days', '30') . ' DAY');
+ $sql_interval = db_utcnow() . ' - INTERVAL ' . db_quoteinterval(get_config('system','active_expire_days', '30') . ' DAY');
$r = q("SELECT DISTINCT xchan, content FROM photo WHERE photo_usage = %d AND expires < $sql_interval",
intval(PHOTO_CACHE)
);