https://bugzilla.wikimedia.org/show_bug.cgi?id=30185
--- Comment #20 from Sam Reed (reedy) <[email protected]> --- (In reply to comment #19) > However, I still see 35 users with gu_hidden = '0'. You listed 75, I fixed 75.. mysql:wikiadmin@db1041 [centralauth]> select gu_id, gu_name from globaluser where gu_hidden='0'; +---------+------------------+ | gu_id | gu_name | +---------+------------------+ | 25721 | AnakngAraw | | 10258 | Annika64 | | 1383081 | ArikamaI | | 10847 | Arjuno3 | | 5015 | Ark | | 4073559 | Astynax | | 5165607 | B20180 | | 1815750 | Cekli829 | | 8513 | Chatter | | 1172575 | Chris G Bot 3 | | 2395484 | Cocu | | 47104 | Dangelin5 | | 2199873 | David J Wilson | | 15043 | Gerd W. Zinke | | 4726 | Gleiberg | | 2991818 | Groovenstein | | 3435552 | Henrig | | 3489690 | High Contrast | | 5191571 | KarlV | | 4320 | Kpisimon | | 773 | Law soma | | 2420698 | Lonelydarksky | | 1465 | MiPe | | 1275503 | Mild Bill Hiccup | | 3012014 | Newwhist | | 8893 | NordNordWest | | 31993 | Pittimann | | 2159609 | Richard Harvey | | 3992956 | Seb az86556 | | 4611435 | ThF | | 673221 | TomStar81 | | 127 | TwinsMetsFan | | 5318524 | WTM | | 3924 | Ykhwong | | 5444285 | Zollerriia | +---------+------------------+ 35 rows in set (1 min 35.67 sec) mysql:wikiadmin@db1041 [centralauth]> ^CCtrl-C -- exit! Aborted reedy@fenari:~$ mwscript runBatchedQuery.php --wiki=metawiki "UPDATE centralauth.globaluser SET gu_hidden='' WHERE gu_hidden = '0' LIMIT 50" Batch 1: 35 rows Batch 2: 0 rows reedy@fenari:~$ sql centralauth Reading table information for completion of table and column names You can turn off this feature to get a quicker startup with -A Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 63981963 Server version: 5.1.53-wm-log (mysql-at-facebook-r3753) Copyright (c) 2000, 2012, Oracle and/or its affiliates. All rights reserved. Oracle is a registered trademark of Oracle Corporation and/or its affiliates. Other names may be trademarks of their respective owners. Type 'help;' or '\h' for help. Type '\c' to clear the current input statement. mysql:wikiadmin@db1041 [centralauth]> select gu_id, gu_name from globaluser where gu_hidden='0'; Empty set (5.65 sec) mysql:wikiadmin@db1041 [centralauth]> ^CCtrl-C -- exit! Aborted reedy@fenari:~$ Not a lot more I can do than that... -- You are receiving this mail because: You are the assignee for the bug. You are watching all bug changes. _______________________________________________ Wikibugs-l mailing list [email protected] https://lists.wikimedia.org/mailman/listinfo/wikibugs-l
