Bots on Talk Pages
Anomie, I know we are having a content argument on a particular topic. But here I wanted to mention something completely different. You seem to know about Bots. Is Wikipedia doing anything about the Bot pollution issue on talk pages? It’s got ridiculous. Many talk pages have more automated Bot messages that no one reads than they have actual user discussion. Are there others like me who think this is a big problem on WP? Thanks. Frenchmalawi (talk) 01:42, 1 April 2022 (UTC)
- I can't say I've heard any other complaints about that particular issue. Anomie⚔ 11:27, 1 April 2022 (UTC)
Comment
Hi, I hope you can steer me in the right direction. I'm trying to get a handle on the number of users botching their attempt at a WP:Courtesy vanishing. Many are creating their user pages with a {{db-u1}} template, oftentimes creating what is their only trace of being on Wikipedia, and defeating their own attempt to leave with no trace.
I think that searching for the edit summary "Created page with '{{db-u1}}'" is the simplest way to find them. However even a simple query
SELECT count(*)
FROM comment ;
times out (actually, it was stopped after a long while) - Quarry 63499. Is there a better way to find the info? Thanks, Cabayi (talk) 15:37, 1 April 2022 (UTC)
- Yeah, trying to select millions of rows isn't going to work, nor is selecting by the comment text since there's no database index on the column. What you'd probably want to do is calculate the value for
comment_hash
and select by that. The hash for[[WP:AES|←]]Created page with '{{db-u1}}'
is -758013194, for example. But I think even that may not help you much, since there's no index onrevision.rev_comment_id
or similar columns either. Anomie⚔ 17:26, 1 April 2022 (UTC)
Spam Blacklist Phab
Hi Anomie! It's been awhile since we've said "hello" to one another! I hope you're doing well and that you're having a great weekend. :-) I was looking through the spam blacklist extension documentation, and it mentioned T36928. I looked through the phab ticket, and saw that the implementation of the patch is currently stalled because you gave the changes a '-2' a few years back, and due to concerns about some users having the right and others not. Many users have responded since you added the comment stating that the patch doesn't assign the rights to anyone, but simply makes the user right available. It looks like users have added you back as a subscriber to the ticket numerous times attempting to ask you about it, and you subsequently removed yourself without responding. I was just curious as to what was going on exactly. Do you still think that the changes shouldn't move forward, even though others believe that they've addressed your stated issue? Are you not responding on purpose? What's going on? Again, I'm just curious and wanted to ask you about it. :-) Thanks - ~Oshwah~(talk) (contribs) 23:23, 8 May 2022 (UTC)
- I literally can't change that -2 now even if I wanted to, thanks to certain terrible WMF managers doing some terrible management and me not having any motivation to find out what hoops they might have wanted jumped through to regain the access I had back in 2012 before I was hired. As for the ticket, I can't say that any of the arguments people have made convince me (the moment the right gets added but not assigned to anyone, people will start requesting it be added on various wikis) but it's not my job anymore anyway. Anomie⚔ 23:31, 8 May 2022 (UTC)
Happy First Edit Day!
![]() |
Happy First Edit Day, Anomie, from the Wikipedia Birthday Committee! Have a great day! Comr Melody Idoghor (talk) 13:29, 18 May 2022 (UTC) |