Hi,
For the article recommendation test, we queried user table to get editors' email addresses. We then excluded the emails that were not verified. We've received a comment here https://meta.wikimedia.org/wiki/Research_talk:Increasing_article_coverage#Usage_of_user_database that suggests the user has changed his/her email addresse and we have somehow retained the old email address. I'd like to get to the bottom of this problem. Can someone help with this, in the Talk page or here? Are we looking at the wrong table? And in general, how can old information be in the user table?
Sorry for sending an email over the weekend. A response on Monday would be great. :-)
Thank you!
Leila
Hmn. The user table should be updated; I can only think of two situations here:
1. There was a lag between collecting the information and the information being used, and the change happened then; 2. There was a lag in the databases, and the change happened then; 3. The user didn't change their email address on whatever project we queried (is it a global change? Can any developers chip in here?)
I've left some thoughts on that page regarding the privacy policy - I understand the users' concerns but I don't think they're founded on a valid interpretation. Hopefully it helps. Thank you, Leila, for your ongoing work here :)
On 27 June 2015 at 17:30, Leila Zia leila@wikimedia.org wrote:
Hi,
For the article recommendation test, we queried user table to get editors' email addresses. We then excluded the emails that were not verified. We've received a comment here that suggests the user has changed his/her email addresse and we have somehow retained the old email address. I'd like to get to the bottom of this problem. Can someone help with this, in the Talk page or here? Are we looking at the wrong table? And in general, how can old information be in the user table?
Sorry for sending an email over the weekend. A response on Monday would be great. :-)
Thank you!
Leila
Analytics mailing list Analytics@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/analytics
I suspect that the answer is #3. Maybe you could look for differences in registered email addresses for that user in different DBs.
On Mon, Jun 29, 2015 at 9:16 AM, Oliver Keyes okeyes@wikimedia.org wrote:
Hmn. The user table should be updated; I can only think of two situations here:
- There was a lag between collecting the information and the
information being used, and the change happened then; 2. There was a lag in the databases, and the change happened then; 3. The user didn't change their email address on whatever project we queried (is it a global change? Can any developers chip in here?)
I've left some thoughts on that page regarding the privacy policy - I understand the users' concerns but I don't think they're founded on a valid interpretation. Hopefully it helps. Thank you, Leila, for your ongoing work here :)
On 27 June 2015 at 17:30, Leila Zia leila@wikimedia.org wrote:
Hi,
For the article recommendation test, we queried user table to get
editors'
email addresses. We then excluded the emails that were not verified.
We've
received a comment here that suggests the user has changed his/her email addresse and we have somehow retained the old email address. I'd like to
get
to the bottom of this problem. Can someone help with this, in the Talk
page
or here? Are we looking at the wrong table? And in general, how can old information be in the user table?
Sorry for sending an email over the weekend. A response on Monday would
be
great. :-)
Thank you!
Leila
Analytics mailing list Analytics@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/analytics
-- Oliver Keyes Research Analyst Wikimedia Foundation
Analytics mailing list Analytics@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/analytics
On Sat, Jun 27, 2015 at 2:30 PM, Leila Zia leila@wikimedia.org wrote:
For the article recommendation test, we queried user table to get editors' email addresses. We then excluded the emails that were not verified. We've received a comment here https://meta.wikimedia.org/wiki/Research_talk:Increasing_article_coverage#Usage_of_user_database that suggests the user has changed his/her email addresse and we have somehow retained the old email address. I'd like to get to the bottom of this problem. Can someone help with this, in the Talk page or here? Are we looking at the wrong table? And in general, how can old information be in the user table?
Now that SUL finalization https://www.mediawiki.org/wiki/SUL_finalisation has completed, you should use the global user table for email addresses (centralauth.globaluser.gu_email). When the user changes their email, it is not updated on all 800-something projects where they might have an account, only locally and centrally. User data on other wikis will be updated whenever the user next visits them.
Thanks a lot everyone. :-)
On Mon, Jun 29, 2015 at 6:21 PM, Gergo Tisza gtisza@wikimedia.org wrote:
On Sat, Jun 27, 2015 at 2:30 PM, Leila Zia leila@wikimedia.org wrote:
For the article recommendation test, we queried user table to get editors' email addresses. We then excluded the emails that were not verified. We've received a comment here https://meta.wikimedia.org/wiki/Research_talk:Increasing_article_coverage#Usage_of_user_database that suggests the user has changed his/her email addresse and we have somehow retained the old email address. I'd like to get to the bottom of this problem. Can someone help with this, in the Talk page or here? Are we looking at the wrong table? And in general, how can old information be in the user table?
Now that SUL finalization https://www.mediawiki.org/wiki/SUL_finalisation has completed, you should use the global user table for email addresses (centralauth.globaluser.gu_email). When the user changes their email, it is not updated on all 800-something projects where they might have an account, only locally and centrally. User data on other wikis will be updated whenever the user next visits them.
Analytics mailing list Analytics@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/analytics