189631 - my search for myself as a requester errored about Unknown column 'flags_0.requester_id' in 'where clause'

Status: RESOLVED DUPLICATE of bug 215319

(Bugzilla :: Query/Bug List, defect)

Description

[timeless]

bug changed in 30 days
flag is equal to review+
flag is equal to superreview+
flag requester is equal to [e-mail]

Please stand by ...
Content-type: text/html
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 flags flags_0 ON bugs.bug_id =
flags_0.bug_id LEFT JOIN flagtypes flagtypes_0 ON flags_0.type_id =
flagtypes_0.id, profiles requesters_0 LEFT JOIN bug_group_map  ON
bug_group_map.bug_id = bugs.bug_id  AND bug_group_map.group_id NOT IN
(2,4,7,9,10,12)  LEFT JOIN cc ON cc.bug_id = bugs.bug_id AND cc.who = 15223 
WHERE bugs.assigned_to = map_assigned_to.userid AND bugs.bug_id = flags_0.bug_id
AND flags_0.requester_id = requesters_0.userid AND (bugs.resolution IN ('')) AND
((to_days(now()) - to_days(bugs.delta_ts)) < '31') AND (CONCAT(flagtypes_0.name,
flags_0.status) = 'review+') AND (CONCAT(flagtypes_0.name, flags_0.status) =
'superreview+') AND (requesters_0.login_name = '[e-mail]') AND
((bug_group_map.group_id IS NULL)    OR (bugs.reporter_accessible = 1 AND
bugs.reporter = 15223)     OR (bugs.cclist_accessible = 1 AND cc.who IS NOT
NULL)     OR (bugs.assigned_to = 15223) OR (bugs.qa_contact = 15223) ) GROUP BY
bugs.bug_id ORDER BY bugs.bug_id : Unknown column 'flags_0.requester_id' in
'where clause' at globals.pl line 283.

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

Comment 1

[Bradley Baetz (:bbaetz)]

This may be a dupe of bug 180684. If not, its probably fixed by the patch there.

Comment 2

[Dave Miller [:justdave]]

flags -> myk

Comment 3

[Vaclav Dvorak]

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