Page MenuHomePhabricator

Update archive table for old user renames
Closed, ResolvedPublic

Description

archive.ar_user_text isn't updated after user rename while revision.rev_user_text is.


Version: unspecified
Severity: normal

Details

Reference
bz21881

Event Timeline

bzimport raised the priority of this task from to Low.Nov 21 2014, 10:54 PM
bzimport set Reference to bz21881.
Danny_B created this task.Dec 17 2009, 12:32 PM
aaron added a comment.Dec 17 2009, 2:47 PM

ar_user and ar_user_text are updated. It's been that way for a long time (though not always).

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?

aaron added a comment.May 24 2010, 7:11 PM

Changed summary. Maybe a script can be made for people with edits left to be renamed.

Reedy added a comment.Jan 17 2013, 7:53 PM

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;

http://p.defau.lt/?5kEzIqwNXuKkuwDEy_Zd6A

Done on the site