Maniphest T419355

SelectCategory extension needs cl_to migrated to linktarget
Closed, ResolvedPublic
Actions

Assigned To

Authored By

	Pppery
	Mar 8 2026, 8:37 PM

Project Tags

Referenced Files

None

Subscribers

Aklapper

Pppery

Description

			# Automagically detect root categories
			$sql = "SELECT tmpSelectCat1.cl_to AS title
FROM $tblCatLink AS tmpSelectCat1
LEFT JOIN $tblPage AS tmpSelectCatPage ON (tmpSelectCat1.cl_to = tmpSelectCatPage.page_title AND tmpSelectCatPage.page_namespace = 14)
LEFT JOIN $tblCatLink AS tmpSelectCat2 ON tmpSelectCatPage.page_id = tmpSelectCat2.cl_from
WHERE tmpSelectCat2.cl_from IS NULL GROUP BY tmpSelectCat1.cl_to";

https://www.mediawiki.org/wiki/Manual:Categorylinks_table#Removed_fields

Details

Related Changes in Gerrit:

	Subject	Author	Repo	Branch	Lines +/-
	Support newer versions of MediaWiki where categorylinks.cl_to is no longer a thing and you must use the linktarget table instead	Jack Phoenix	mediawiki/extensions/SelectCategory	master	+70 -22

Customize query in gerrit

Event Timeline

Pppery created this task.Mar 8 2026, 8:37 PM

Restricted Application added a subscriber: Aklapper. · View Herald TranscriptMar 8 2026, 8:37 PM

Change #1340609 had a related patch set uploaded (by Jack Phoenix; author: Jack Phoenix):

[mediawiki/extensions/SelectCategory@master] Support newer versions of MediaWiki where categorylinks.cl_to is no longer a thing and you must use the linktarget table instead

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

gerritbot added a project: Patch-For-Review.Sep 13 2026, 4:55 PM

Change #1340609 merged by jenkins-bot:

[mediawiki/extensions/SelectCategory@master] Support newer versions of MediaWiki where categorylinks.cl_to is no longer a thing and you must use the linktarget table instead

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

Maintenance_bot removed a project: Patch-For-Review.Sat, Oct 3, 11:30 PM

ashley closed this task as Resolved.Sat, Oct 3, 11:33 PM

ashley claimed this task.

SelectCategory extension needs cl_to migrated to linktargetClosed, ResolvedPublicActions

Description

Details

Event Timeline

SelectCategory extension needs cl_to migrated to linktarget
Closed, ResolvedPublic
Actions