209994 - Deleted User Show Up on New Bugs

Status: RESOLVED INVALID

(Bugzilla :: User Accounts, defect)

Description

[Cindy Reese]

User-Agent:       Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.0)
Build Identifier: 2.16.1

I have deactivated users, ensure they are no listed on any components but yet 
even when creating a brand new bug they names get listed as being notified.

Reproducible: Always

Steps to Reproduce:
1.Create a new Bug
2.
3.

Actual Results:  
Deleted users names show up as being notified.

Comment 1

[Dave Miller [:justdave]]

That user is probably watching someone who is an owner or qa.  Check the
watchers table for their userid.

Comment 2

[Cindy Reese]

If you mean under Prefs, email, User to watch I did check and they have no
entries at all.  Is there some place else I can check?

Comment 3

[Cindy Reese]

I just updated a bug where [e-mail] was notified as you can 
see below but I have no watch on him, his account is deactivated, he is not 
cc'ed and he is not a component owner.

Email sent to: [e-mail], [e-mail], 
[e-mail], [e-mail], 
[e-mail]

Comment 4

[Dave Miller [:justdave]]

did he vote on that bug?

Comment 5

[Cindy Reese]

We do not use that functionality at all here.

Comment 6

[Dave Miller [:justdave]]

Edit the "newchangedmail" parameter in editparams.cgi to add a Bcc: line to the
header with your email address.

This will cause you to get a copy of every email that goes to every person.

Make a change to that same bug.  When you get the copy that has his email
address on the To: line, what's it say in the X-Bugzilla-Reason: header?  (once
you get that email, you can go back to editparams and take the Bcc line back out)

Comment 7

[Cindy Reese]

For the guy Joe who is no longer here and his ID is deactivated it shows:

-----Original Message-----
From: [e-mail]
[mailto:[e-mail]]
Sent: Thursday, June 19, 2003 3:35 PM
To: [e-mail]
Subject: [Bug 2607] servicesConfig.xml didn't get updated with the input
entered during installation

------- You are receiving this mail because: -------
You are the QA contact for the bug, or are watching the QA contact.

Do I have to sign on has the deactivated users and look at thier Prefs????

Comment 8

[Dave Miller [:justdave]]

if he's not the QA on that bug, then he's watching the QA.

Log into mysql...

SELECT userid FROM profiles WHERE login_name = "[e-mail]";

then take that userid and do

SELECT * FROM watch WHERE watcher = <userid>;

if you get hits for that, then that's what happened.  Easy fix is:

DELETE FROM watch WHERE watcher = <userid>;

Comment 9

[Dave Miller [:justdave]]

any luck with this?

Comment 10

[Dave Miller [:justdave]]

It's been almost two weeks and no response...  I'm going to assume you fixed it.
 Reopen if that's not the case.