Page MenuHomePhabricator

Normalise centralauth.gu_hidden
Open, Needs TriagePublic

Description

-- If true, this account should be hidden from most public user lists.
-- Used for "deleting" accounts without breaking referential integrity.
gu_hidden varbinary(255) not null default '',

The column is often '', but also includes values like lists and suppressed.

Also, it doesn't seem to be ever true, at least beyond not being '' (which I guess PHP would evaluate to being true ;))

Event Timeline

Those values match the CentralAuthUser::HIDDEN_* constants. Not sure what you propose to do here?

They can be turned into integer. That would reduce its size quite a bit.

Change 743661 had a related patch set uploaded (by Majavah; author: Majavah):

[mediawiki/extensions/CentralAuth@master] Normalize gu_hidden

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

Change 743661 merged by jenkins-bot:

[mediawiki/extensions/CentralAuth@master] Normalize gu_hidden

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

Change 743923 had a related patch set uploaded (by Majavah; author: Majavah):

[operations/mediawiki-config@master] beta: WRITE_BOTH for centralauth hidden level migration

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

Change 743923 merged by jenkins-bot:

[operations/mediawiki-config@master] beta: WRITE_BOTH for centralauth hidden level migration

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

Change 751077 had a related patch set uploaded (by Majavah; author: Majavah):

[mediawiki/extensions/CentralAuth@master] Operate internally on normalized hidden values

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

Change 751385 had a related patch set uploaded (by Majavah; author: Majavah):

[operations/mediawiki-config@master] prod: WRITE_BOTH for centralauth hidden level migration

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

Change 751385 merged by jenkins-bot:

[operations/mediawiki-config@master] prod: WRITE_BOTH for centralauth hidden level migration

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

Mentioned in SAL (#wikimedia-operations) [2022-01-04T12:52:39Z] <taavi@deploy1002> Synchronized wmf-config/InitialiseSettings.php: Config: [[gerrit:751385|prod: WRITE_BOTH for centralauth hidden level migration (T289068)]] (duration: 00m 57s)

Mentioned in SAL (#wikimedia-operations) [2022-01-11T06:21:30Z] <taavi> starting extensions/CentralAuth/maintenance/migrateHiddenLevel.php on a mwmaint1002 screen session - T289068

Mentioned in SAL (#wikimedia-operations) [2022-01-11T07:12:33Z] <taavi> extensions/CentralAuth/maintenance/migrateHiddenLevel.php finished - T289068

Change 751077 merged by jenkins-bot:

[mediawiki/extensions/CentralAuth@master] Operate internally on normalized hidden values

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