archive.ar_user_text isn't updated after user rename while revision.rev_user_text is.
Version: unspecified
Severity: normal
Description
Description
Details
Details
- Reference
- bz21881
| Status | Subtype | Assigned | Task | ||
|---|---|---|---|---|---|
| Open | None | T31757 Incomplete user renames (and other username discrepancies) (tracking) | |||
| Open | Feature | None | T18660 Database table cleanup (tracking) | ||
| Resolved | Reedy | T23881 Update archive table for old user renames |
Event Timeline
Comment Actions
ar_user and ar_user_text are updated. It's been that way for a long time (though not always).
Comment Actions
Ah, then there should be some update ran to synchronize those names which hasn't been changed before the software allowed it, since currently there are still old names kept.
Perhaps change the summary then?
Comment Actions
Changed summary. Maybe a script can be made for people with edits left to be renamed.
Comment Actions
There seems to be literally tonnes of these:
SELECT ar_rev_id, ar_namespace, ar_title, ar_timestamp, ar_user_text, user_name FROM archive, user WHERE ar_user_text <> user_name AND ar_user = user_id AND user_id > 0 LIMIT 50;