217426 - Not unique table/alias: 'cc_' at globals.pl line 284.

Status: VERIFIED DUPLICATE of bug 180980

(Bugzilla :: Query/Bug List, defect)

Description

[Adam Hauner]

User-Agent:       Mozilla/5.0 (Windows; U; Windows NT 5.0; en-US; rv:1.5b) Gecko/20030826
Build Identifier: Mozilla/5.0 (Windows; U; Windows NT 5.0; en-US; rv:1.5b) Gecko/20030826

Software error:

SELECT 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, profiles AS map_assigned_to LEFT JOIN cc cc_ ON bugs.bug_id =
cc_.bug_id AND cc_.who IN(15160) LEFT JOIN cc cc_ ON bugs.bug_id = cc_.bug_id
AND cc_.who IN(20048) LEFT JOIN bug_group_map  ON bug_group_map.bug_id =
bugs.bug_id  AND bug_group_map.group_id NOT IN (9,10)  LEFT JOIN cc ON cc.bug_id
= bugs.bug_id AND cc.who = 15160  WHERE bugs.assigned_to =
map_assigned_to.userid AND (bugs.product_id IN (1)) AND (bugs.bug_status IN
('UNCONFIRMED','NEW','ASSIGNED','REOPENED')) AND (cc_.who IS NOT NULL) AND
(cc_.who IS NOT NULL) AND (bugs.bug_id > '216000') AND ((bug_group_map.group_id
IS NULL)    OR (bugs.reporter_accessible = 1 AND bugs.reporter = 15160)     OR
(bugs.cclist_accessible = 1 AND cc.who IS NOT NULL)     OR (bugs.assigned_to =
15160) OR (bugs.qa_contact = 15160) ) GROUP BY bugs.bug_id ORDER BY bugs.bug_id
: Not unique table/alias: 'cc_' at globals.pl line 284.

Reproducible: Always

Steps to Reproduce:

Comment 1

[Dave Miller [:justdave]]

This is already fixed on the tip.  bugzilla.mozilla.org will pick it up next
time they upgrade.


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

Comment 2

[Adam Hauner]

v=aha