Last modified: 2013-09-04 05:18:00 UTC

Wikimedia Bugzilla is closed!

Wikimedia migrated from Bugzilla to Phabricator. Bug reports are handled in Wikimedia Phabricator.
This static website is read-only and for historical purposes. It is not possible to log in and except for displaying bug reports and their history, links might be broken. See T5507, the corresponding Phabricator task for complete and up-to-date bug report information.
Bug 3507 - Invalid usernames on Wikimedia web sites
Invalid usernames on Wikimedia web sites
Product: Wikimedia
Classification: Unclassified
General/Unknown (Other open bugs)
Other Linux
: Low normal with 3 votes (vote)
: ---
Assigned To: Nobody - You can work on this!
: shell
: 3501 5230 (view as bug list)
Depends on:
Blocks: 323 16660 29757
  Show dependency treegraph
Reported: 2005-09-19 13:43 UTC by Ævar Arnfjörð Bjarmason
Modified: 2013-09-04 05:18 UTC (History)
9 users (show)

See Also:
Web browser: ---
Mobile Platform: ---
Assignee Huggle Beta Tester: ---

Output of checkUsername (164.20 KB, application/octet-stream)
2013-05-17 18:37 UTC, Sam Reed (reedy)

Description Ævar Arnfjörð Bjarmason 2005-09-19 13:43:03 UTC
Some of the usernames that currently exist would not be accepted by the current
system if registed today, this includes:

* Usernames with the letter "/" in them
* Usernames that start with a lower case letter

I've made a list of these usernames using maintenance/checkUsernames.php and put
the log in /home/wikipedia/logs/checkUsernames.log (linked in the url to this bug)

These should Ideally be changed by local beaurocrats of these wikis using the
Special:Renameuser extension which as of 2005-09-19 needs to be modified to
accept invalid input to be useful for this.
Comment 1 Casey Brown 2007-09-18 01:59:45 UTC
Unless avar still has the listing, there's nothing further we can do about this bug (if it hasn't been done already in the last 2 years).
Comment 2 Rob Church 2007-09-18 10:37:39 UTC
Well, there is - we can generate another listing using his script, or another script, and advise those users of the need to rename their accounts.

(Special:Renameuser will now accept "invalid" username input for the original username, provided that the user row exists...)
Comment 3 Brion Vibber 2007-09-18 14:46:09 UTC
Please don't close bugs just because they're old.
Comment 4 Brion Vibber 2007-09-18 14:46:58 UTC
*** Bug 3501 has been marked as a duplicate of this bug. ***
Comment 5 Brion Vibber 2007-09-18 14:47:19 UTC
For another example, see the usernames with double spaces referred to in dupe bug 3501.
Comment 6 Mike.lifeguard 2009-06-27 22:33:23 UTC
*** Bug 5230 has been marked as a duplicate of this bug. ***
Comment 7 Phillip Patriakeas 2010-11-03 02:29:06 UTC
This is related to bug 323; assuming a properly-coded Special:Renameuser, renaming users with invalid names should cause all their edits to display in Special:Contributions.
Comment 8 Graham87 2010-11-03 03:29:14 UTC
AFAIK this would only work if the rev_user field in the revision table or the r_user field in the archive table is not 0. The above values are always 0 for edits from before the introduction of the Phase II software, as shown at:

It would also not work where duplicate usernames are involved such as "Larry_Sanger" and "Larry Sanger". In the latter case, those usernames should ideally be merged.
Comment 9 Krinkle 2011-01-17 11:31:48 UTC
* Rename users of which their edits have a _user higher than 0 in the other tables and do not conflict with an existing username
** If proof is found that they are the same, merge users
** If user is still active rename to something else with their permission
* Otherwise: Leave it be for now

That should clean up most cases, right ?
Comment 10 Gerrit Notification Bot 2013-05-17 00:32:45 UTC
Related URL: (Gerrit Change Idb4b84b853f4f86e90a470e937af9017cee15e44)
Comment 11 Gerrit Notification Bot 2013-05-17 00:46:44 UTC
Related URL: (Gerrit Change Idb4b84b853f4f86e90a470e937af9017cee15e44)
Comment 12 Gerrit Notification Bot 2013-05-17 00:47:36 UTC
Related URL: (Gerrit Change Idb4b84b853f4f86e90a470e937af9017cee15e44)
Comment 13 Sam Reed (reedy) 2013-05-17 18:37:29 UTC
Created attachment 12333 [details]
Output of checkUsername

reedy@terbium:~$ grep \: checkUsernames.log -c

1193 bad usernames on all WMF wikis

List grouped by dbname attached
Comment 14 MZMcBride 2013-09-04 04:20:56 UTC
MariaDB [enwiki_p]> select * from user where user_name = 'ɑʀʇʉʀɵ'\G
*************************** 1. row ***************************
                 user_id: 3103938
               user_name: ɑʀʇʉʀɵ
       user_registration: 20061226002342
          user_editcount: 39
1 row in set (0.03 sec)


"ɑʀʇʉʀɵ" gets transformed to "Ɑʀʇʉʀɵ".
Comment 15 Nemo 2013-09-04 05:18:00 UTC
(In reply to comment #14)
> "ɑʀʇʉʀɵ" gets transformed to "Ɑʀʇʉʀɵ".

A more recent example of that was [[user:ɱ]] (now Ɱ), with the lowercase "latin small letter m with hook / left-tail m" that didn't get consistently normalised to its capitalised/uppercase version. I can't find the bug for that, if any was filed, but it may require a core fix first hence a separate report.

Note You need to log in before you can comment on or make changes to this bug.