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 /include | |
| parent | 1f1d3224251aed56463caf1de24116fb4854992d (diff) | |
getLabelCounters: add caption to group by to fix query failing on pgsql 8.4 (refs #545)
Diffstat (limited to 'include')
| -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)) { |