Red Hat Bugzilla – Bug 76054
Couldn't query for 'bash' bugs
Last modified: 2007-04-18 12:47:37 EDT
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.
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.
http://bugzilla.redhat.com/rh-bugzilla-beta1/buglist.cgi?query_format=&short_desc_type=allwordssubstr&short_desc=&component=bash&component_text=&bug_status=NEW&bug_status=ASSIGNED&bug_status=REOPENED&long_desc_type=allwordssubstr&long_desc=&bug_file_loc_type=allwordssubstr&bug_file_loc=&status_whiteboard_type=allwordssubstr&status_whiteboard=&emailassigned_to1=1&emailtype1=substring&email1=&emailassigned_to2=1&emailreporter2=1&emailqa_contact2=1&emailcc2=1&emailtype2=substring&email2=&bugidtype=include&bug_id=&votes=&changedin=&chfieldfrom=&chfieldto=Now&chfieldvalue=&cmdtype=doit&order=Reuse+same+sort+as+last+time&field0-0-0=noop&type0-0-0=noop&value0-0-0=
I cannot seem to get this to fail for me. I have attached a screenshot showing the resultant bug set.
Created attachment 80744 [details] Screenshot showing working query
Try it in galeon. It works for me in mozilla and konqueror, now that I try them.
Should be fixed now. http://bugzilla.redhat.com/rh-bugzilla-beta3 Thanks