No way to back-fill log_search with protection information (causing missing data in Special:ProtectedPages)
Open, LowPublicFeature
Actions

Assigned To

None

Authored By

	TTO
	Jun 18 2014, 11:59 AM

Description

The log_search table began to be populated with protection-related information in Gerrit change 105443. Older protection events (prior to deploy of 1.23wmf15) lack the required log_search records, meaning Special:ProtectedPages is full of "unknown" timestamps etc. on big wikis like enwiki.

It should be possible to write a maintenance script to back-populate log_search with the relevant protection data. Requires matching up log entries with records in page_restrictions.

Version: 1.24rc
Severity: enhancement

Details

Reference: bz66777

Related Objects
Search...

		Status	Subtype	Assigned	Task
		Resolved		None	T11361 Add date and time of protection event to Special:Protectedpages
		Open	Feature	None	T68777 No way to back-fill log_search with protection information (causing missing data in Special:ProtectedPages)

Event Timeline

• bzimport raised the priority of this task from to Low.Nov 22 2014, 3:21 AM

• bzimport added a project: MediaWiki-Special-pages.

• bzimport set Reference to bz66777.

• bzimport added a subscriber: Unknown Object (MLST).

TTO created this task.Jun 18 2014, 11:59 AM

Look at the last page to have it all filled ;-)

https://en.wikipedia.org/w/index.php?title=Special:ProtectedPages&dir=prev

I am not sure, if it is possible to always find the correct or related log entry. Page moves and reprotection can cause a problem here.

On dewiki we also have protected pages without a log entry (see bug 24511), because the logging system does not exists at that point. So you would still have unknown rows on enwiki.

Umherirrender merged a task: T85437: Some items are 'unknown' on the Special:ProtectedPages.Dec 29 2014, 9:18 AM

Umherirrender added subscribers: Aklapper, Cwek, Liuxinyu970226.

Umherirrender merged a task: T78740: Special:ProtectedPages is missing all log information.Dec 29 2014, 9:36 AM

Umherirrender added subscribers: Jasper, Legoktm, greg.

Umherirrender added a project: MediaWiki-Maintenance-system.Jan 18 2015, 8:00 PM

Liuxinyu970226 unsubscribed.Jan 18 2015, 11:54 PM

Umherirrender unsubscribed.Feb 24 2015, 7:29 PM

• Reguyla moved this task from To triage to Maintenance reports on the MediaWiki-Special-pages board.May 26 2015, 2:23 AM

Umherirrender mentioned this in T144791: Special:ProtectedPages does not list "Timestamp" and "Protecting user".Sep 10 2016, 8:41 PM

Umherirrender merged a task: T144791: Special:ProtectedPages does not list "Timestamp" and "Protecting user".

Umherirrender added subscribers: GoEThe, Umherirrender, Darwinius.

Umherirrender unsubscribed.Jan 1 2018, 2:48 PM