Data dumps & renaming
Open, Needs TriagePublic
Actions

Assigned To

None

Authored By

	• BenoitPrieur
	Jun 16 2016, 9:44 AM

Description

Hi,

I renamed my Username few months ago without getting specific troubles. My username was User:Agamitsudo and became User:Benoît Prieur (my real name).

But I got a related bad consequence at the Data dump level. Dump are exploited to generate this list for example https://fr.wikipedia.org/wiki/Wikip%C3%A9dia:Liste_de_Wikip%C3%A9diens_par_nombre_d%27%C3%A9ditions

In that dump you can see appearing my two usernames ("agamitsudo" and "Benoît Prieur") while only the new/last one should be visible (there is a balance of something like 20.000 edits still affected to agamitsudo. It should not).

Do you think that bug is easily fixable?

Thank you :)

Event Timeline

• BenoitPrieur created this task.Jun 16 2016, 9:44 AM

Restricted Application added a subscriber: Zppix. · View Herald TranscriptJun 16 2016, 9:44 AM

The problem is not directly related to dump but come from the revision table :

select rev_user, rev_user_text, count(*) from revision, user where user_name='Benoît Prieur' and rev_user=user_id group by rev_user, rev_user_text;

rev_user rev_user_text	count(*)
277571	Agamitsudo	20930
277571	Benoît Prieur	99175

Same problem on logging table :

log_user log_user_text	count(*)
277571		1
277571	Agamitsudo	2000
277571	Benoît Prieur	126002

• BenoitPrieur updated the task description. (Show Details)Jun 16 2016, 10:13 AM

• BenoitPrieur updated the task description. (Show Details)

Ltrlg subscribed.Jun 17 2016, 3:32 PM

Data dumps & renamingOpen, Needs TriagePublicActions

Description

Event Timeline

Data dumps & renaming
Open, Needs TriagePublic
Actions