Jeff,
given that 'BrownHairedGirl' was one of my 'spammers', you can do something
like this:
MariaDB [tta]> select rev_user, rev_user_text FROM revision WHERE
rev_user_text = 'BrownHairedGirl';
and you'll get something like this:
| rev_user | rev_user_text |
----------------------------------------------
| 0 | BrownHairedGirl |
| 0 | BrownHairedGirl |
| 0 | BrownHairedGirl |
| 0 | BrownHairedGirl |
| 0 | BrownHairedGirl |
| 0 | BrownHairedGirl |
----------------------------------------------
Hope this helps!
Valerio Pelliccioni
W: https://tunearch.org
On 19/12/2019, 23:52, "Jeffrey Walton" <noloa...@gmail.com> wrote:
On Thu, Dec 19, 2019 at 3:31 PM Valerio Pelliccioni <v...@silkwood.it>
wrote:
>
> Jeff,
> I've tried in the maintenance directory (a minute ago):
>
> vmp@tunearch:/var/www/w/maintenance# php cleanupUsersWithNoId.php
--dbuser=<user> --dbpass=<pass> --force --prefix=* --conf=../LocalSettings.php
> vmp@tunearch:/var/www/w/maintenance# php update.php
>
> ... and it works, at least for me with:
Thanks. Where are they coming from? maintenance/update.php is finding
them, but I can't.
Here is what I see when examining the MySQL tables.
MariaDB [my_wiki]> select count(*) from wikicryptopp_user;
+----------+
| count(*) |
+----------+
| 7 |
+----------+
1 row in set (0.00 sec)
MariaDB [my_wiki]> select count(*) from wikicryptopp_actor;
+----------+
| count(*) |
+----------+
| 13 |
+----------+
1 row in set (0.00 sec)
MariaDB [my_wiki]> select count(*) from wikicryptopp_user_groups;
+----------+
| count(*) |
+----------+
| 8 |
+----------+
1 row in set (0.00 sec)
_______________________________________________
MediaWiki-l mailing list
To unsubscribe, go to:
https://lists.wikimedia.org/mailman/listinfo/mediawiki-l
