Hey Dave,
Bugzilla errors out when I try to query for fedora-review flag BLANK.
Yesterday you suggested querying for a NOT of (fedora-review? AND
fedora-review- AND fedora-review+).
Any suggestion?
Warren Togami
wtogami@xxxxxxxxxx
Software error:
DBD::Pg::st execute failed: ERROR: table name "flags_0" specified more
than once
[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 FROM bugs LEFT JOIN
bug_group_map ON bug_group_map.bug_id = bugs.bug_id LEFT JOIN cc ON
cc.bug_id = bugs.bug_id AND cc.who = 40567 LEFT JOIN flags AS flags_0 ON
bugs.bug_id = flags_0.bug_id AND flags_0.is_active = 1 LEFT JOIN
flagtypes AS flagtypes_0 ON flags_0.type_id = flagtypes_0.id LEFT JOIN
flags AS flags_0 ON bugs.bug_id = flags_0.bug_id AND flags_0.is_active =
1 LEFT JOIN flagtypes AS flagtypes_0 ON flags_0.type_id = flagtypes_0.id
LEFT JOIN flags AS flags_0 ON bugs.bug_id = flags_0.bug_id AND
flags_0.is_active = 1 LEFT JOIN flagtypes AS flagtypes_0 ON
flags_0.type_id = flagtypes_0.id , profiles AS map_assigned_to WHERE
bugs.assigned_to = map_assigned_to.userid AND ((bugs.product_id IN (59))
AND (bugs.component_id IN (18187,18186,16465)) AND (bugs.bug_status IN
('NEW','ASSIGNED','REOPENED'))) AND NOT(((flagtypes_0.name ||
flags_0.status) = 'fedora-review?') AND ((flagtypes_0.name ||
flags_0.status) = 'fedora-review-') AND ((flagtypes_0.name ||
flags_0.status) = 'fedora-review+')) AND ((bug_group_map.group_id IS
NULL) OR bug_group_map.group_id IN
(81,134,106,149,75,68,138,148,140,12,144,79,67,76,41,127,58,122,35,133,7,62,93,126,17,11,50,72,146,71,84,39,10,33,107,22,4,78,123,145,108,139,44,124,150,121,119,85,92,91,15,25,80,21,142,61,155,83,74,5,38,94,147)
OR (bugs.reporter_accessible = 1 AND bugs.reporter = 40567) OR
(bugs.cclist_accessible = 1 AND cc.who IS NOT NULL) OR
(bugs.assigned_to = 40567) OR (bugs.qa_contact = 40567) ) 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
ORDER BY bugs.bug_id"] at Bugzilla/DB.pm line 71
Bugzilla::DB::SendSQL('SELECT bugs.bug_id, bugs.bug_severity,
bugs.priority, bugs.bu...') called at /var/www/html/bugzilla/buglist.cgi
line 651
--
Fedora-maintainers mailing list
Fedora-maintainers@xxxxxxxxxx
https://www.redhat.com/mailman/listinfo/fedora-maintainers
--
Fedora-maintainers-readonly mailing list
Fedora-maintainers-readonly@xxxxxxxxxx
https://www.redhat.com/mailman/listinfo/fedora-maintainers-readonly
