From 31375163f16b17b13d3c6992ed9b4ddc4e214459 Mon Sep 17 00:00:00 2001 From: Andrew Dolgov Date: Fri, 16 Jan 2009 17:52:39 +0100 Subject: [PATCH] getCategoryCounters: fix broken psql syntax --- functions.php | 10 ++++------ 1 file changed, 4 insertions(+), 6 deletions(-) diff --git a/functions.php b/functions.php index c84a7a7b..ebd3cff1 100644 --- a/functions.php +++ b/functions.php @@ -2330,12 +2330,10 @@ $age_qpart = getMaxAgeSubquery(); - $result = db_query($link, "SELECT cat_id, value AS unread - FROM ttrss_feeds, ttrss_cat_counters_cache - WHERE - ttrss_cat_counters_cache.feed_id = cat_id AND - hidden = false AND - ttrss_feeds.owner_uid = ".$_SESSION["uid"]); + $result = db_query($link, "SELECT id AS cat_id, value AS unread + FROM ttrss_feed_categories, ttrss_cat_counters_cache + WHERE ttrss_cat_counters_cache.feed_id = id AND + ttrss_feed_categories.owner_uid = " . $_SESSION["uid"]); while ($line = db_fetch_assoc($result)) { $line["cat_id"] = sprintf("%d", $line["cat_id"]); -- 2.39.2