diff options
author | Andrew Dolgov <[email protected]> | 2013-03-05 15:36:25 +0400 |
---|---|---|
committer | Andrew Dolgov <[email protected]> | 2013-03-05 15:36:25 +0400 |
commit | 123a764372fa614c2e68b641bf358ca4b39cfb6c (patch) | |
tree | 363bd64df75eb9c95a63bfa52d03011e6cfffe86 | |
parent | 1f1d3224251aed56463caf1de24116fb4854992d (diff) |
getLabelCounters: add caption to group by to fix query failing on pgsql 8.4 (refs #545)
-rw-r--r-- | include/functions.php | 3 |
1 files changed, 2 insertions, 1 deletions
diff --git a/include/functions.php b/include/functions.php index b381ff1ea..ccf798095 100644 --- a/include/functions.php +++ b/include/functions.php @@ -1414,7 +1414,8 @@ FROM ttrss_labels2 LEFT JOIN ttrss_user_labels2 ON (ttrss_labels2.id = label_id) LEFT JOIN ttrss_user_entries ON (ref_id = article_id AND unread = true) - WHERE ttrss_labels2.owner_uid = $owner_uid GROUP BY ttrss_labels2.id"); + WHERE ttrss_labels2.owner_uid = $owner_uid GROUP BY ttrss_labels2.id, + ttrss_labels2.caption"); while ($line = db_fetch_assoc($result)) { |