Page MenuHomePhabricator

Populate user.user_registration DB field on every wiki
Open, Stalled, LowPublic

Description

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


Version: unspecified
Severity: enhancement
See Also:
https://bugzilla.wikimedia.org/show_bug.cgi?id=70759

Details

Reference
bz22097

Event Timeline

bzimport raised the priority of this task from to Low.Nov 21 2014, 10:57 PM
bzimport set Reference to bz22097.
bzimport added a subscriber: Unknown Object (MLST).

(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.

demon added a comment.May 6 2011, 5:53 PM
  • This bug has been marked as a duplicate of bug 18638 ***

(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).

(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.

demon removed a subscriber: demon.Dec 16 2014, 6:09 PM

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.

Surely not fixed for commons: https://commons.wikimedia.org/w/api.php?action=query&list=users&format=xml&usprop=registration&ususers=Planemad|McZusatz

If we must put some value in that field, can we at least do something better like choosing a timestamp between [date for previous user_id, date for next user_id] where those values can be existing values or values based on first edit, or values from the now deleted wikipages where these were logged in early MedaWiki.

If we must put some value in that field, can we at least do something better like choosing a timestamp between [date for previous user_id, date for next user_id] where those values can be existing values or values based on first edit, or values from the now deleted wikipages where these were logged in early MedaWiki.

+1. There are some more suggestions in T20638

-jem- added a subscriber: -jem-.Jul 31 2015, 11:49 AM
Restricted Application added subscribers: Matanya, Aklapper. · View Herald TranscriptJul 31 2015, 11:49 AM
Krinkle changed the task status from Open to Stalled.Apr 30 2017, 3:33 AM
Krinkle added a subscriber: Krinkle.

As described above, the script has been run on enwiki. Although there are still gaps for users that never made an edit. Fixing that is blocked on T20638.

Marking stalled until either T20638 is resolved, or there is agreement that we should run it as-is to fill at least some of the gaps on other wikis as well (as was done for enwiki).

Titore added a subscriber: Titore.Aug 7 2019, 7:47 PM