On Fri, Dec 20, 2019 at 3:17 AM Valerio Pelliccioni wrote:
>
> 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 t
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 |
--
On Thu, Dec 19, 2019 at 3:31 PM Valerio Pelliccioni wrote:
>
> Jeff,
> I've tried in the maintenance directory (a minute ago):
>
> vmp@tunearch:/var/www/w/maintenance# php cleanupUsersWithNoId.php
> --dbuser= --dbpass= --force --prefix=* --conf=../LocalSettings.php
> vmp@tunearch:/var/www/w/maint
Jeff,
I've tried in the maintenance directory (a minute ago):
vmp@tunearch:/var/www/w/maintenance# php cleanupUsersWithNoId.php
--dbuser= --dbpass= --force --prefix=* --conf=../LocalSettings.php
vmp@tunearch:/var/www/w/maintenance# php update.php
... and it works, at least for me with:
_
Hi Everyone,
We are getting about 11,000 of these due to a spammer getting in a
couple of years ago:
... log_id=4200
... log_id=4300
... log_id=4400
User name "Awpgkcm9ly0hjqagqrpl" is usable, cannot create an anonymous
actor for it. Run maintenance/cleanupUsersWithNoId.php to fix this
situation.
