[RTEMS Project] #2932: Account manager plugin sends email to all.

[RTEMS trac]

#2932: Account manager plugin sends email to all.
-------------------------+--------------------------
 Reporter:  Amar Takhar  |       Owner:  Amar Takhar
     Type:  infra        |      Status:  assigned
 Priority:  high         |   Milestone:
Component:  unspecified  |     Version:
 Severity:  normal       |  Resolution:
 Keywords:  trac         |  Blocked By:
 Blocking:               |
-------------------------+--------------------------

Comment (by Amar Takhar):

 The solution to this is to create a new TicketPreviousUpdatersSubscriber
 Component that will restrict the list of contacts to only those who have
 registered an account on Trac.

 I'll change the SQL from:

 {{{#!sql
 SELECT DISTINCT author FROM ticket_change WHERE ticket=%s
 }}}

   To:

 {{{#!sql
 SELECT DISTINCT author FROM ticket_change WHERE author IN (SELECT DISTINCT
 sid from session) and ticket=%s
 }}}

 The reason this is happening in the first place is due to the ticket
 updater plugin which unilaterally inserts logs from the Git commit.  This
 is fine and what we'd normally want but we don't want to be sending emails
 to anyone who hasn't updated a ticket directly via an account.

--
Ticket URL: <http://devel.rtems.org/ticket/2932#comment:2>
RTEMS Project <http://www.rtems.org/>
RTEMS Project