Closed
Bug 189631
Opened 22 years ago
Closed 21 years ago
my search for myself as a requester errored about Unknown column 'flags_0.requester_id' in 'where clause'
Categories
(Bugzilla :: Query/Bug List, defect)
Tracking
()
RESOLVED
DUPLICATE
of bug 215319
People
(Reporter: timeless, Assigned: myk)
References
()
Details
bug changed in 30 days
flag is equal to review+
flag is equal to superreview+
flag requester is equal to timeless@bemail.org
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 = 'timeless@bemail.org') 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 (webmaster@mozilla.org), giving this
error message and the time and date of the error.
Comment 1•22 years ago
|
||
This may be a dupe of bug 180684. If not, its probably fixed by the patch there.
Summary: my search for myself as a requester errored about Unknown column 'flags_0.requester_id' in 'where clause' → my search for myself as a requester errored about Unknown column 'flags_0.requester_id' in 'where clause'
Whiteboard: DUPME?
Comment 3•21 years ago
|
||
*** This bug has been marked as a duplicate of 215319 ***
Status: UNCONFIRMED → RESOLVED
Closed: 21 years ago
Resolution: --- → DUPLICATE
Updated•19 years ago
|
Whiteboard: DUPME?
Updated•12 years ago
|
QA Contact: matty_is_a_geek → default-qa
You need to log in
before you can comment on or make changes to this bug.
Description
•