]> git.wh0rd.org - tt-rss.git/commitdiff
getFeedCounters: fix invalid query
authorAndrew Dolgov <fox@bah.spb.su>
Tue, 19 Jun 2007 12:54:11 +0000 (13:54 +0100)
committerAndrew Dolgov <fox@bah.spb.su>
Tue, 19 Jun 2007 12:54:11 +0000 (13:54 +0100)
functions.php

index 253223acd5a9bacb36ef066d268ae115baf034b7..b00c6b0dd3fea1ee53854fbb007aac012484d04d 100644 (file)
                $result = db_query($link, "SELECT ttrss_feeds.id,
                                SUBSTRING(ttrss_feeds.last_updated,1,19) AS last_updated, 
                                last_error, 
-                               COUNT(ttrss_entries.id) 
+                               COUNT(ttrss_entries.id) AS count 
                        FROM ttrss_feeds 
                                LEFT JOIN ttrss_user_entries ON (ttrss_user_entries.feed_id = ttrss_feeds.id 
                                        AND ttrss_user_entries.owner_uid = ttrss_feeds.owner_uid