https://bugzilla.wikimedia.org/show_bug.cgi?id=26316
Ashar Voultoiz <has...@free.fr> changed:
What |Removed |Added
----------------------------------------------------------------------------
Status|NEW |RESOLVED
Resolution| |FIXED
--- Comment #2 from Ashar Voultoiz <has...@free.fr> 2011-01-17 20:40:03 UTC ---
Rows:
[enwiki]> select rev_id,rev_user,rev_user_text from revision where
rev_user_text='Llama man';
+-----------+----------+---------------+
| rev_id | rev_user | rev_user_text |
+-----------+----------+---------------+
| 78389563 | 1661697 | Llama man |
| 84249212 | 1661697 | Llama man |
| 84516223 | 1661697 | Llama man |
| 84516296 | 1661697 | Llama man |
| 84522073 | 1661697 | Llama man |
| 84701538 | 1661697 | Llama man |
| 85351963 | 1661697 | Llama man |
| 85376173 | 1661697 | Llama man |
| 85376332 | 1661697 | Llama man |
| 85376424 | 1661697 | Llama man |
| 85491623 | 1661697 | Llama man |
| 86811665 | 1661697 | Llama man |
| 86821394 | 1661697 | Llama man |
| 86856767 | 1661697 | Llama man |
| 86856892 | 1661697 | Llama man |
| 87250572 | 1661697 | Llama man |
| 87657503 | 1661697 | Llama man |
| 87659254 | 1661697 | Llama man |
| 87831643 | 1661697 | Llama man |
| 87846046 | 1661697 | Llama man |
| 88328657 | 1661697 | Llama man |
| 88485090 | 1661697 | Llama man |
| 88485222 | 1661697 | Llama man |
| 92305529 | 1661697 | Llama man |
| 99016388 | 1661697 | Llama man |
| 100096806 | 1661697 | Llama man |
| 109999894 | 1661697 | Llama man |
+-----------+----------+---------------+
27 rows in set (0.00 sec)
Renamed on db36 using:
UPDATE revision SET rev_user_text='Malcom', rev_user=56586 WHERE
rev_user_text='Llama man' AND rev_user=1661697 LIMIT 1;
Which created a false name 'Malcom' (my bad):
[enwiki]> select rev_id,rev_user,rev_user_text from revision where
rev_user_text='Malcom' and rev_user=56586;
+-----------+----------+---------------+
| rev_id | rev_user | rev_user_text |
+-----------+----------+---------------+
| 78389563 | 56586 | Malcom |
| 80354456 | 56586 | Malcom |
| 80551625 | 56586 | Malcom |
| 84249212 | 56586 | Malcom |
| 84516223 | 56586 | Malcom |
| 84516296 | 56586 | Malcom |
| 84522073 | 56586 | Malcom |
| 84701538 | 56586 | Malcom |
| 85351963 | 56586 | Malcom |
| 85376173 | 56586 | Malcom |
| 85376332 | 56586 | Malcom |
| 85376424 | 56586 | Malcom |
| 85491623 | 56586 | Malcom |
| 86811665 | 56586 | Malcom |
| 86821394 | 56586 | Malcom |
| 86856767 | 56586 | Malcom |
| 86856892 | 56586 | Malcom |
| 87250572 | 56586 | Malcom |
| 87657503 | 56586 | Malcom |
| 87659254 | 56586 | Malcom |
| 87831643 | 56586 | Malcom |
| 87846046 | 56586 | Malcom |
| 88328657 | 56586 | Malcom |
| 88485090 | 56586 | Malcom |
| 88485222 | 56586 | Malcom |
| 92305529 | 56586 | Malcom |
| 99016388 | 56586 | Malcom |
| 100096806 | 56586 | Malcom |
| 109999894 | 56586 | Malcom |
+-----------+----------+---------------+
29 rows in set (0.00 sec)
Fixed the username with :
UPDATE revision SET rev_user_text='Malcolm' WHERE rev_user_text='Malcom' AND
rev_user=56586 LIMIT 1;
--
Configure bugmail: https://bugzilla.wikimedia.org/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are the assignee for the bug.
You are on the CC list for the bug.
_______________________________________________
Wikibugs-l mailing list
Wikibugs-l@lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/wikibugs-l
