Populate sic_updated_timestamp for existing cases
Closed, ResolvedPublic
Actions

Assigned To

Authored By

	Dreamy_Jazz
	Tue, Jan 20, 12:00 PM

Description

Summary

We should provide a value for sic_updated_timestamp for existing rows in the cusi_case table

Background & Technical notes

Rows in cusi_case which have not been created or updated since T415054: Set a value for sic_updated_timestamp when creating or updating cases have no value for sic_updated_timestamp set
- We should make a maintenance script to populate this column which is run in update.php
  - This maintenance script should set sic_updated_timestamp as the value of sic_created_timestamp, but skip the row if sic_updated_timestamp already has a value

Acceptance criteria

sic_updated_timestamp has a value set for all rows in cusi_case

Details

Related Changes in Gerrit:

	Subject	Repo	Branch	Lines +/-
	SI: Populate sic_updated_timestamp for existing cusi_case rows	mediawiki/extensions/CheckUser	master	+310 -1

Customize query in gerrit

Related Objects
Search...

Status	Subtype	Assigned	Task
Open		Dreamy_Jazz	T412688 Suggested Investigations: Remove default from sic_updated_timestamp and drop indexes on sic_created_timestamp in cusi_case
Resolved		hector.arroyo	T411788 Suggested investigations: Replace 'Created' timestamp column with 'Updated' timestamp column in table pager
Resolved		Dreamy_Jazz	T415055 Populate sic_updated_timestamp for existing cases
Resolved		Dreamy_Jazz	T415054 Set a value for sic_updated_timestamp when creating or updating cases
Resolved	BUG REPORT	Dreamy_Jazz	T415348 CheckUser update.php fails to run for SQLite and PostgreSQL

Event Timeline

Dreamy_Jazz created this task.Tue, Jan 20, 12:00 PM

Dreamy_Jazz added a subtask: T415054: Set a value for sic_updated_timestamp when creating or updating cases.

Dreamy_Jazz closed subtask T415054: Set a value for sic_updated_timestamp when creating or updating cases as Resolved.Wed, Jan 21, 11:26 AM

Dreamy_Jazz moved this task from Backlog to Ready on the CheckUser-SuggestedInvestigations board.Wed, Jan 21, 1:26 PM

Change #1230896 had a related patch set uploaded (by Dreamy Jazz; author: Dreamy Jazz):

[mediawiki/extensions/CheckUser@master] SI: Populate sic_updated_timestamp for existing cusi_case rows

https://gerrit.wikimedia.org/r/1230896

gerritbot added a project: Patch-For-Review.Fri, Jan 23, 10:39 AM

Dreamy_Jazz edited projects, added Product Safety and Integrity (Sprint Daffodil (Jan 19 - Feb 6)); removed Product Safety and Integrity.Fri, Jan 23, 10:40 AM

Dreamy_Jazz moved this task from Ready to In Progress on the CheckUser-SuggestedInvestigations board.

Dreamy_Jazz moved this task from Backlog to In progress on the Product Safety and Integrity (Sprint Daffodil (Jan 19 - Feb 6)) board.

Dreamy_Jazz claimed this task.Fri, Jan 23, 12:22 PM

Dreamy_Jazz moved this task from In progress to Needs review on the Product Safety and Integrity (Sprint Daffodil (Jan 19 - Feb 6)) board.

Dreamy_Jazz added a subtask: T415348: CheckUser update.php fails to run for SQLite and PostgreSQL.Fri, Jan 23, 1:03 PM

Change #1230896 merged by jenkins-bot:

[mediawiki/extensions/CheckUser@master] SI: Populate sic_updated_timestamp for existing cusi_case rows

https://gerrit.wikimedia.org/r/1230896

Maintenance_bot removed a project: Patch-For-Review.Fri, Jan 23, 4:32 PM

Dreamy_Jazz closed subtask T415348: CheckUser update.php fails to run for SQLite and PostgreSQL as Resolved.Sat, Jan 24, 9:47 PM

Dreamy_Jazz moved this task from Needs review to In progress on the Product Safety and Integrity (Sprint Daffodil (Jan 19 - Feb 6)) board.

Mentioned in SAL (#wikimedia-operations) [2026-01-29T21:56:48Z] <Dreamy_Jazz> Ran foreachwikiindblist checkuser-suggested-investigations.dblist extensions/CheckUser/maintenance/populateSicUpdatedTimestamp.php for T415055

Verified this worked on enwiki:

> select count(*) from cusi_case where sic_updated_timestamp NOT LIKE '202%';
+----------+
| count(*) |
+----------+
|        0 |
+----------+

Dreamy_Jazz closed this task as Resolved.Thu, Jan 29, 9:59 PM

Dreamy_Jazz moved this task from In progress to Done on the Product Safety and Integrity (Sprint Daffodil (Jan 19 - Feb 6)) board.

hector.arroyo moved this task from In Progress to Done on the CheckUser-SuggestedInvestigations board.Mon, Feb 2, 5:27 PM

Populate sic_updated_timestamp for existing casesClosed, ResolvedPublicActions