Bug 76992 - ERROR: ORDER BY expressions must appear in target lis
Summary: ERROR: ORDER BY expressions must appear in target lis
Alias: None
Product: Bugzilla
Classification: Community
Component: Test (Show other bugs)
(Show other bugs)
Version: 2.17
Hardware: i386 Linux
medium vote
Target Milestone: ---
Assignee: David Lawrence
QA Contact: David Lawrence
Depends On:
TreeView+ depends on / blocked
Reported: 2002-10-30 19:04 UTC by giulioo
Modified: 2007-04-18 16:48 UTC (History)
0 users

Fixed In Version:
Doc Type: Bug Fix
Doc Text:
Story Points: ---
Clone Of:
Last Closed: 2002-10-30 19:04:35 UTC
Type: ---
Regression: ---
Mount Type: ---
Documentation: ---
Verified Versions:
Category: ---
oVirt Team: ---
RHEL 7.3 requirements from Atomic Host:
Cloudforms Team: ---

Attachments (Terms of Use)

Description giulioo 2002-10-30 19:04:29 UTC

Please stand by ...
Content-type: text/html
Software error:

SELECT DISTINCT bugs.bug_id, bugs.bug_severity, bugs.priority,
bugs.rep_platform, map_assigned_to.login_name, bugs.bug_status, bugs.resolution,
bugs.short_desc FROM bugs LEFT JOIN bug_group_map  ON bug_group_map.bug_id =
bugs.bug_id  LEFT JOIN cc ON cc.bug_id = bugs.bug_id  , profiles AS
map_assigned_to, components components_  WHERE bugs.assigned_to =
map_assigned_to.userid AND components_.id = bugs.component_id AND
bugs.component_id = components_.id AND (components_.name = 'Kernel' OR
components_.name = 'kernel' OR components_.name = 'kernel-pcmcia-cs' OR
components_.name = 'kernel-utils') AND (bugs.bug_status = 'NEW' OR
bugs.bug_status = 'ASSIGNED' OR bugs.bug_status = 'REOPENED') AND
(components_.name = 'Kernel' OR components_.name = 'kernel' OR components_.name
= 'kernel-pcmcia-cs' OR components_.name = 'kernel-utils') AND
((bug_group_map.group_id IS NULL) ) GROUP BY
ORDER BY bugs.delta_ts, bugs.bug_status, bugs.priority,
map_assigned_to.login_name, bugs.bug_id : ERROR:  For SELECT DISTINCT, ORDER BY
expressions must appear in target list at globals.pl line 288.

For help, please send mail to the webmaster (bugzilla@redhat.com), giving this
error message and the time and date of the error.

Comment 1 David Lawrence 2002-12-02 05:58:35 UTC
Please reopen this if this problem still occurs in latest code.


Note You need to log in before you can comment on or make changes to this bug.