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" <noloader(a)gmail.com> wrote:
On Thu, Dec 19, 2019 at 3:31 PM Valerio Pelliccioni <vmp(a)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)