Bug 137622
| Summary: | error page when running named query | ||
|---|---|---|---|
| Product: | [Community] Bugzilla | Reporter: | Roland McGrath <roland> |
| Component: | Bugzilla General | Assignee: | Mike MacKenzie <mmackenz> |
| Status: | CLOSED CURRENTRELEASE | QA Contact: | David Lawrence <dkl> |
| Severity: | medium | Docs Contact: | |
| Priority: | medium | ||
| Version: | 2.18 | ||
| Target Milestone: | --- | ||
| Target Release: | --- | ||
| Hardware: | All | ||
| OS: | Linux | ||
| URL: | https://bugzilla.redhat.com/beta2/buglist.cgi?cmdtype=runnamed&namedcmd=kernel%20bugs | ||
| Whiteboard: | |||
| Fixed In Version: | Doc Type: | Bug Fix | |
| Doc Text: | Story Points: | --- | |
| Clone Of: | Environment: | ||
| Last Closed: | 2004-11-11 17:37:18 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: | |||
| Bug Depends On: | |||
| Bug Blocks: | 138111 | ||
Fixed. This fix will show up in the next beta release. |
Description of problem: click my "kernel bugs" named query (see URL above) and get error page Version-Release number of selected component (if applicable): beta2 How reproducible: 100% DBD::Pg::st execute failed: ERROR: JOIN/ON clause refers to "bugs", which is not part of JOIN [for Statement "SELECT bugs.bug_id, bugs.bug_severity, bugs.priority, bugs.bug_status, bugs.resolution, bugs.alias, bugs.bug_severity, bugs.priority, bugs.rep_platform, map_assigned_to.login_name, bugs.bug_status, bugs.resolution, bugs.short_desc, bugs.delta_ts FROM bugs LEFT JOIN bug_group_map ON bug_group_map.bug_id = bugs.bug_id AND bug_group_map.group_id NOT IN (33,22,4,78,75,68,44,12,67,76,41,15,58,25,21,35,7,62,61,17,72,50,71,38,39) LEFT JOIN cc ON cc.bug_id = bugs.bug_id AND cc.who = 34397 LEFT JOIN cc cc_CC0 ON bugs.bug_id = cc_CC0.bug_id AND cc_CC0.who IN(34397) LEFT JOIN profiles map_qa_contact ON bugs.qa_contact = map_qa_contact.userid , profiles AS map_assigned_to, profiles AS map_reporter LEFT JOIN longdescs longdescs_LD1 ON longdescs_LD1.bug_id = bugs.bug_id AND longdescs_LD1.who IN (34397) WHERE bugs.assigned_to = map_assigned_to.userid AND bugs.assigned_to = map_assigned_to.userid AND bugs.reporter = map_reporter.userid AND (bugs.component_id IN (3379,3378,3375,3377,3374,3373,3380,3376,7817,8647,9734,10755,11769)) AND (bugs.bug_status IN ('NEW','ASSIGNED','REOPENED','NEEDINFO','MODIFIED','INVESTIGATE','ON_DEV','QA_READY','ON_QA')) AND ((map_assigned_to.login_name IN ('roland')) OR (map_reporter.login_name IN ('roland')) OR (cc_CC0.who IS NOT NULL) OR (map_qa_contact.login_name IN ('roland')) OR (longdescs_LD1.who IS NOT NULL)) AND ((bug_group_map.group_id IS NULL) OR (bugs.reporter_accessible = 1 AND bugs.reporter = 34397) OR (bugs.cclist_accessible = 1 AND cc.who IS NOT NULL) OR (bugs.assigned_to = 34397) OR (bugs.qa_contact = 34397) ) GROUP BY bugs.bug_id, bugs.bug_id,bugs.bug_severity,bugs.priority,bugs.bug_status,bugs.resolution,bugs.alias,bugs.bug_severity,bugs.priority,bugs.rep_platform,map_assigned_to.login_name,bugs.bug_status,bugs.resolution,bugs.short_desc,bugs.delta_ts ORDER BY bugs.delta_ts,bugs.bug_status,bugs.priority,map_assigned_to.login_name,bugs.bug_id "] at Bugzilla/DB.pm line 74 Bugzilla::DB::SendSQL('SELECT bugs.bug_id, bugs.bug_severity, bugs.priority, bugs.bu...') called at /var/www/bugzilla/beta2/buglist.cgi line 799