292866 - PostgreSQL: Clicking on either CSV, RSS, iCalendar links in buglist.cgi results in Internal Server Error

Status: RESOLVED DUPLICATE of bug 293015

(Bugzilla :: Query/Bug List, defect)

Description

[David Lawrence [:dkl]]

Using latest CVS head using a PostgreSQL backend, I get a SQL error when trying
to view a query result list as either CSV, RSS, or iCalendar. Seems
bugs_status.sortkey and bug_status.value are not being added to the @groupby
list and this generates an error with PostgreSQL.

-- Error Snippet --

[Wed May 04 12:24:44 2005] [error] [client 172.16.48.200] DBD::Pg::st execute
failed: ERROR:  column "bug_status.sortkey" must appear in the GROUP BY clause
or be used in an aggregate function, referer:
http://bugzilla.redhat.com/mozilla-tip/buglist.cgi?query_format=specific&order=relevance+desc&bug_status=__open__&product=Fedora+Extras+Package+Request&content=
[Wed May 04 12:24:44 2005] [error] [client 172.16.48.200]  [for Statement
"SELECT bugs.bug_id, bugs.bug_severity, bugs.priority, bugs.bug_status,
bugs.resolution, bugs.bug_severity, bugs.priority, bugs.rep_platform,
map_assigned_to.login_name, bugs.bug_status, bugs.resolution, bugs.short_desc
FROM bugs  INNER JOIN profiles AS map_assigned_to ON (bugs.assigned_to =
map_assigned_to.userid) LEFT JOIN bug_status ON (bug_status.value =
bugs.bug_status) LEFT JOIN bug_group_map ON bug_group_map.bug_id = bugs.bug_id 
AND bug_group_map.group_id NOT IN (3,7,10,5,1,8,11,4,2,6,9)  LEFT JOIN cc ON
cc.bug_id = bugs.bug_id AND cc.who = 1 WHERE ((bugs.bug_status IN
('UNCONFIRMED','NEW','ASSIGNED','REOPENED')) AND (bugs.product_id IN (1))) AND
((bug_group_map.group_id IS NULL)    OR (bugs.reporter_accessible = 1 AND
bugs.reporter = 1)     OR (bugs.cclist_accessible = 1 AND cc.who IS NOT NULL)  
  OR (bugs.assigned_to = 1) ) GROUP BY bugs.bug_id, bugs.bug_severity,
bugs.priority, bugs.bug_status, bugs.resolution, bugs.rep_platform,
map_assigned_to.login_name, bugs.short_desc ORDER BY bug_status.sortkey
,bug_status.value , bugs.priority, map_assigned_to.login_name, bugs.bug_id"] at
/var/www/bugzilla/mozilla-tip/buglist.cgi line 820, referer:
http://bugzilla.redhat.com/mozilla-tip/buglist.cgi?query_format=specific&order=relevance+desc&bug_status=__open__&product=Fedora+Extras+Package+Request&content=
[Wed May 04 12:24:44 2005] [error] [client 172.16.48.200] Premature end of
script headers: buglist.cgi, referer:
http://bugzilla.redhat.com/mozilla-tip/buglist.cgi?query_format=specific&order=relevance+desc&bug_status=__open__&product=Fedora+Extras+Package+Request&content=

Comment 1

[Max Kanat-Alexander]

*** This bug has been marked as a duplicate of 293015 ***