From 123a764372fa614c2e68b641bf358ca4b39cfb6c Mon Sep 17 00:00:00 2001 From: Andrew Dolgov Date: Tue, 5 Mar 2013 15:36:25 +0400 Subject: getLabelCounters: add caption to group by to fix query failing on pgsql 8.4 (refs #545) --- include/functions.php | 3 ++- 1 file changed, 2 insertions(+), 1 deletion(-) (limited to 'include') 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)) { -- cgit v1.2.3