From b99cbd1d893ff0a730ab7187f409bcdf3c6f4aeb Mon Sep 17 00:00:00 2001
From: "mkanat%kerio.com" <>
Date: Wed, 16 Mar 2005 08:27:14 +0000
Subject: Bug 174295: ANSI SQL requires all columns in SELECT to be in GROUP
 BY, unless they are in "aggregate" functions Patch By Tomas Kopal
 <Tomas.Kopal@altap.cz> r=joel, a=myk

---
 Bugzilla/Series.pm | 4 +++-
 1 file changed, 3 insertions(+), 1 deletion(-)

(limited to 'Bugzilla/Series.pm')

diff --git a/Bugzilla/Series.pm b/Bugzilla/Series.pm
index 3d4f301b9..e1d37423b 100644
--- a/Bugzilla/Series.pm
+++ b/Bugzilla/Series.pm
@@ -106,7 +106,9 @@ sub initFromDatabase {
         "WHERE series.series_id = $series_id AND " .
         "(public = 1 OR creator = " . Bugzilla->user->id . " OR " .
         "(ugm.group_id IS NOT NULL)) " . 
-        "GROUP BY series_id");
+        $dbh->sql_group_by('series.series_id', 'cc1.name, cc2.name, ' .
+                           'series.name, series.creator, series.frequency, ' .
+                           'series.query, series.public'));
     
     if (@series) {
         $self->initFromParameters(@series);
-- 
cgit v1.2.3-24-g4f1b