Bug 117511

Summary: ERROR: Table name "map_qa_contact" specified more than once
Product: [Community] Bugzilla Reporter: Mike McLean <mikem>
Component: Bugzilla GeneralAssignee: David Lawrence <dkl>
Status: CLOSED CURRENTRELEASE QA Contact: David Lawrence <dkl>
Severity: medium Docs Contact:
Priority: medium    
Version: 2.17   
Target Milestone: ---   
Target Release: ---   
Hardware: All   
OS: Linux   
Whiteboard:
Fixed In Version: 2.17.1 Doc Type: Bug Fix
Doc Text:
Story Points: ---
Clone Of: Environment:
Last Closed: 2004-03-29 18:53:52 UTC Type: ---
Regression: --- Mount Type: ---
Documentation: --- CRM:
Verified Versions: Category: ---
oVirt Team: --- RHEL 7.3 requirements from Atomic Host:
Cloudforms Team: --- Target Upstream Version:
Embargoed:

Description Mike McLean 2004-03-04 21:02:30 UTC
http://bugzilla.redhat.com/bugzilla/buglist.cgi?query_format=&short_desc_type=allwordssubstr&short_desc=&component_text=&long_desc_type=allwordssubstr&long_desc=&bug_file_loc_type=allwordssubstr&bug_file_loc=&status_whiteboard_type=allwordssubstr&status_whiteboard=&fixed_in_type=allwordssubstr&fixed_in=&qa_whiteboard_type=allwordssubstr&qa_whiteboard=&devel_whiteboard_type=allwordssubstr&devel_whiteboard=&keywords_type=allwords&keywords=&cust_facing=&cust_facing_type=substring&emailassigned_to1=1&emailtype1=exact&email1=&emailreporter2=1&emailtype2=exact&email2=&bugidtype=include&bug_id=&changedin=20&chfieldfrom=&chfieldto=Now&chfieldvalue=&cmdtype=doit&remaction=run&namedcmd=anaconda+modified&order=Reuse+same+sort+as+last+time&field0-0-0=qa_contact&type0-0-0=changedfrom&value0-0-0=mikem%40redhat.com&field0-1-0=qa_contact&type0-1-0=isnull&value0-1-0=

Software error:

SELECT bugs.bug_id, bugs.alias, bugs.delta_ts,
map_reporter.login_name, bugs.bug_status, bugs.resolution,
bugs.short_desc, bugs.priority, map_assigned_to.login_name 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 AND cc.who = 84357   LEFT JOIN
profiles map_qa_contact ON bugs.qa_contact = map_qa_contact.userid 
LEFT JOIN profiles map_qa_contact ON bugs.qa_contact =
map_qa_contact.userid  , profiles AS map_assigned_to, profiles AS
map_reporter, bugs_activity act_0, fielddefs fielddefs_0 WHERE
bugs.assigned_to = map_assigned_to.userid AND bugs.reporter =
map_reporter.userid AND act_0.bug_id = bugs.bug_id AND act_0.fieldid =
fielddefs_0.fieldid AND ((now() - bugs.delta_ts) < interval '21 days')
AND ((fielddefs_0.name = 'map_qa_contact.login_name' AND act_0.removed
= 'mikem')) AND (map_qa_contact.login_name IS NULL) AND
((bug_group_map.group_id IS NULL  OR bug_group_map.group_id IN
(7,8,11,12,15,17,22,25,33,35,38,39,41,44,50,58,61,62))  OR
(bugs.reporter_accessible = 1 AND bugs.reporter = 84357)  OR
(bugs.cclist_accessible = 1 AND cc.who IS NOT NULL)  OR
(bugs.assigned_to = 84357)  OR (bugs.qa_contact = 84357) ) GROUP BY
bugs.bug_id,
bugs.bug_id,bugs.alias,bugs.delta_ts,map_reporter.login_name,bugs.bug_status,bugs.resolution,bugs.short_desc,bugs.priority,map_assigned_to.login_name
ORDER BY bugs.delta_ts, bugs.bug_status, bugs.priority,
map_assigned_to.login_name, bugs.bug_id : ERROR:  Table name
"map_qa_contact" specified more than once at globals.pl line 337.

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

Comment 1 David Lawrence 2004-03-29 18:53:52 UTC
Problem should be fixed now. Please reopen if this occurs again.