From 74ef5f38e9bf4642c6e752ad365ae20ead394e56 Mon Sep 17 00:00:00 2001 From: Max Kostikov Date: Sat, 2 Nov 2019 10:36:04 +0100 Subject: Fix start time to sync queries on photo cache purge --- Zotlabs/Daemon/Cron.php | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) (limited to 'Zotlabs/Daemon/Cron.php') 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) ); -- cgit v1.2.3