TK-999 (TK-999)
User

Projects

Today

  • Clear sailing ahead.

Tomorrow

  • Clear sailing ahead.

Sunday

  • Clear sailing ahead.

User Details

User Since
Feb 7 2017, 10:09 PM (71 w, 2 d)
Availability
Available
LDAP User
TK-999
MediaWiki User
Unknown

Recent Activity

May 19 2018

TK-999 awarded T194901: MediaWiki and GDPR a Orange Medal token.
May 19 2018, 8:58 PM · MediaWiki-Stakeholders-Group, Wikimedia-Hackathon-2018
TK-999 added a comment to T195028: Add goat import and export capability.

I believe this will be especially necessary given the data portability clauses of the GDPR. We must provide users with a way to export their own goats.

May 19 2018, 6:14 PM · Goatification, Wikimedia-Hackathon-2018

Apr 28 2018

TK-999 added a comment to T177024: Function to replace invisible characters with blank.

Probably the character 2062 (INVISIBLE TIMES) should be added to the list. For example, https://community.wikia.com/wiki/Special:Contributions/Low_Spark_of_Lyman%E2%81%A2%E2%81%A2 has this character appended to this user name, but it's visually indistinguishable from https://community.wikia.com/wiki/Special:Contributions/Low_Spark_of_Lyman .

Apr 28 2018, 11:10 PM · AntiSpoof

Apr 26 2018

TK-999 added a comment to T182177: PHP function each() has been deprecated.

FYI, PHP 7.2 compatibility issues are fixed in version 1.10.2 of the PEAR Mail_Mime library.

Apr 26 2018, 2:27 PM · PHP 7.2 support, Upstream, MediaWiki-Vendor

Mar 20 2018

TK-999 added a comment to T183300: Use list=blocks to return all single IP blocks in a CIDR.

I think that's MySQL specific and won't work on other supported RDBMSes. AFAIK Postgres for instance has designated data types like cidr instead of this helper.

Mar 20 2018, 4:26 PM · MediaWiki-API
TK-999 added a comment to T183300: Use list=blocks to return all single IP blocks in a CIDR.

I was thinking that it might help with this task, if we separated concerns between the ipblocks.ipb_user and ipblocks.ipb_address fields:

Mar 20 2018, 1:40 PM · MediaWiki-API
TK-999 added a comment to T51504: ipb_range_start and ipb_range_end should be blank for single-IP blocks.

Thank you very much for the quick review @Anomie 🙂 I have amended the patch set according to your notes.

Mar 20 2018, 1:19 PM · Patch-For-Review, Performance, MediaWiki-User-management

Mar 19 2018

TK-999 added a comment to T50767: Support 'utf8mb4' character set in MySQL 5.5 and above.

What collation would MediaWiki use for the utf8mb4character set? I assume it'd have to be the binary collation utf8mb4_bin, but it'd be good to clarify this. Sadly case- and accent-sensitive collations for Unicode character sets will only be available with MySQL 8.0 😞

Mar 19 2018, 8:51 PM · MediaWiki-Database

Mar 16 2018

TK-999 added a project to T181658: Numeric page titles can cause query page reports to stop updating: MediaWiki-Special-pages.
Mar 16 2018, 12:46 PM · MediaWiki-Special-pages, Patch-For-Review, MediaWiki-Database

Mar 14 2018

TK-999 added a comment to T189702: Provide alternative interwiki transclusion cache backends.

Yeah, the only reason created this separate ticket since it represents an improvement that can be done within the bounds of the existing interwiki transclusion system without requiring an extensive overhaul or migration process.

Mar 14 2018, 7:27 PM · Patch-For-Review, MediaWiki-Cache
TK-999 added a comment to T189702: Provide alternative interwiki transclusion cache backends.

I'll gladly work on this if it is deemed to be acceptable.

Mar 14 2018, 4:39 PM · Patch-For-Review, MediaWiki-Cache
TK-999 created T189702: Provide alternative interwiki transclusion cache backends.
Mar 14 2018, 4:38 PM · Patch-For-Review, MediaWiki-Cache
TK-999 added a comment to T164167: change_tag table needs redesign.

Ohh, that is true, I'll have to rethink it. Still, it might make sense to consider a different schema in the long run to avoid the previously described issues...

Mar 14 2018, 2:12 PM · Schema-change, MediaWiki-Change-tagging, DBA
TK-999 added a comment to T164167: change_tag table needs redesign.

Since the schema of change_tags table is due to be adjusted, what do you think of tweaking it to avoid the current situation with 3 UNIQUE indexes and nullable columns? I was thinking of something along the lines of:

Mar 14 2018, 1:24 PM · Schema-change, MediaWiki-Change-tagging, DBA

Nov 29 2017

TK-999 added a comment to T181658: Numeric page titles can cause query page reports to stop updating.
-- Some sort of stored value. Sizes, counts...
qc_value int unsigned NOT NULL default 0,

I wonder what it's trying to put in it...

Nov 29 2017, 5:49 PM · MediaWiki-Special-pages, Patch-For-Review, MediaWiki-Database
TK-999 updated the task description for T181658: Numeric page titles can cause query page reports to stop updating.
Nov 29 2017, 5:44 PM · MediaWiki-Special-pages, Patch-For-Review, MediaWiki-Database
TK-999 created T181658: Numeric page titles can cause query page reports to stop updating.
Nov 29 2017, 5:40 PM · MediaWiki-Special-pages, Patch-For-Review, MediaWiki-Database

Nov 16 2017

TK-999 added a comment to T180752: Support customizing base path of Parsoid server.

Yes, after further investigation it seems we can use a proxy just fine. Thanks for your quick comments! This ticket can be closed then

Nov 16 2017, 11:36 PM · Parsoid
TK-999 added a comment to T180752: Support customizing base path of Parsoid server.

You can run multiple instances of Parsoid on various ports or (better) use a single Parsoid instance for all the various services. Parsoid can be configured with different api prefixes for different servers; in fact that's how WMF runs it in production (each Parsoid instance can handle all the different wmf sites).

Nov 16 2017, 11:18 PM · Parsoid
TK-999 created T180752: Support customizing base path of Parsoid server.
Nov 16 2017, 10:57 PM · Parsoid

Nov 9 2017

TK-999 added a comment to T180157: DatabaseMysqlBase::fieldExists check can trigger full table scan.

Yeah, the actual query indeed stops at the first row. Thanks for clarifying :)

Nov 9 2017, 8:06 PM · Patch-For-Review, MediaWiki-Database
TK-999 added a comment to T180157: DatabaseMysqlBase::fieldExists check can trigger full table scan.

On a MySQL 5.7 install:

Nov 9 2017, 7:38 PM · Patch-For-Review, MediaWiki-Database
TK-999 renamed T180157: DatabaseMysqlBase::fieldExists check can trigger full table scan from DatabaseBase::fieldExists check can trigger full table scan to DatabaseMysqlBase::fieldExists check can trigger full table scan.
Nov 9 2017, 7:22 PM · Patch-For-Review, MediaWiki-Database
TK-999 added a comment to T180157: DatabaseMysqlBase::fieldExists check can trigger full table scan.

Yeah, that's my bad - but the query is still there via DatabaseMysqlBase.

Nov 9 2017, 7:22 PM · Patch-For-Review, MediaWiki-Database
TK-999 added a comment to T180157: DatabaseMysqlBase::fieldExists check can trigger full table scan.

A potential alternative would be to use a DESCRIBE query here, kind of like this.

Nov 9 2017, 7:20 PM · Patch-For-Review, MediaWiki-Database
TK-999 created T180157: DatabaseMysqlBase::fieldExists check can trigger full table scan.
Nov 9 2017, 7:19 PM · Patch-For-Review, MediaWiki-Database

Sep 4 2017

TK-999 updated subscribers of T174908: Special:BrowseData causes error on MySQL 5.7 slave.
Sep 4 2017, 12:15 PM · Patch-For-Review, MediaWiki-extensions-SemanticDrilldown
TK-999 created T174908: Special:BrowseData causes error on MySQL 5.7 slave.
Sep 4 2017, 10:24 AM · Patch-For-Review, MediaWiki-extensions-SemanticDrilldown

May 23 2017

Qgil awarded T165981: Implement a prototype JavaScript review system for MediaWiki a Cookie token.
May 23 2017, 12:42 PM · Developer-Relations, Community-Liaisons, MediaWiki-extension-requests, Security-General, JavaScript, Wikimedia-Hackathon-2017

May 22 2017

TK-999 added a comment to T71445: Implement a sane code-review process for MediaWiki JS/CSS pages on Wikimedia sites.

Based on my work around T165981 during the 2017 Hackathon - which essentially involved creating a prototype implementation of Wikia's ContentReview extension compatible with core MediaWiki - I would like to note the following:

May 22 2017, 1:11 AM · Developer-Wishlist (2017), Developer-Relations, Gadgets, Security-General, JavaScript, Wikimedia-General-or-Unknown

May 21 2017

TK-999 added a comment to T165981: Implement a prototype JavaScript review system for MediaWiki.

A few notes on how we can progress from here:

May 21 2017, 5:07 PM · Developer-Relations, Community-Liaisons, MediaWiki-extension-requests, Security-General, JavaScript, Wikimedia-Hackathon-2017
TK-999 added a comment to T165981: Implement a prototype JavaScript review system for MediaWiki.

Demo produced during hackathon is at https://github.com/TK-999/mediawiki-extensions-ContentReview

May 21 2017, 1:59 PM · Developer-Relations, Community-Liaisons, MediaWiki-extension-requests, Security-General, JavaScript, Wikimedia-Hackathon-2017
TK-999 added a comment to T162634: If you block an IP address as anonymous only, and then change it to a hardblock or vise versa, it is recorded as a completely new block.

Looks like this is the same issue that was reported in T157508

May 21 2017, 1:23 PM · MediaWiki-User-management
TK-999 created T165981: Implement a prototype JavaScript review system for MediaWiki.
May 21 2017, 12:00 PM · Developer-Relations, Community-Liaisons, MediaWiki-extension-requests, Security-General, JavaScript, Wikimedia-Hackathon-2017

Feb 16 2017

TK-999 edited projects for T157718: Skip User edit count computation in Autopromote if APCOND_EDITCOUNT isn't used, added: MediaWiki-Authentication-and-authorization; removed MediaWiki-General-or-Unknown.
Feb 16 2017, 12:03 AM · MW-1.30-release-notes (WMF-deploy-2017-05-23_(1.30.0-wmf.2)), Performance, MediaWiki-Authentication-and-authorization

Feb 15 2017

TK-999 added a comment to T157718: Skip User edit count computation in Autopromote if APCOND_EDITCOUNT isn't used.

I've attached a patch which adds a simple check to return early if condition is 0 or invalid, with an associated unit test.

Feb 15 2017, 11:04 AM · MW-1.30-release-notes (WMF-deploy-2017-05-23_(1.30.0-wmf.2)), Performance, MediaWiki-Authentication-and-authorization

Feb 9 2017

TK-999 created T157718: Skip User edit count computation in Autopromote if APCOND_EDITCOUNT isn't used.
Feb 9 2017, 7:34 PM · MW-1.30-release-notes (WMF-deploy-2017-05-23_(1.30.0-wmf.2)), Performance, MediaWiki-Authentication-and-authorization

Feb 7 2017

TK-999 updated the task description for T157508: Issuing an anon-only block, then changing anon-only setting causes incorrect block settings to be applied for anon user.
Feb 7 2017, 10:52 PM · MediaWiki-User-management
TK-999 added a comment to T157508: Issuing an anon-only block, then changing anon-only setting causes incorrect block settings to be applied for anon user.

It seems when software performs block check via User::isBlocked etc., Block::newLoad tries to find the best matching block based on type, and because of https://github.com/wikimedia/mediawiki/blob/master/includes/Block.php#L332 the first match of Block::TYPE_IP (the older block) will always be preferred for anons.

Feb 7 2017, 10:51 PM · MediaWiki-User-management
TK-999 updated the task description for T157508: Issuing an anon-only block, then changing anon-only setting causes incorrect block settings to be applied for anon user.
Feb 7 2017, 10:47 PM · MediaWiki-User-management
TK-999 updated the task description for T157508: Issuing an anon-only block, then changing anon-only setting causes incorrect block settings to be applied for anon user.
Feb 7 2017, 10:47 PM · MediaWiki-User-management
TK-999 created T157508: Issuing an anon-only block, then changing anon-only setting causes incorrect block settings to be applied for anon user.
Feb 7 2017, 10:46 PM · MediaWiki-User-management