Last modified: 2014-10-31 13:39:29 UTC
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: B ► 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) A ► 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)
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.