Page MenuHomePhabricator

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

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.

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

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

Krinkle changed the task status from Open to Stalled.Apr 30 2017, 3:33 AM
Krinkle subscribed.

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

Aklapper changed the subtype of this task from "Task" to "Feature Request".Feb 4 2022, 11:01 AM
Aklapper removed a subscriber: wikibugs-l-list.

@Bugreporter Is it really impossible to show the date of the first edit for a specific special-history-page, and not the date of registration? This is a simplification from T324166 , just so you avoid opening the oldest at the history. The registration date with 0 edits, for example, is not important there at all.