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