aboutsummaryrefslogtreecommitdiffstats
diff options
context:
space:
mode:
authorMax Kostikov <max@kostikov.co>2019-11-02 10:36:04 +0100
committerMax Kostikov <max@kostikov.co>2019-11-02 10:36:04 +0100
commit74ef5f38e9bf4642c6e752ad365ae20ead394e56 (patch)
treefec0095482946b586a6be780a79d51fa1b67d010
parentfc658a25d7eb05f0c7f6ed90f5d53c7c327bed23 (diff)
downloadvolse-hubzilla-74ef5f38e9bf4642c6e752ad365ae20ead394e56.tar.gz
volse-hubzilla-74ef5f38e9bf4642c6e752ad365ae20ead394e56.tar.bz2
volse-hubzilla-74ef5f38e9bf4642c6e752ad365ae20ead394e56.zip
Fix start time to sync queries on photo cache purge
-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 8835d8fca..7b951e7d4 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() . ' - INTERVAL ' . db_quoteinterval(get_config('system','active_expire_days', '30') . ' DAY');
+ $sql_interval = "'" . dbesc(datetime_convert()) . "' - 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)
);