Page MenuHomePhabricator

Mis-attributed edits after move into and out of SUL'ed account
Closed, ResolvedPublic

Description

Author: kaare

Description:
(Don't know if this bug should be reported against Wikimedia or Mediawiki; please re-assign as you see fit.)

Mid-December 2010 the dawiki user "Pusleogpixi" requested renaming to "Pixi" in order to get a shorter name. On 29 December 2010 the process was set in motion by first moving an existing (unused) account out of the way, renaming it to "Pixi1" as per our procedure.

For some reason I didn't do my usual sanity checks before renaming "Pusleogpixi" to the new free "Pixi" account, too late realising that the "Pixi" account had already been SUL'ed from another wiki and not by the user requesting the renaming.

Upon noticing my mistake, I immediately moved the account back to "Pusleogpixi", however the edits stayed behind in the "Pixi" account, which now no longer exists, and they are still there at this time.

I asked the user to come up with another name, not already taken on any Wikimedia wiki, and then on 30 December 2010 renamed the "Pusleogpixi" account to its final name, "Pixi Uno".

Strangely, the edit counters on the Toolserver correctly attributes previous edits to "Pixi Uno", while they on dawiki's history pages incorrectly are attributed to "Pixi" and hence are missing from "Pixi Uno"'s user contributions.

The user is accumulating new edits in the renamed account, but would like the old edits back.

How do we resolve this problem?

Renaming log on dawiki:
http://da.wikipedia.org/w/index.php?title=Speciel%3ALoglister&type=renameuser&month=-1

Mis-attributed edits to the non-existant "Pixi" user:
http://da.wikipedia.org/wiki/Speciel:Bidrag/Pixi

Mediawiki says that the "Pixi" account doesn't exist:
http://da.wikipedia.org/wiki/Bruger:Pixi

The "Pixi Uno" account is accumulating new edits:
http://da.wikipedia.org/wiki/Speciel:Bidrag/Pixi_Uno

"Pixi Uno"'s edit counter on the Toolserver:
http://toolserver.org/~vvv/sulutil.php?user=Pixi+Uno

"Pixi"'s edit counter on the Toolserver:
http://toolserver.org/~vvv/sulutil.php?user=Pixi


Version: unspecified
Severity: normal

Details

Reference
bz26793

Event Timeline

bzimport raised the priority of this task from to Normal.Nov 21 2014, 11:14 PM
bzimport set Reference to bz26793.
bzimport created this task.Jan 18 2011, 5:33 PM

It needs someone to run
UPDATE revision SET rev_user_text='Pixi Uno' WHERE rev_user_text='Pixi' AND rev_user = 64247;
(10054 affected edits, none of them from the real Pixi so far)

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

reedy@fenari:/home/wikipedia/common$ mwscript runBatchedQuery.php --wiki=dawiki "UPDATE revision SET rev_user_text='Pixi Uno' WHERE rev_user_text='Pixi' AND rev_user = 64247 LIMIT 50;"
Batch 1: 50 rows
Batch 2: 50 rows
Batch 3: 50 rows
Batch 4: 50 rows
Batch 5: 50 rows
Batch 6: 50 rows
Batch 7: 50 rows
Batch 8: 50 rows
Batch 9: 50 rows
Batch 10: 50 rows
Batch 11: 50 rows
Batch 12: 50 rows
Batch 13: 50 rows
Batch 14: 50 rows
Batch 15: 50 rows
Batch 16: 50 rows
Batch 17: 50 rows
Batch 18: 50 rows
Batch 19: 50 rows
Batch 20: 50 rows
Batch 21: 50 rows
Batch 22: 50 rows
Batch 23: 50 rows
Batch 24: 50 rows
Batch 25: 50 rows
Batch 26: 50 rows
Batch 27: 50 rows
Batch 28: 50 rows
Batch 29: 50 rows
Batch 30: 50 rows
Batch 31: 50 rows
Batch 32: 50 rows
Batch 33: 50 rows
Batch 34: 50 rows
Batch 35: 50 rows
Batch 36: 50 rows
Batch 37: 50 rows
Batch 38: 50 rows
Batch 39: 50 rows
Batch 40: 50 rows
Batch 41: 50 rows
Batch 42: 50 rows
Batch 43: 50 rows
Batch 44: 50 rows
Batch 45: 50 rows
Batch 46: 50 rows
Batch 47: 50 rows
Batch 48: 50 rows
Batch 49: 50 rows
Batch 50: 50 rows
Batch 51: 50 rows
Batch 52: 50 rows
Batch 53: 50 rows
Batch 54: 50 rows
Batch 55: 50 rows
Batch 56: 50 rows
Batch 57: 50 rows
Batch 58: 50 rows
Batch 59: 50 rows
Batch 60: 50 rows
Batch 61: 50 rows
Batch 62: 50 rows
Batch 63: 50 rows
Batch 64: 50 rows
Batch 65: 50 rows
Batch 66: 50 rows
Batch 67: 50 rows
Batch 68: 50 rows
Batch 69: 50 rows
Batch 70: 50 rows
Batch 71: 50 rows
Batch 72: 50 rows
Batch 73: 50 rows
Batch 74: 50 rows
Batch 75: 50 rows
Batch 76: 50 rows
Batch 77: 50 rows
Batch 78: 50 rows
Batch 79: 50 rows
Batch 80: 50 rows
Batch 81: 50 rows
Batch 82: 50 rows
Batch 83: 50 rows
Batch 84: 50 rows
Batch 85: 50 rows
Batch 86: 50 rows
Batch 87: 50 rows
Batch 88: 50 rows
Batch 89: 50 rows
Batch 90: 50 rows
Batch 91: 50 rows
Batch 92: 50 rows
Batch 93: 50 rows
Batch 94: 50 rows
Batch 95: 50 rows
Batch 96: 50 rows
Batch 97: 50 rows
Batch 98: 50 rows
Batch 99: 50 rows
Batch 100: 50 rows
Batch 101: 50 rows
Batch 102: 50 rows
Batch 103: 50 rows
Batch 104: 50 rows
Batch 105: 50 rows
Batch 106: 50 rows
Batch 107: 50 rows
Batch 108: 50 rows
Batch 109: 50 rows
Batch 110: 50 rows
Batch 111: 50 rows
Batch 112: 50 rows
Batch 113: 50 rows
Batch 114: 50 rows
Batch 115: 50 rows
Batch 116: 50 rows
Batch 117: 50 rows
Batch 118: 50 rows
Batch 119: 50 rows
Batch 120: 50 rows
Batch 121: 50 rows
Batch 122: 50 rows
Batch 123: 50 rows
Batch 124: 50 rows
Batch 125: 50 rows
Batch 126: 50 rows
Batch 127: 50 rows
Batch 128: 50 rows
Batch 129: 50 rows
Batch 130: 50 rows
Batch 131: 50 rows
Batch 132: 50 rows
Batch 133: 50 rows
Batch 134: 50 rows
Batch 135: 50 rows
Batch 136: 50 rows
Batch 137: 50 rows
Batch 138: 50 rows
Batch 139: 50 rows
Batch 140: 50 rows
Batch 141: 50 rows
Batch 142: 50 rows
Batch 143: 50 rows
Batch 144: 50 rows
Batch 145: 50 rows
Batch 146: 50 rows
Batch 147: 50 rows
Batch 148: 50 rows
Batch 149: 50 rows
Batch 150: 50 rows
Batch 151: 50 rows
Batch 152: 50 rows
Batch 153: 50 rows
Batch 154: 50 rows
Batch 155: 50 rows
Batch 156: 50 rows
Batch 157: 50 rows
Batch 158: 50 rows
Batch 159: 50 rows
Batch 160: 50 rows
Batch 161: 50 rows
Batch 162: 50 rows
Batch 163: 50 rows
Batch 164: 50 rows
Batch 165: 50 rows
Batch 166: 50 rows
Batch 167: 50 rows
Batch 168: 50 rows
Batch 169: 50 rows
Batch 170: 50 rows
Batch 171: 50 rows
Batch 172: 50 rows
Batch 173: 50 rows
Batch 174: 50 rows
Batch 175: 50 rows
Batch 176: 50 rows
Batch 177: 50 rows
Batch 178: 50 rows
Batch 179: 50 rows
Batch 180: 50 rows
Batch 181: 50 rows
Batch 182: 50 rows
Batch 183: 50 rows
Batch 184: 50 rows
Batch 185: 50 rows
Batch 186: 50 rows
Batch 187: 50 rows
Batch 188: 50 rows
Batch 189: 50 rows
Batch 190: 50 rows
Batch 191: 50 rows
Batch 192: 50 rows
Batch 193: 50 rows
Batch 194: 50 rows
Batch 195: 50 rows
Batch 196: 50 rows
Batch 197: 50 rows
Batch 198: 50 rows
Batch 199: 50 rows
Batch 200: 50 rows
Batch 201: 41 rows
Batch 202: 0 rows