Bug #3354 email change is not considered in newsletter
Submitted: 31 Mar 2004 22:20 Modified: 1 Apr 2004 6:46
Reporter: Sergei Kulakov (Candidate Quality Contributor) Email Updates:
Status: Not a Bug Impact on me:
None 
Category:MySQL Websites Severity:S3 (Non-critical)
Version: OS:
Assigned to: Jim Winstead CPU Architecture:Any

[31 Mar 2004 22:20] Sergei Kulakov
Description:
I have an account at the MySQL site, initially I used my office email (kulakov@rlsnet.ru) for that but later I changed it for my public one (kulakov74@yandex.ru). I'm also subscribed for the MySQL Newsletter, and as long as my email was kulakov@rlsnet.ru I got newsletters at it, but after I changed it newsletters still come there. At the same time, when I report bugs answers come at the new email. In order to correct this I tried to unsubscribe and then resubscribe, but I think this should be handled automatically. 

How to repeat:
1. Get an account at the MySQL site at http://www.mysql.com/login.php
2. Subscribe for the MySQL newsletter at http://www.mysql.com/edit_user.php?login=1
3. Recieve a newsletter some day
4. Change your email at the Edit Profile page at Subscribe for the MySQL newsletter at http://www.mysql.com/edit_user.php?login=1
5. Recieve another newsletter some day at the email you used first

Suggested fix:
I suppose there is a separate database storing emails used for sending newsletters and that database is not updated when a user changes their account email.
[1 Apr 2004 6:46] Jim Winstead
This is handled automatically. There is only one database of user accounts used for the newsletter and 
bugs system.