Last modified: 2014-09-13 14:19:16 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 T24097, the corresponding Phabricator task for complete and up-to-date bug report information.
Bug 22097 - Populate user.user_registration DB field on every wiki
Populate user.user_registration DB field on every wiki
Status: REOPENED
Product: Wikimedia
Classification: Unclassified
Site requests (Other open bugs)
unspecified
All All
: Low enhancement (vote)
: ---
Assigned To: Nobody - You can work on this!
:
Depends on: 18638
Blocks: 16660
  Show dependency treegraph
 
Reported: 2010-01-14 08:36 UTC by Jesse (Pathoschild)
Modified: 2014-09-13 14:19 UTC (History)
9 users (show)

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


Attachments

Description Jesse (Pathoschild) 2010-01-14 08:36:36 UTC
The user.user_registration field is NULL for all users predating its addition circa 2005 (except on enwiki). This causes the API to return blank strings for user lookups[1], and causes all sorts of inconvenience for Toolserver scripts.

The field has been populated retroactively on enwiki, but not on other wikis. Presumably the script or query is still lying around somewhere; could this be done on all wikis?


[1] http://de.wikipedia.org/w/api.php?action=query&list=users&ususers=DerHexer|Pathoschild&usprop=registration
Comment 1 MZMcBride 2010-03-22 23:12:10 UTC
(In reply to comment #0)
> The field has been populated retroactively on enwiki, but not on other wikis.

No, I don't believe so. See, for example, http://en.wikipedia.org/w/api.php?action=query&list=users&ususers=Dobriain|Versageek&usprop=registration

This sounds like a direct duplicate of bug 18638.
Comment 2 Chad H. 2011-05-06 17:53:19 UTC

*** This bug has been marked as a duplicate of bug 18638 ***
Comment 3 Nemo 2014-02-13 14:21:05 UTC
(In reply to MZMcBride from comment #1)
> (In reply to comment #0)
> > The field has been populated retroactively on enwiki, but not on other wikis.
> 
> No, I don't believe so.

Probably only partially. Pathoschild's stalktoy very clearly displays that for some users there is precise registration date on en.wiki even before 2005, when there wasn't any. Should be trivial to verify.

Bug 18638 is not really a duplicate unless the script runs itself on its own, better separate the two issues even though this is blocked by that one (-shell because this is not actionable yet).
Comment 4 MZMcBride 2014-02-13 23:52:04 UTC
(In reply to Nemo from comment #3)
> Probably only partially. Pathoschild's stalktoy very clearly displays that
> for some users there is precise registration date on en.wiki even before
> 2005, when there wasn't any. Should be trivial to verify.

To clarify: when the fixUserRegistration.php maintenance script is run, it can only change NULL user.user_registration values to a non-NULL value if there is an existent edit for the associated account when the script is run. For many old users (user accounts created prior to 2005 especially), a NULL user.user_registration value or even an inaccurate value is somewhat expected.

While I thought that fixUserRegistration.php had been run on all Wikimedia wikis, [[wikitech:Server admin log/Archive 7#June 5]] indicates that it may have only been run on the English Wikipedia.

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


Navigation
Links