Last modified: 2010-05-15 15:38:07 UTC

Wikimedia Bugzilla is closed!

Wikimedia migrated from Bugzilla to Phabricator. Bug reports are handled in Wikimedia Phabricator.
This static website is read-only and for historical purposes. It is not possible to log in and except for displaying bug reports and their history, links might be broken. See T2952, the corresponding Phabricator task for complete and up-to-date bug report information.
Bug 952 - table user got new columns user_email_confirmed, user_email_token, user_email_token_expires
table user got new columns user_email_confirmed, user_email_token, user_email...
Product: MediaWiki
Classification: Unclassified
User login and signup (Other open bugs)
All All
: Normal enhancement (vote)
: ---
Assigned To: Nobody - You can work on this!
Depends on:
Blocks: 1932 866
  Show dependency treegraph
Reported: 2004-11-28 09:07 UTC by T. Gries
Modified: 2010-05-15 15:38 UTC (History)
0 users

See Also:
Web browser: ---
Mobile Platform: ---
Assignee Huggle Beta Tester: ---


Description T. Gries 2004-11-28 09:07:23 UTC
For implementing bugzilla 866, I propose to introduce a new column in the
database table user:


This is empty or zero in case of a "dirty", i.e. non-authenticated email
address, which is only be used for mailing a temporary password - in case a user
forgot the correct password.

The field gets the timestamp of the email authentication, when a user logs in
with the temporary password mailed to him/her from the wiki (through a dummy "I
forgot my password cycle" or a similar mechanism). It already works reasonable
and only a few code changes are needed.

The option (wiki requires authentication of email address) can be disabled by Sysop.

See bugzilla (Email
authentication by a dummy "forgot my password" cycle)

This enhancement is implemented in Enotif 2.00 for CVS (see )
Comment 1 T. Gries 2004-11-28 09:11:16 UTC
The introduction as a timestamp field allows later checking how long this has
been authenticated (and further uses).
Comment 2 T. Gries 2004-12-19 08:50:44 UTC
-- solved/implemented in CVS 1.5
Comment 3 T. Gries 2005-04-27 23:23:36 UTC
..and some more new columns. Needed for new method to confirm e-mail addresses
in the databases.

*implemented* in ENotif/EConfirm v3.16, see .

Note You need to log in before you can comment on or make changes to this bug.