Open main menu


Wikipedia Administrator.svgThis user has been an admin for
11 years, 7 months and 24 days.
235 Users were created in the last hour

Ideas on the roadEdit

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

TODO: Replace rc_user on SQLBotEdit

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. SQLQuery 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. SQLQuery 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. SQLQuery 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. SQLQuery me! 06:32, 21 May 2019 (UTC)
Ah, isprangefinder uses the API instead of direct queries against ipblocks. Not depreciating that tool. SQLQuery me! 07:17, 21 May 2019 (UTC)

AIV reportsEdit

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. SQLQuery me! 03:35, 25 April 2019 (UTC)

Please comment on Talk:Murder of Anastasiya MeshcheryakovaEdit

Please comment on Template talk:Infobox countryEdit

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-21Edit

13:04, 20 May 2019 (UTC)

RD neededEdit

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

Xover,   Done, thanks! SQLQuery me! 06:43, 21 May 2019 (UTC)
Return to the user page of "SQL".