Fix broken category data caused by bug 69740 in production Wikimedia wikis
Open, MediumPublic
Actions

Assigned To

None

Authored By

	• bzimport
	Oct 29 2014, 7:13 AM

Description

Author: romaine.wiki

Description:
Category: https://commons.wikimedia.org/wiki/Category:Wikipedia_logo_variants_by_language

This category on Commons categorizes the categories starting with a B before the categories starting with an A. So far I can see no sort keys that cause this.

A copy of what I see:

► Belarusian Wikipedia logo variants‎ (empty)
► Basque Wikipedia logo variants‎ (1 C, 6 F)
► Bengali Wikipedia logo variants‎ (1 C, 4 F)
► Bulgarian Wikipedia logo variants‎ (44 F)

► Albanian Wikipedia logo variants‎ (1 F)
► Arabic Wikipedia logo variants‎ (17 F)
► Aragonese Wikipedia logo variants‎ (11 F)
► Armenian Wikipedia logo variants‎ (2 F)
► Asturian Wikipedia logo variants‎ (12 F)
► Avar Wikipedia logo variants‎ (4 F)

Version: wmf-deployment
Severity: normal

Details

Reference: bz72661

	Subject	Repo	Branch	Lines +/-
	Add script to fix incorrect cl_type values	mediawiki/core	master	+184 -0

Customize query in gerrit

Related Objects
Search...

		Status	Subtype	Assigned	Task
		Open		None	T74661 Fix broken category data caused by bug 69740 in production Wikimedia wikis
		Resolved		matmarex	T71740 Categories don't react well to their members moving between special-cased namespaces (Category ↔ File ↔ (other))

Event Timeline

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

• bzimport added a project: WMF-General-or-Unknown.

• bzimport set Reference to bz72661.

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

• bzimport created this task.Oct 29 2014, 7:13 AM

Appears to be related to that page move doesnt change cl_type bug. Although not sure how that equals observed behaviour. Will have to look at code later when not on cell phone.

For reference: https://commons.wikimedia.org/w/api.php?action=query&list=categorymembers&cmtitle=Category:Wikipedia_logo_variants_by_language&cmprop=title|sortkey|sortkeyprefix|type

Page was moved on 2014-06-09T23:24:29‎ which is prior to e0ff770adee0 which was done in september. Category was added on 2013-12-01T13:33:20Z, prior to the page move.

Thus its from before the cl_type bug was fixed.

Fixed by adding/removing cat to reset cl_type.

(In reply to Bawolff (Brian Wolff) from comment #1)

Appears to be related to that page move doesnt change cl_type bug. Although
not sure how that equals observed behaviour. Will have to look at code later
when not on cell phone.

I re-looked over CategoryViewer.php. Things were slightly different from how I remembered them, it all makes sense now.

Other categories that may be affected

MariaDB [commonswiki_p]> select page_title, cl_to from page inner join categorylinks on cl_from = page_id where page_namespace = 14 and cl_type != 'subcat' limit 100;
+----------------------------------------------------------------------------+-----------------------------------------------------------------------+

page_title

cl_to

+----------------------------------------------------------------------------+-----------------------------------------------------------------------+

BathyScaphe_(web_browser)	Web_browsers
Birthplaces_of_famous_people_in_the_Community_of_Madrid	Houses_of_famous_people_in_the_Community_of_Madrid
Café_le_Sébastopol_(Granges-sur-Lot)	Granges-sur-Lot
Cat_tongues_(chocolate)	Chocolate_confections
Cat_tongues_(chocolate)	Food_shaped_into_animal_tongues
Championsleague_Qualifikation_Play_off_FC_Salzburg_gegen_Malmö_FF	FC_Red_Bull_Salzburg_2014/15_matches
Coöperatieve_Stoomzuivelfabriek_Trynwâlden_(Gytsjerk)	Buildings_in_Gytsjerk
Coöperatieve_Stoomzuivelfabriek_Trynwâlden_(Gytsjerk)	Rijksmonumenten_in_Gytsjerk
Diego_Marani	1990_births
Diego_Marani	People_by_name
Diego_Marani	Sprinters_from_Italy
Dřevíč_Hill_Fort	Cultural_monuments_in_Kozojedy_(Rakovník_District)
Dřevíč_Hill_Fort	Dřevíč_(Kozojedy)
Dřevíč_Hill_Fort	Hill_forts_in_the_Czech_Republic
East_English_Village	Neighborhoods_in_Detroit,_Michigan
Evangelische_Kirche_(Lindenstruth)	Churches_in_Reiskirchen
FUDforum	Free_forum_software
Featured_pictures_by_Staselnik	Featured_pictures_by_creator
Featured_pictures_by_Staselnik	Images_by_Staselnik
Former_railways_lines_in_Liguria	Former_railway_lines_in_Italy
Grabmonument_FKJ_von_Erthal	Wall_mounted_church_monuments_of_Stiftskirche_St._Peter_und_Alexander
Grafkelder_(Burgum)	Rijksmonumenten_in_Burgum
Grafkelder_(Burgum)	Tombs_in_the_Netherlands
Haus_Café_Pape_(Lörrach)	Houses_in_Baden-Württemberg_built_in_1903
Heraldry_of_Medical_Brigades_of_the_United_States_Army	Medical_Brigades_of_the_United_States_Army
Heraldry_of_Medical_Brigades_of_the_United_States_Army	Medical_Heraldry_of_the_United_States_Army
Jazz_à_Juan_2014	2014_in_Alpes-Maritimes
Jazz_à_Juan_2014	Jazz_à_Juan
Jazz_à_Juan_2014	Music_in_2014
Kebnepakteglaciären	Glaciers_of_Sweden
La_Villotte_(Yonne)	Hamlets_in_Yonne
La_Villotte_(Yonne)	Villiers-Saint-Benoît
Laufbrunnen_(Wolfartsweier)	Cultural_heritage_monuments_in_Karlsruhe_with_known_ID
Laufbrunnen_(Wolfartsweier)	Cultural_heritage_monuments_in_Wolfartsweier_(Karlsruhe)
Laufbrunnen_(Wolfartsweier)	Water_wells_in_Baden-Württemberg
Laufbrunnen_(Wolfartsweier)	Wettersteinstraße_(Karlsruhe)
Löschwasserförderung_über_lange_Wegstrecken	Firefighting_in_Germany
Marcha_a_pié_desde_Oviedo_a_Covadonga_del_Centro_Asturiano_de_Oviedo_2014	Covadonga
Marcha_a_pié_desde_Oviedo_a_Covadonga_del_Centro_Asturiano_de_Oviedo_2014	Walking_events_in_Spain
Misty_Copeland	Ballet_dancers_from_the_United_States
Nastya_Stanko	People_of_Ivano-Frankivsk_Oblast
Naturschutzgebiet_Hunau_-_Langer_Rücken_-_Heidberg	Nature_reserves_in_Hochsauerlandkreis
Naturschutzgebiet_Hunau_-_Langer_Rücken_-_Heidberg	Schmallenberg
Noucentisme_architecture_in_Vallès_Oriental	Buildings_in_Vallès_Oriental
Noucentisme_architecture_in_Vallès_Oriental	Noucentisme_architecture
Pax	Buildings_in_Basel
Pax	Companies_in_Basel
Pax	Insurance_companies_of_Switzerland
People_with_flags_of_Singapore	People_with_flags_by_country
People_with_flags_of_Singapore	Photographs_of_flags_of_Singapore
Puits_d'Enfer	Château-d'Olonne
Pyramiden_Heliport	Airports_in_Svalbard
Pyramiden_Heliport	Pyramiden
Quality_images_of_Haagen	Haagen
Quality_images_of_Tumringen	Tumringen
Quinta_do_Marquês_(Torres_Novas)	Classified_monuments_in_Torres_Novas
Quinta_do_Marquês_(Torres_Novas)	Neo-Manueline_architecture
St._Michael_(Stockach)	Cultural_heritage_monuments_in_Stockach
Suchet's_room_in_Can_Papiol_Romanticism_Museum	Museu_Romàntic_Can_Papiol
The_Vampire_Diaries_Panel_at_the_2014_Comic-Con_International	2014_Comic-Con_International
Tomb_of_Almeida_Garrett_(Teixeira_Lopes)	Almeida_Garrett
Tomb_of_Almeida_Garrett_(Teixeira_Lopes)	Neo-Manueline_tombs
Tomb_of_Almeida_Garrett_(Teixeira_Lopes)	Sarcophagi_in_Portugal
Tomb_of_Almeida_Garrett_(Teixeira_Lopes)	Teixeira_Lopes
València_Basket-Barcelona_07-06-2014	2013-2014_ACB_season
València_Basket-Barcelona_07-06-2014	June_2014_in_the_Land_of_Valencia
València_Basket-Barcelona_07-06-2014	Valencia_Basket_Club_matches
Védère_postcard_set	1900s_postcards
WikiProject:_Lost_-_Logos	Logos_of_WikiProjects
WikiProject:_Lost_-_Logos	Lost_(television_programme)
WikiProject:_Lost_-_Logos	Wikipedia_logo_variants
Wiki_Loves_Earth_-_Alde_Feanen_-_9_June_2014	De_Alde_Feanen
Zittard	Disambiguation
Église_Saint-Memmie_de_Fleurigny	Thorigny-sur-Oreuse

+----------------------------------------------------------------------------+-----------------------------------------------------------------------+
74 rows in set (3 min 18.04 sec)

The underlying software bug has been fixed a while ago, so given the low number of affected pages this could be fixed on-wiki, for example by deleting and recreating the subcategories. That's what I did when this popped up as bug 69740.

(In reply to Bartosz Dziewoński from comment #3)

The underlying software bug has been fixed a while ago

So does that mean that this ticket should be moved to the Wikimedia product and that there is nothing left to do in the MediaWiki code?

I believe so, yes.

Change 252644 had a related patch set uploaded (by PleaseStand):
Add script to fix incorrect cl_type values

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

Restricted Application added a subscriber: Aklapper. · View Herald TranscriptNov 12 2015, 7:08 AM

gerritbot added a project: Patch-For-Review.Nov 12 2015, 7:08 AM

Is this still an issue, or have the pages been fixed by incremental editing since?

Fix broken category data caused by bug 69740 in production Wikimedia wikisOpen, MediumPublicActions