From 2240601ccf4ff9e9a25a2bc71eb0d2d6f826c9ee Mon Sep 17 00:00:00 2001 From: Andrew Dolgov Date: Thu, 24 Jan 2008 18:54:36 +0100 Subject: daemons: fix feed select query for PGSQL --- update_daemon_loop.php | 5 ++--- 1 file changed, 2 insertions(+), 3 deletions(-) (limited to 'update_daemon_loop.php') diff --git a/update_daemon_loop.php b/update_daemon_loop.php index 08fad1b97..4c13dedce 100644 --- a/update_daemon_loop.php +++ b/update_daemon_loop.php @@ -116,13 +116,12 @@ } if (DB_TYPE == "pgsql") { - $update_limit_qpart = "AND ttrss_feeds.last_updated < NOW() - INTERVAL '".(DAEMON_SLEEP_INTERVAL*2)." seconds'"; $update_limit_qpart = "AND (( ttrss_feeds.update_interval = 0 - AND ttrss_feeds.last_updated < NOW() - INTERVAL ttrss_user_prefs.value || ' minutes' + AND ttrss_feeds.last_updated < NOW() - CAST((ttrss_user_prefs.value || ' minutes') AS INTERVAL) ) OR ( ttrss_feeds.update_interval > 0 - AND ttrss_feeds.last_updated < NOW() - INTERVAL ttrss_feeds.update_interval || ' minutes' + AND ttrss_feeds.last_updated < NOW() - CAST((ttrss_feeds.update_interval || ' minutes') AS INTERVAL) ))"; } else { $update_limit_qpart = "AND (( -- cgit v1.2.3-54-g00ecf