Page MenuHomePhabricator

dbarratt (David Barratt)
Software Engineer, Anti-Harassment Tools

Projects (11)

Today

  • Clear sailing ahead.

Tomorrow

  • Clear sailing ahead.

Tuesday

  • Clear sailing ahead.

User Details

User Since
May 30 2017, 9:17 PM (131 w, 4 d)
Availability
Available
IRC Nick
davidwbarratt
LDAP User
Dbarratt
MediaWiki User
DBarratt (WMF) [ Global Accounts ]

Recent Activity

Today

dbarratt renamed T208517: Should Wikibase add a property to the page response object that indicates the embedded entities? from Wikibase should add a property to the page response object that indicates the embeded entities to Should Wikibase add a property to the page response object that indicates the embedded entities?.
Sun, Dec 8, 12:45 AM · Core Platform Team, MediaWiki-API, SDC General, MediaWiki-extensions-WikibaseRepository, Wikidata

Fri, Dec 6

dbarratt placed T239680: CU 2.0: Persist the form state up for grabs.
Fri, Dec 6, 10:24 PM · Patch-For-Review, CheckUser, Anti-Harassment (The Letter Song)
dbarratt placed T237298: CheckUser 2.0: Display the data fetched on special page (preliminary check) up for grabs.
Fri, Dec 6, 10:24 PM · Patch-For-Review, Anti-Harassment (The Letter Song), CheckUser
dbarratt placed T238827: Reorganise preliminary check service for paginated results up for grabs.
Fri, Dec 6, 10:23 PM · Patch-For-Review, Anti-Harassment (The Letter Song), CheckUser
dbarratt placed T239716: CU 2.0: Use a factory to create the pager up for grabs.
Fri, Dec 6, 10:23 PM · Patch-For-Review, CheckUser, Anti-Harassment (The Letter Song)
dbarratt closed T236981: CheckUser 2.0: Create a new Special page in CheckUser for the redesigned version, a subtask of T237034: CheckUser 2.0: Input form, as Resolved.
Fri, Dec 6, 8:12 PM · MW-1.35-notes (1.35.0-wmf.8; 2019-11-26), Anti-Harassment (The Letter Song), CheckUser
dbarratt closed T236981: CheckUser 2.0: Create a new Special page in CheckUser for the redesigned version, a subtask of T237039: [Epic] CheckUser 2.0: Preliminary check, as Resolved.
Fri, Dec 6, 8:12 PM · Epic, CheckUser, Anti-Harassment
dbarratt closed T236981: CheckUser 2.0: Create a new Special page in CheckUser for the redesigned version as Resolved.
Fri, Dec 6, 8:12 PM · Patch-For-Review, MW-1.35-notes (1.35.0-wmf.8; 2019-11-26), Anti-Harassment (The Letter Song), CheckUser
dbarratt moved T239680: CU 2.0: Persist the form state from In Progress to Review on the Anti-Harassment (The Letter Song) board.
Fri, Dec 6, 8:03 PM · Patch-For-Review, CheckUser, Anti-Harassment (The Letter Song)
dbarratt updated the task description for T240000: Config on the RequestContext may not be the same as the main config.
Fri, Dec 6, 3:30 PM · Anti-Harassment, MediaWiki-General, Core Platform Team
dbarratt added a project to T240000: Config on the RequestContext may not be the same as the main config: Anti-Harassment.
Fri, Dec 6, 3:23 PM · Anti-Harassment, MediaWiki-General, Core Platform Team
dbarratt created T240000: Config on the RequestContext may not be the same as the main config.
Fri, Dec 6, 3:17 PM · Anti-Harassment, MediaWiki-General, Core Platform Team
dbarratt moved T239680: CU 2.0: Persist the form state from Review to In Progress on the Anti-Harassment (The Letter Song) board.
Fri, Dec 6, 2:30 PM · Patch-For-Review, CheckUser, Anti-Harassment (The Letter Song)
dbarratt moved T239680: CU 2.0: Persist the form state from In Progress to Review on the Anti-Harassment (The Letter Song) board.

I've used the token method (but feel free to change it if the log method makes more sense!)

Fri, Dec 6, 5:12 AM · Patch-For-Review, CheckUser, Anti-Harassment (The Letter Song)
dbarratt added a comment to T239680: CU 2.0: Persist the form state.

To authorize a subsequent request (sorting/paging), checking the existence of a CU log entry (with the CU user, check timestamp, target users) should be necessary and sufficient.

Fri, Dec 6, 4:00 AM · Patch-For-Review, CheckUser, Anti-Harassment (The Letter Song)

Thu, Dec 5

dbarratt added a comment to T239680: CU 2.0: Persist the form state.

It looks like other extensions use that library and sign the JWT with the $wgSecretKey so I think that should be fine.

Thu, Dec 5, 10:26 PM · Patch-For-Review, CheckUser, Anti-Harassment (The Letter Song)
dbarratt renamed T215377: Should Wikidata expose schema.org metadata? from Wikidata does not expose schema.org metadata to Should Wikidata expose schema.org metadata?.
Thu, Dec 5, 7:27 PM · SEO, MediaWiki-extensions-WikibaseRepository, Wikidata
dbarratt added a comment to T239680: CU 2.0: Persist the form state.

I am wondering if it won't be even more straight forward to "just" send all the data directly from the form each time we paginate. We can set up a hidden field or POST param noting whether logging is required based on the UI action...

Thu, Dec 5, 7:26 PM · Patch-For-Review, CheckUser, Anti-Harassment (The Letter Song)

Wed, Dec 4

dbarratt updated the task description for T239680: CU 2.0: Persist the form state.
Wed, Dec 4, 8:09 PM · Patch-For-Review, CheckUser, Anti-Harassment (The Letter Song)
dbarratt renamed T239680: CU 2.0: Persist the form state from CU 2.0: Persist the form state in the user's session to CU 2.0: Persist the form state.
Wed, Dec 4, 6:49 PM · Patch-For-Review, CheckUser, Anti-Harassment (The Letter Song)
dbarratt moved T239680: CU 2.0: Persist the form state from Review to In Progress on the Anti-Harassment (The Letter Song) board.
Wed, Dec 4, 6:49 PM · Patch-For-Review, CheckUser, Anti-Harassment (The Letter Song)

Tue, Dec 3

dbarratt updated the task description for T238827: Reorganise preliminary check service for paginated results.
Tue, Dec 3, 6:00 PM · Patch-For-Review, Anti-Harassment (The Letter Song), CheckUser
dbarratt moved T238827: Reorganise preliminary check service for paginated results from In Progress to Review on the Anti-Harassment (The Letter Song) board.
Tue, Dec 3, 5:59 PM · Patch-For-Review, Anti-Harassment (The Letter Song), CheckUser
dbarratt closed T239682: CU 2.0: Namespace Service Name, a subtask of T237296: CheckUser 2.0: Create service and methods for new CU extension, as Resolved.
Tue, Dec 3, 3:35 PM · MW-1.35-notes (1.35.0-wmf.8; 2019-11-26), Patch-For-Review, Anti-Harassment (The Letter Song), CheckUser
dbarratt closed T239682: CU 2.0: Namespace Service Name as Resolved.

I guess this is fine. I don't really know...

Tue, Dec 3, 3:35 PM · MW-1.35-notes (1.35.0-wmf.10; 2019-12-10), CheckUser, Anti-Harassment (The Letter Song)
dbarratt moved T239716: CU 2.0: Use a factory to create the pager from In Progress to Review on the Anti-Harassment (The Letter Song) board.
Tue, Dec 3, 2:40 PM · Patch-For-Review, CheckUser, Anti-Harassment (The Letter Song)
dbarratt created T239716: CU 2.0: Use a factory to create the pager.
Tue, Dec 3, 2:37 PM · Patch-For-Review, CheckUser, Anti-Harassment (The Letter Song)
dbarratt moved T239682: CU 2.0: Namespace Service Name from Review to QA/Testing on the Anti-Harassment (The Letter Song) board.
Tue, Dec 3, 1:45 PM · MW-1.35-notes (1.35.0-wmf.10; 2019-12-10), CheckUser, Anti-Harassment (The Letter Song)
dbarratt updated the task description for T239680: CU 2.0: Persist the form state.
Tue, Dec 3, 4:35 AM · Patch-For-Review, CheckUser, Anti-Harassment (The Letter Song)
dbarratt moved T238827: Reorganise preliminary check service for paginated results from Review to In Progress on the Anti-Harassment (The Letter Song) board.
Tue, Dec 3, 4:26 AM · Patch-For-Review, Anti-Harassment (The Letter Song), CheckUser
dbarratt claimed T239682: CU 2.0: Namespace Service Name.
Tue, Dec 3, 4:26 AM · MW-1.35-notes (1.35.0-wmf.10; 2019-12-10), CheckUser, Anti-Harassment (The Letter Song)
dbarratt claimed T239680: CU 2.0: Persist the form state.
Tue, Dec 3, 4:26 AM · Patch-For-Review, CheckUser, Anti-Harassment (The Letter Song)
dbarratt moved T239682: CU 2.0: Namespace Service Name from In Progress to Review on the Anti-Harassment (The Letter Song) board.
Tue, Dec 3, 4:23 AM · MW-1.35-notes (1.35.0-wmf.10; 2019-12-10), CheckUser, Anti-Harassment (The Letter Song)
dbarratt updated the task description for T239682: CU 2.0: Namespace Service Name.
Tue, Dec 3, 4:23 AM · MW-1.35-notes (1.35.0-wmf.10; 2019-12-10), CheckUser, Anti-Harassment (The Letter Song)
dbarratt added a subtask for T237296: CheckUser 2.0: Create service and methods for new CU extension: T239682: CU 2.0: Namespace Service Name.
Tue, Dec 3, 4:16 AM · MW-1.35-notes (1.35.0-wmf.8; 2019-11-26), Patch-For-Review, Anti-Harassment (The Letter Song), CheckUser
dbarratt added a parent task for T239682: CU 2.0: Namespace Service Name: T237296: CheckUser 2.0: Create service and methods for new CU extension.
Tue, Dec 3, 4:16 AM · MW-1.35-notes (1.35.0-wmf.10; 2019-12-10), CheckUser, Anti-Harassment (The Letter Song)
dbarratt created T239682: CU 2.0: Namespace Service Name.
Tue, Dec 3, 4:16 AM · MW-1.35-notes (1.35.0-wmf.10; 2019-12-10), CheckUser, Anti-Harassment (The Letter Song)
dbarratt moved T239680: CU 2.0: Persist the form state from In Progress to Review on the Anti-Harassment (The Letter Song) board.
Tue, Dec 3, 4:10 AM · Patch-For-Review, CheckUser, Anti-Harassment (The Letter Song)
dbarratt added a subtask for T237039: [Epic] CheckUser 2.0: Preliminary check: T239680: CU 2.0: Persist the form state.
Tue, Dec 3, 4:08 AM · Epic, CheckUser, Anti-Harassment
dbarratt added a parent task for T239680: CU 2.0: Persist the form state: T237039: [Epic] CheckUser 2.0: Preliminary check.
Tue, Dec 3, 4:08 AM · Patch-For-Review, CheckUser, Anti-Harassment (The Letter Song)
dbarratt created T239680: CU 2.0: Persist the form state.
Tue, Dec 3, 4:08 AM · Patch-For-Review, CheckUser, Anti-Harassment (The Letter Song)

Mon, Dec 2

dbarratt added a comment to T238714: CU 2.0: Fetch information to be displayed in Compare tab.

Where do unregistered edits on that IP fall? is that part of the 10 edits from 3 other users or do we want to exclude those?

Mon, Dec 2, 4:13 PM · Patch-For-Review, Anti-Harassment (The Letter Song), CheckUser
dbarratt added a comment to T239451: DBPerformance: Unexpected masterConns on GET from ApiQueryInfo via BlockManager.php.

But would making intestactions=full be subject to replica lag harm the use cases it's meant to support?

Mon, Dec 2, 4:01 PM · Patch-For-Review, Wikimedia-production-error, MediaWiki-API, Core Platform Team, MediaWiki-User-management, Anti-Harassment, Performance-Team (Radar)
dbarratt closed T238240: Allow HTMLUsersMultiselectField to set max limit on number of selected items, a subtask of T237034: CheckUser 2.0: Input form, as Resolved.
Mon, Dec 2, 3:37 PM · MW-1.35-notes (1.35.0-wmf.8; 2019-11-26), Anti-Harassment (The Letter Song), CheckUser
dbarratt closed T238240: Allow HTMLUsersMultiselectField to set max limit on number of selected items as Resolved.
Mon, Dec 2, 3:37 PM · MW-1.35-notes (1.35.0-wmf.8; 2019-11-26), Anti-Harassment (The Letter Song), CheckUser

Tue, Nov 26

dbarratt moved T238827: Reorganise preliminary check service for paginated results from In Progress to Review on the Anti-Harassment (The Letter Song) board.
Tue, Nov 26, 11:36 PM · Patch-For-Review, Anti-Harassment (The Letter Song), CheckUser
dbarratt updated subscribers of T236225: [Epic] CheckUser 2.0 Improvements .

Looking at the mocks: https://prtksxna.github.io/wmf-cu-prototype/

Tue, Nov 26, 7:07 PM · Epic, Anti-Harassment, CheckUser
dbarratt created T239259: Security Review for whichbrowser/parser.
Tue, Nov 26, 6:14 PM · Security-Team-Reviews, MediaWiki-Vendor, Anti-Harassment, CheckUser

Fri, Nov 22

dbarratt added a comment to T175587: Add a user-agent parser to CheckUser.

Gotcha. Good to know.
Rhetorical question: Why couldn't they have simplified this by making the UA simply be a concatenation of the three parts. 🤔

Fri, Nov 22, 6:38 PM · Anti-Harassment, CheckUser
dbarratt claimed T238827: Reorganise preliminary check service for paginated results.
Fri, Nov 22, 2:11 PM · Patch-For-Review, Anti-Harassment (The Letter Song), CheckUser
dbarratt moved T238827: Reorganise preliminary check service for paginated results from Ready to In Progress on the Anti-Harassment (The Letter Song) board.
Fri, Nov 22, 2:11 PM · Patch-For-Review, Anti-Harassment (The Letter Song), CheckUser
dbarratt moved T237296: CheckUser 2.0: Create service and methods for new CU extension from Review to QA/Testing on the Anti-Harassment (The Letter Song) board.
Fri, Nov 22, 1:33 AM · MW-1.35-notes (1.35.0-wmf.8; 2019-11-26), Patch-For-Review, Anti-Harassment (The Letter Song), CheckUser

Thu, Nov 21

dbarratt added a comment to T175587: Add a user-agent parser to CheckUser.

For each UA we have the three parts. For 22 records, that is 66 pieces. So for each library, how many of those were right/wrong would be helpful to know.

Thu, Nov 21, 9:09 PM · Anti-Harassment, CheckUser
dbarratt added a comment to T175587: Add a user-agent parser to CheckUser.

It would be helpful to quantify how often we got accurate results from both the libraries.

Thu, Nov 21, 5:03 PM · Anti-Harassment, CheckUser
dbarratt added a comment to T238827: Reorganise preliminary check service for paginated results.
Thu, Nov 21, 4:36 PM · Patch-For-Review, Anti-Harassment (The Letter Song), CheckUser
dbarratt updated subscribers of T238827: Reorganise preliminary check service for paginated results.

It seems like we should:

  1. extend TablePager
  2. implement getQueryInfo() (to specify the initial query)
  3. implement preprocessResults() (to attach the additional data to each row)
  4. implement getFieldNames() (to ensure the field names are what we want to display)
Thu, Nov 21, 3:49 PM · Patch-For-Review, Anti-Harassment (The Letter Song), CheckUser
dbarratt added a comment to T175587: Add a user-agent parser to CheckUser.

I retrieved 20 random User Agent strings from the cu_changes table on eswiki and put them into a spreadsheet and compared the parsing of devicedetector.net and whichbrowser.net.

Thu, Nov 21, 3:22 PM · Anti-Harassment, CheckUser

Wed, Nov 20

dbarratt committed R2697:e46d47b6edce: Add CORS headers (authored by dbarratt).
Add CORS headers
Wed, Nov 20, 3:44 AM
dbarratt committed R2697:2e374113a051: Use provided port (authored by dbarratt).
Use provided port
Wed, Nov 20, 2:44 AM
dbarratt committed R2697:2d51934c1aa6: Remove toolname (authored by dbarratt).
Remove toolname
Wed, Nov 20, 1:54 AM
dbarratt committed R2697:c509869e80e6: MediaWiki Version (authored by dbarratt).
MediaWiki Version
Wed, Nov 20, 1:51 AM
dbarratt added a comment to T175587: Add a user-agent parser to CheckUser.

I see. I think we need some baseline estimate of how often it is wrong. If it's like 1 in 10 cases, then maybe we could split up the UA and give them a disclaimer that it might be wrong and give them an option to see the complete UA. If it's 1 in 2 cases, we probably don't want to do the splitting.

Wed, Nov 20, 12:26 AM · Anti-Harassment, CheckUser
dbarratt added a comment to T200938: Special:CentralAuth should provide the same blocking information as Special:BlockList does.

or rather, the problem does not exist on he, it only exists on en.

Wed, Nov 20, 12:25 AM · MW-1.35-notes (1.35.0-wmf.5; 2019-11-05), Core Platform Team Workboards (Clinic Duty Team), Anti-Harassment (The Letter Song), Patch-For-Review, MediaWiki-extensions-CentralAuth, Stewards-and-global-tools, MediaWiki-User-management
dbarratt added a comment to T200938: Special:CentralAuth should provide the same blocking information as Special:BlockList does.

@dbarratt Has this been deployed already? In that case we can verify if the problem exists on the actual hewiki.

Wed, Nov 20, 12:24 AM · MW-1.35-notes (1.35.0-wmf.5; 2019-11-05), Core Platform Team Workboards (Clinic Duty Team), Anti-Harassment (The Letter Song), Patch-For-Review, MediaWiki-extensions-CentralAuth, Stewards-and-global-tools, MediaWiki-User-management
dbarratt added a comment to T175587: Add a user-agent parser to CheckUser.

Hmm, if we can have a sense of how inaccurate a parsed UA is (say, 80% or 20%) then based on that we can decide whether to display the complete UA or not. One of the use cases of this is to also know when the user might have spoofed their UA.

Wed, Nov 20, 12:17 AM · Anti-Harassment, CheckUser

Tue, Nov 19

dbarratt added a comment to T238603: Placeholder text on Special:Investigate seems unnecessary.

Since the user/ip input is complex, and not something we have elsewhere in our system, I am inclined to give the user a bit more guidance here. It is a bit odd that an input could accept both usernames and IPs and I am expecting that there might be some confusion around this. I suggest we keep this for now and take another look at it after some usability testing.

Tue, Nov 19, 5:02 PM · CheckUser, Anti-Harassment
dbarratt closed T234765: Broken docker images? as Invalid.
Tue, Nov 19, 4:08 PM · MediaWiki-Docker

Mon, Nov 18

dbarratt renamed T238603: Placeholder text on Special:Investigate seems unnecessary from Placeholder text on `Special:Investigate` seems unnecessary to Placeholder text on Special:Investigate seems unnecessary.
Mon, Nov 18, 10:32 PM · CheckUser, Anti-Harassment
dbarratt renamed T238603: Placeholder text on Special:Investigate seems unnecessary from Remove the placeholder text from the form on Special:Investigate to Placeholder text on `Special:Investigate` seems unnecessary.
Mon, Nov 18, 10:32 PM · CheckUser, Anti-Harassment
dbarratt updated subscribers of T238603: Placeholder text on Special:Investigate seems unnecessary.
Mon, Nov 18, 10:31 PM · CheckUser, Anti-Harassment
dbarratt added a comment to T237034: CheckUser 2.0: Input form.

I've created T238603: Placeholder text on Special:Investigate seems unnecessary as a follow up to my concern in T237034#5672654

Mon, Nov 18, 10:31 PM · MW-1.35-notes (1.35.0-wmf.8; 2019-11-26), Anti-Harassment (The Letter Song), CheckUser
dbarratt added a parent task for T237034: CheckUser 2.0: Input form: T238603: Placeholder text on Special:Investigate seems unnecessary.
Mon, Nov 18, 10:30 PM · MW-1.35-notes (1.35.0-wmf.8; 2019-11-26), Anti-Harassment (The Letter Song), CheckUser
dbarratt added a subtask for T238603: Placeholder text on Special:Investigate seems unnecessary: T237034: CheckUser 2.0: Input form.
Mon, Nov 18, 10:30 PM · CheckUser, Anti-Harassment
dbarratt created T238603: Placeholder text on Special:Investigate seems unnecessary.
Mon, Nov 18, 10:29 PM · CheckUser, Anti-Harassment
dbarratt moved T237034: CheckUser 2.0: Input form from Review to QA/Testing on the Anti-Harassment (The Letter Song) board.
Mon, Nov 18, 10:27 PM · MW-1.35-notes (1.35.0-wmf.8; 2019-11-26), Anti-Harassment (The Letter Song), CheckUser
dbarratt added a comment to T237034: CheckUser 2.0: Input form.

@dbarratt See screenshots in T237034#5661181 and @Prtksxna's reply in T237034#5670732 - we've removed the help text for the User and Reason widgets to make it less busy, and made the placeholder text more informative instead

Mon, Nov 18, 6:57 PM · MW-1.35-notes (1.35.0-wmf.8; 2019-11-26), Anti-Harassment (The Letter Song), CheckUser
dbarratt added a comment to T237034: CheckUser 2.0: Input form.

@Prtksxna This seems really busy to me...


the placeholder text seems unnecessary.... do we even need it at all?

Mon, Nov 18, 6:45 PM · MW-1.35-notes (1.35.0-wmf.8; 2019-11-26), Anti-Harassment (The Letter Song), CheckUser
dbarratt updated the task description for T237296: CheckUser 2.0: Create service and methods for new CU extension.
Mon, Nov 18, 3:38 PM · MW-1.35-notes (1.35.0-wmf.8; 2019-11-26), Patch-For-Review, Anti-Harassment (The Letter Song), CheckUser
dbarratt added a comment to T237034: CheckUser 2.0: Input form.

How about UserName? Or would that be too generic? Thoughts @Tchanders @Niharika?

Mon, Nov 18, 2:50 PM · MW-1.35-notes (1.35.0-wmf.8; 2019-11-26), Anti-Harassment (The Letter Song), CheckUser
dbarratt updated the task description for T229484: After closing, browser sometimes scrolls to the top of the page in Firefox 70.
Mon, Nov 18, 2:30 PM · Patch-For-Review, Structured-Data-Backlog, Readers-Web-Backlog (Tracking), Upstream, Browser-Support-Firefox, MediaViewer
dbarratt updated the task description for T229484: After closing, browser sometimes scrolls to the top of the page in Firefox 70.
Mon, Nov 18, 2:24 PM · Patch-For-Review, Structured-Data-Backlog, Readers-Web-Backlog (Tracking), Upstream, Browser-Support-Firefox, MediaViewer
dbarratt updated the task description for T229484: After closing, browser sometimes scrolls to the top of the page in Firefox 70.
Mon, Nov 18, 2:19 PM · Patch-For-Review, Structured-Data-Backlog, Readers-Web-Backlog (Tracking), Upstream, Browser-Support-Firefox, MediaViewer
dbarratt added a comment to T229484: After closing, browser sometimes scrolls to the top of the page in Firefox 70.

This is driving me bonkers... for me it seems to happen on Firefox, but not Chrome

Mon, Nov 18, 3:33 AM · Patch-For-Review, Structured-Data-Backlog, Readers-Web-Backlog (Tracking), Upstream, Browser-Support-Firefox, MediaViewer
dbarratt added a project to T229484: After closing, browser sometimes scrolls to the top of the page in Firefox 70: Readers-Web-Backlog.
Mon, Nov 18, 3:30 AM · Patch-For-Review, Structured-Data-Backlog, Readers-Web-Backlog (Tracking), Upstream, Browser-Support-Firefox, MediaViewer

Sun, Nov 17

dbarratt added a project to T237505: Globaluserinfo API module should allow getting data for more than one user at once: Anti-Harassment.
Sun, Nov 17, 10:22 PM · Anti-Harassment, Patch-For-Review, User-Urbanecm, MediaWiki-extensions-CentralAuth

Sat, Nov 16

dbarratt committed rEGQL8998704ba77a: Create distributed config (authored by dbarratt).
Create distributed config
Sat, Nov 16, 4:09 AM

Fri, Nov 15

dbarratt added a comment to T234557: Get rough stats for time taken to resolve a case from CU log.

I ran this query on eswiki:

SELECT
  TO_SECONDS(MAX(cul_timestamp)) - TO_SECONDS(MIN(cul_timestamp)) AS duration
FROM cu_log
WHERE STR_TO_DATE(cul_timestamp, '%Y%m%d%H%i%S') > DATE_SUB(NOW(), INTERVAL 1 YEAR)
GROUP BY cul_user, cul_reason
HAVING COUNT(cul_id) > 1
ORDER BY cul_timestamp
Fri, Nov 15, 5:14 PM · Anti-Harassment (The Letter Song), CheckUser
dbarratt added a comment to T234557: Get rough stats for time taken to resolve a case from CU log.

I could create a graph as you suggested earlier, that might reveal more insights.

Fri, Nov 15, 3:03 AM · Anti-Harassment (The Letter Song), CheckUser
dbarratt added a comment to T234557: Get rough stats for time taken to resolve a case from CU log.

I think we can take a closer look at the actual data in these rows and see if there's another way to slice it to identify some patterns.

Fri, Nov 15, 2:49 AM · Anti-Harassment (The Letter Song), CheckUser

Thu, Nov 14

dbarratt added a comment to T235047: [Spike: 4 hours] RedirectSpecialPage not setting block cookies after redirect.

I believe it is because the headers are not being set on the request due to what I explained in my last comment

Thu, Nov 14, 9:17 PM · Core Platform Team Workboards (Clinic Duty Team), Spike, MediaWiki-User-management
dbarratt updated the task description for T175587: Add a user-agent parser to CheckUser.
Thu, Nov 14, 8:34 PM · Anti-Harassment, CheckUser
dbarratt changed the visibility for T234557: Get rough stats for time taken to resolve a case from CU log.
Thu, Nov 14, 7:53 PM · Anti-Harassment (The Letter Song), CheckUser
dbarratt moved T238240: Allow HTMLUsersMultiselectField to set max limit on number of selected items from Done to QA/Testing on the Anti-Harassment (The Letter Song) board.
Thu, Nov 14, 4:25 PM · MW-1.35-notes (1.35.0-wmf.8; 2019-11-26), Anti-Harassment (The Letter Song), CheckUser
dbarratt added a comment to T238240: Allow HTMLUsersMultiselectField to set max limit on number of selected items.

I don't see anything currently that uses HTMLUsersMultiselectField at the moment.

Thu, Nov 14, 4:25 PM · MW-1.35-notes (1.35.0-wmf.8; 2019-11-26), Anti-Harassment (The Letter Song), CheckUser
dbarratt closed T227412: Partial blocks leads to wrong error messages, a subtask of T190350: Epic: ⚡️ Partial blocks, as Resolved.
Thu, Nov 14, 2:15 PM · Anti-Harassment, MediaWiki-User-management
dbarratt closed T227412: Partial blocks leads to wrong error messages, a subtask of T204903: Epic ⚡️ unprioritized Partial Blocks features, as Resolved.
Thu, Nov 14, 2:15 PM · Anti-Harassment
dbarratt closed T227412: Partial blocks leads to wrong error messages as Resolved.
Thu, Nov 14, 2:15 PM · MW-1.35-notes (1.35.0-wmf.8; 2019-11-26), Anti-Harassment (The Letter Song), Beta-Cluster-reproducible, User-DannyS712, MediaWiki-User-management
dbarratt reopened T238240: Allow HTMLUsersMultiselectField to set max limit on number of selected items as "Open".

Re-opening to give opportunity for QA.

Thu, Nov 14, 3:38 AM · MW-1.35-notes (1.35.0-wmf.8; 2019-11-26), Anti-Harassment (The Letter Song), CheckUser
dbarratt reopened T238240: Allow HTMLUsersMultiselectField to set max limit on number of selected items, a subtask of T237034: CheckUser 2.0: Input form, as Open.
Thu, Nov 14, 3:38 AM · MW-1.35-notes (1.35.0-wmf.8; 2019-11-26), Anti-Harassment (The Letter Song), CheckUser
dbarratt added a comment to T237852: System Administrator avoids CSRF attacks on MediaWiki REST API.

That's why I said "basically". The fact that access tokens are sufficient for authorization was not relevant to my point, which was that OAuth 2.0 is not significantly more difficult for clients to implement than traditional CSRF tokens.

Thu, Nov 14, 2:13 AM · Core Platform Team Workboards (Green), Security-Team, Story, MediaWiki-REST-API, CPT Initiatives (Core REST API in PHP)