Re: Gnus interface to Bugzilla?

[Lars Magne Ingebrigtsen <larsi@gnus.org>]

Lars Magne Ingebrigtsen <larsi@gnus.org> writes:

> All Gnus needs is the number of responses per bug report, and that can
> probably be put into buglist.cgi as it is...

I've looked at the code.

It basically creates a select from the BUGS table.  That table doesn't
have a count of the number of responses, so you'd need to select from
the longdescs table.

Uhm...  you wouldn't happen to be working on this at the moment,
Steve?

http://issues.sxemacs.org/buglist.cgi?query_format=specific&order=relevance+desc&bug_status=__open__&product=&content=gnus

=>

DBD::Pg::st execute failed: ERROR:  syntax error at or near "desc" at character 1146
 [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, (SUM(CASE WHEN (LOWER(longdescs_0.thetext) LIKE '%gnus%') THEN 1 ELSE 0 END)/COUNT(CASE WHEN (LOWER(longdescs_0.thetext) LIKE '%gnus%') THEN 1 ELSE 0 END) + CASE WHEN (LOWER(bugs.short_desc) LIKE '%gnus%') THEN 1 ELSE 0 END) AS relevance FROM bugs  INNER JOIN profiles AS map_assigned_to ON (bugs.assigned_to = map_assigned_to.userid) INNER JOIN longdescs AS longdescs_0 ON (bugs.bug_id = longdescs_0.bug_id ) LEFT JOIN bug_group_map  ON bug_group_map.bug_id = bugs.bug_id  WHERE ((bugs.bug_status IN ('UNCONFIRMED','NEW','ASSIGNED','REOPENED'))) AND (((CASE WHEN (LOWER(longdescs_0.thetext) LIKE '%gnus%') THEN 1 ELSE 0 END > 0) OR (bugs.short_desc ~* '(^|[^a-z0-9])gnus($|[^a-z0-9])'))) AND bugs.creation_ts IS NOT NULL AND ((bug_group_map.group_id IS NULL)) GROUP BY bugs.bug_id, bugs.short_desc, bugs.bug_severity, bugs.priority, bugs.bug_status, bugs.resolution, bugs.rep_platform, map_assigned_to.login_name, relevance desc ORDER BY relevance desc LIMIT 200"] at /var/www/htdocs/SXEmacs-issues/buglist.cgi line 820


-- 
(domestic pets only, the antidote for overdose, milk.)
  larsi@gnus.org * Lars Magne Ingebrigtsen