275422 - search problem when using flag and flag requestee

Status: RESOLVED DUPLICATE of bug 275408

(Bugzilla :: Query/Bug List, defect)

Description

[agrieco]

I get the following error when using a 'flag requestee" "contains" "<something>"
AND "flag" "contains" "<something>"

I have tried this on the production, bugzilla 2.19 release for bugzilla bugs
(this system), but I dont get the same error.  This error is seen using 2.18rc3.
and is reproducable.  If I only use one of the conditions, the query returns
normally, and when I make both conditions the same, the query also returns normally.


DBD::mysql::st execute failed: Not unique table/alias: 'flags_0' [for Statement
"SELECT bugs.bug_id, bugs.bug_severity, bugs.priority, bugs.bug_status,
bugs.resolution, 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, flags flags_0, profiles requestees_0
LEFT JOIN flags flags_0 ON bugs.bug_id = flags_0.bug_id AND flags_0.is_active =
1 LEFT JOIN flagtypes flagtypes_0 ON flags_0.type_id = flagtypes_0.id LEFT JOIN
bug_group_map  ON bug_group_map.bug_id = bugs.bug_id  AND bug_group_map.group_id
NOT IN (7,12,8)  LEFT JOIN cc ON cc.bug_id = bugs.bug_id AND cc.who = 4 WHERE
bugs.assigned_to = map_assigned_to.userid AND bugs.bug_id = flags_0.bug_id AND
flags_0.requestee_id = requestees_0.userid AND (bugs.bug_status IN
('NEW','ASSIGNED','REOPENED')) AND (INSTR(LOWER(requestees_0.login_name),
'agrieco')) AND (INSTR(LOWER(CONCAT(flagtypes_0.name, flags_0.status)), 'info'))
AND ((bug_group_map.group_id IS NULL)    OR (bugs.reporter_accessible = 1 AND
bugs.reporter = 4)     OR (bugs.cclist_accessible = 1 AND cc.who IS NOT NULL)  
  OR (bugs.assigned_to = 4) OR (bugs.qa_contact = 4) ) GROUP BY bugs.bug_id
ORDER BY bugs.bug_status,bugs.priority,map_assigned_to.login_name,bugs.bug_id "]
at Bugzilla/DB.pm line 62
	Bugzilla::DB::SendSQL('SELECT bugs.bug_id, bugs.bug_severity, bugs.priority,
bugs.bu...') called at <dirname> buglist.cgi line 770

Comment 1

[Shane H. W. Travis]

The bug so nice, he entered it twice. :)

Leaving the original untouched, resolving this one as a dupe.

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