There are a bunch of emails in the user table (user_email) that are totally invalid. For example, two users on aawiki have a user_email of "qwerty". These should just be deleted since they would never pass validation today.
Description
Description
Details
Details
| Status | Subtype | Assigned | Task | |
|---|---|---|---|---|
| · · · | ||||
| Open | Feature | None | T18660 Database table cleanup (tracking) | |
| Resolved | Legoktm | T73241 Run sendConfirmAndMigrateEmail.php for all unconfirmed emails on all wikis | ||
| Resolved | Legoktm | T76512 Remove invalid emails from the database | ||
| · · · |
Event Timeline
Comment Actions
Can this be done for all wikis (e.g. in update.php), or only on Wikimedia wikis? Are those users also marked emailconfirmed?
Comment Actions
Change 177021 had a related patch set uploaded (by Legoktm):
Add removeInvalidEmails.php maintenance script
Comment Actions
I've written the maint. script as a non-Wikimedia script, so any wiki should be able to run it. I don't think adding it to update.php is a good idea since it has to scan the entire user table, which can be slow.
The users were not confirmed, but my script that is getting the email addresses which I was watching is only looking at non-confirmed addresses.
Comment Actions
I also found valid-looking emails with leading whitespace. I'm not sure whether it's worth cleaning that up...
Comment Actions
Change 177386 had a related patch set uploaded (by Legoktm):
Add removeInvalidEmails.php maintenance script
Comment Actions
Change 177387 had a related patch set uploaded (by Legoktm):
Add removeInvalidEmails.php maintenance script