Fix category count query for mysql

[tt-rss.git] / classes / pref_feeds.php

diff --git a/classes/pref_feeds.php b/classes/pref_feeds.php
index bf9f18a94c7e74e4f3147fa4d87ebff267f4630e..1f875ba1201a49b03f633953cef24d77f0ddd529 100644 (file)
--- a/classes/pref_feeds.php
+++ b/classes/pref_feeds.php
@@ -1192,7 +1192,7 @@ class Pref_Feeds extends Protected_Handler {
 
                print "</div>";
 
-               $result = db_query($this->link, "SELECT c.title, c.id,COUNT(f.*) AS count
+               $result = db_query($this->link, "SELECT c.title, c.id,COUNT(f.id) AS count
                        FROM ttrss_feed_categories AS c LEFT JOIN ttrss_feeds AS f ON
                                (f.cat_id = c.id)
                        WHERE c.owner_uid = ".$_SESSION["uid"]."