Bug 76054 - Couldn't query for 'bash' bugs
Summary: Couldn't query for 'bash' bugs
Keywords:
Status: CLOSED CURRENTRELEASE
Alias: None
Product: Bugzilla
Classification: Community
Component: Test
Version: 2.17
Hardware: i386
OS: Linux
medium
medium
Target Milestone: ---
Assignee: David Lawrence
QA Contact: David Lawrence
URL:
Whiteboard:
Depends On:
Blocks:
TreeView+ depends on / blocked
 
Reported: 2002-10-16 10:06 UTC by Tim Waugh
Modified: 2007-04-18 16:47 UTC (History)
0 users

Fixed In Version:
Clone Of:
Environment:
Last Closed: 2002-10-17 09:18:40 UTC
Embargoed:


Attachments (Terms of Use)
Screenshot showing working query (74.40 KB, image/png)
2002-10-16 23:22 UTC, David Lawrence
no flags Details

Description Tim Waugh 2002-10-16 10:06:37 UTC
Description of Problem:
Software error while querying for open bash bugs.  I'd performed a query with
'bash' selected.

SELECT DISTINCT bugs.bug_id, bugs.remaining_time,
(SUM(ldtime.work_time)*COUNT(DISTINCT ldtime.bug_when)/COUNT(bugs.bug_id)) AS
actual_time, bugs.bug_severity, bugs.priority, bugs.rep_platform,
map_assigned_to.login_name, bugs.bug_status, bugs.resolution, bugs.short_desc
FROM profiles AS map_assigned_to, components components_, longdescs AS
ldtime,bugs LEFT JOIN bug_group_map ON bug_group_map.bug_id = bugs.bug_id AND
bug_group_map.group_id IS NULL LEFT JOIN cc ON cc.bug_id = bugs.bug_id WHERE
bugs.assigned_to = map_assigned_to.userid AND components_.id = bugs.component_id
AND ldtime.bug_id = bugs.bug_id AND bugs.component_id = components_.id AND
(components_.name = 'bash') AND (bugs.bug_status = 'NEW' OR bugs.bug_status =
'ASSIGNED' OR bugs.bug_status = 'REOPENED') AND (components_.name = 'bash') AND
((bug_group_map.group_id IS NULL) OR (bugs.reporter_accessible = 1 AND
bugs.reporter = 0) OR (bugs.cclist_accessible = 1 AND cc.who = 0) OR
(bugs.assigned_to = 0)) GROUP BY
bugs.bug_id,bugs.remaining_time,bugs.bug_severity,bugs.priority,bugs.rep_platform,map_assigned_to.login_name,bugs.bug_status,bugs.resolution,bugs.short_desc
ORDER BY map_components.name,bugs.bug_id : ERROR: Relation "map_components" does
not exist at globals.pl line 280.

Comment 1 David Lawrence 2002-10-16 18:57:19 UTC
Can you post the resulting URL string that is in the address window after
hitting the Search button on the query page? Is this a stored query that you are
executing? I cannot get this to fail on stock query.

Comment 3 David Lawrence 2002-10-16 23:21:28 UTC
I cannot seem to get this to fail for me. I have attached a screenshot showing
the resultant bug set.

Comment 4 David Lawrence 2002-10-16 23:22:31 UTC
Created attachment 80744 [details]
Screenshot showing working query

Comment 5 Tim Waugh 2002-10-17 09:18:34 UTC
Try it in galeon.  It works for me in mozilla and konqueror, now that I try them.

Comment 6 David Lawrence 2002-10-23 21:40:21 UTC
Should be fixed now. 

http://bugzilla.redhat.com/rh-bugzilla-beta3

Thanks



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