User talk:SQL

Ideas on the road

• Ideas moved to the issue board @ github: [1] SQL^{Query me!} 01:26, 5 May 2019 (UTC)

TODO: Replace rc_user on SQLBot

Per Wikipedia:Village_pump_(technical)#Major_schema_changes_coming_to_database_replicas / phab:T223406, I've got to at a minimum update SQLBot's task to clear stale AIV reports by June 3. I'm sure I have other tools that are impacted, but I don't really have the bandwidth right now to track all the uses of these very commonly used tables down and refactor them. Looks like line 72 of parse.php is the starting point. SQL^{Query me!} 05:55, 21 May 2019 (UTC)

In the event that I can't get to this, I can probably disable the active admin logic fairly easily until I can work on it. Link for myself for sometime later: mw:Manual:Actor_table. SQL^{Query me!} 06:01, 21 May 2019 (UTC)

If it helps someone else with the migration, for SQLBot, the offending query:

SELECT count( distinct rc_user ) as active
FROM recentchanges
INNER JOIN user_groups ON ug_user = rc_user
WHERE rc_timestamp > now() - interval 1 hour
        AND ug_group = "sysop";

Needed to be changed to:

SELECT count( distinct rc_actor ) as active
FROM recentchanges
join actor on rc_actor = actor_id
INNER JOIN user_groups ON ug_user = actor_user
WHERE rc_timestamp > now() - interval 1 hour
        AND ug_group = "sysop";

I'm going back to bed. SQL^{Query me!} 06:11, 21 May 2019 (UTC)

This also appears to affect botwatch (I've just shut it down, I'm not sure many used it in any case - so likely permanent), and isprangefinder (I'll either shut it down tomorrow, or update it in the unlikely event that I have time). I'm sure it affects aivanalysis - but to be fair that has needed some TLC for a while, so I've shut it down. I think AFC-Ores will be OK. IPCheck shouldn't be affected. SQL^{Query me!} 06:32, 21 May 2019 (UTC)

Ah, isprangefinder uses the API instead of direct queries against ipblocks. Not depreciating that tool. SQL^{Query me!} 07:17, 21 May 2019 (UTC)

AIV reports

Hi. Right now the AIV analysis page isn't showing me any reports made by any user after about 27 November 2018. That's confused at least one user, so I added a disclaimer to Template:RfA toolbox. I'm not sure if someone's reported this already, but I couldn't find anything in your talk archives. Thought you'd want to know, in any case. Suffusion of Yellow (talk) 23:18, 24 April 2019 (UTC)

Suffusion of Yellow, I apologize - I'm out of town at the moment. I should be back next week, and I will try to look at the issue then. It might be best to remove it from the RFA toolbox for the time being. I'm going to have a lot of work to catch up on when I get back, and it could be a little bit before I can dedicate much time to it. SQL^{Query me!} 03:35, 25 April 2019 (UTC)

Please comment on Talk:Murder of Anastasiya Meshcheryakova

The feedback request service is asking for participation in this request for comment on Talk:Murder of Anastasiya Meshcheryakova. Legobot (talk) 04:31, 17 May 2019 (UTC)

Please comment on Template talk:Infobox country

The feedback request service is asking for participation in this request for comment on Template talk:Infobox country. Legobot (talk) 04:33, 20 May 2019 (UTC)

Tech News: 2019-21

Latest tech news from the Wikimedia technical community. Please tell other users about these changes. Not all changes will affect you. Translations are available.

Recent changes

• The report for phase 1 of the talk pages consultation 2019 has been published. Communities are invited to start phase 2 of the consultation on their wikis.

Problems

• File descriptions for files from Commons were not shown properly on other Wikimedia wikis for a few days. For example the image descriptions and license information were missing. This has now been fixed. [2][3]
• Some diffs show an error message when you try to see them. The developers are working on fixing it. It could be because of some edit comments. [4][5]

Changes later this week

• The new version of MediaWiki will be on test wikis and MediaWiki.org from 21 May. It will be on non-Wikipedia wikis and some Wikipedias from 22 May. It will be on all wikis from 23 May (calendar).

Meetings

• You can join the technical advice meeting on IRC. During the meeting, volunteer developers can ask for advice. The meeting will be on 22 May at 15:00 (UTC). See how to join.

Future changes

• The content translation tool on Wikipedia can use machine translations. There is a system to stop translations where the editors do not fix machine translation mistakes. This warns or stops them if they seem to just copy what the machine translation gives them. If this system is too strict or not strict enough you can tell the language team. [6]
• The Wikidata wbeditentity API endpoint will remove all aliases if the request includes an empty alias. This is how it supposed to work. It has not been working this way because of a bug. This will start on 12 June. [7]

Tech news prepared by Tech News writers and posted by bot • Contribute • Translate • Get help • Give feedback • Subscribe or unsubscribe.

13:04, 20 May 2019 (UTC)

RD needed

Could you handle a RD#2 on rev 898035474? TIA, --Xover (talk) 06:41, 21 May 2019 (UTC)

Xover,  Done, thanks! SQL^{Query me!} 06:43, 21 May 2019 (UTC)

Please comment on Wikipedia:Talk pages consultation 2019/Phase 2

The feedback request service is asking for participation in this request for comment on Wikipedia:Talk pages consultation 2019/Phase 2. Legobot (talk) 04:29, 24 May 2019 (UTC)

UAA reports? Suggestion

Is there scope for SQLBot to remove stale reports from WP:UAA as it does those at AIV? In particular the bot reported usernames, which tends to get very long at times, creating a backlogs for account names that typically not a serious / blatant issue and thus requiring me and other admins to clear them manually. NJA | talk 12:47, 24 May 2019 (UTC)

NJA, That's a good idea. It would require discussion, and consensus to implement - as well as a new BRFA. The development bit should be the easy part of the equation. SQL^{Query me!} 04:46, 25 May 2019 (UTC)

Please comment on Wikipedia talk:Notability (academics)

The feedback request service is asking for participation in this request for comment on Wikipedia talk:Notability (academics). Legobot (talk) 04:30, 25 May 2019 (UTC)