Update extensions for expiring user groups
Open, Stalled, LowPublic
Actions

Assigned To

None

Authored By

	TTO
	Feb 2 2017, 11:38 AM

Description

From MediaWiki 1.29, rows in the user_groups table may have an expiry date. When ug_expiry IS NOT NULL and strictly less than the current time, the row should be disregarded. This normally means adding a condition similar to

'ug_expiry IS NULL OR ug_expiry >= ' . $db->addQuotes( $db->timestamp() )

Some non-obsolete extensions query user_groups directly, and may need to be updated. See the subtasks of this task.

Details

	Subject	Repo	Branch	Lines +/-
	Update queries to account for expiring user groups	mediawiki/extensions/FlaggedRevs	master	+8 -2

Customize query in gerrit

Related Objects
Search...

Status	Assigned	Task
Stalled	None	T157015 Update extensions for expiring user groups
Resolved	TTO	T157016 Don't show expired local user groups in Special:CentralAuth
Resolved	TTO	T157017 Update Flow for expiring user groups
Resolved	TTO	T157018 Update SecurePoll for expiring user groups
Invalid	None	T160015 Update ArticleFeedbackv5 for expiring user groups
Resolved	Mainframe98	T160016 Update AutomaticBoardWelcome for expiring user groups
Open	None	T160017 Update BlueSpice extensions for expiring user groups
Declined	None	T160018 [CommunityTwitter] Update for expiring user groups
Resolved	ashley	T160019 Update ConfirmAccount for expiring user groups
Resolved	Func	T160020 Update ContributionScores for expiring user groups
Open	None	T160021 Update DeleteOwn for expiring user groups
Resolved	kaldari	T160022 [DisableAccount] Update for expiring user groups
Open	None	T160023 [GlobalUserGroups] Update for expiring user groups
Declined	None	T160024 [RevisionCommentSupplement] Update for expiring user groups
Resolved	TTO	T160026 Update Translate for expiring user groups
Resolved	Mainframe98	T160027 Update Video for expiring user groups

Event Timeline

TTO created this task.Feb 2 2017, 11:38 AM

Restricted Application added a subscriber: Aklapper. · View Herald TranscriptFeb 2 2017, 11:38 AM

TTO added a project: good first task.Feb 2 2017, 11:39 AM

Restricted Application added a subscriber: TerraCodes. · View Herald TranscriptFeb 2 2017, 11:39 AM

TTO created subtask T157016: Don't show expired local user groups in Special:CentralAuth.Feb 2 2017, 11:51 AM

TTO created subtask T157017: Update Flow for expiring user groups.Feb 2 2017, 11:54 AM

TTO created subtask T157018: Update SecurePoll for expiring user groups.

MarcoAurelio added a project: Stewards-and-global-tools (Temporary-UserRights).Feb 2 2017, 11:56 AM

I filed subtasks for the "important" ones.

I don't really know if it's worth the effort of filing subtasks for them all. Obviously those without Phabricator projects can't have subtasks filed; @Aklapper, what do you suggest for the others?

We have MediaWiki-extensions-Other for those, and being subtasks of this task will help keep them tracked IMHO.

BethNaught subscribed.Feb 2 2017, 1:32 PM

TTO closed subtask T157016: Don't show expired local user groups in Special:CentralAuth as Resolved.Feb 8 2017, 11:54 PM

TTO added a parent task: T159416: [Tracking] Enable user group expiry on Wikimedia wikis.Mar 2 2017, 9:28 AM

TTO mentioned this in T159416: [Tracking] Enable user group expiry on Wikimedia wikis.

Huji closed subtask T157018: Update SecurePoll for expiring user groups as Resolved.Mar 2 2017, 9:31 PM

TTO created subtask T160015: Update ArticleFeedbackv5 for expiring user groups.Mar 9 2017, 12:35 AM

TTO created subtask T160016: Update AutomaticBoardWelcome for expiring user groups.

TTO created subtask T160017: Update BlueSpice extensions for expiring user groups.Mar 9 2017, 12:38 AM

TTO created subtask T160018: [CommunityTwitter] Update for expiring user groups.

TTO created subtask T160019: Update ConfirmAccount for expiring user groups.Mar 9 2017, 12:40 AM

TTO created subtask T160020: Update ContributionScores for expiring user groups.