List of steps to reproduce (step by step, including full links if applicable):
What happens?:
It lists all existing main space pages regardless of the fact that it isn't TimedText.
What should have happened instead?:
It should list only TimedText pages which are also orphaned.
Software version (if not a Wikimedia wiki), browser information, screenshots, other information, etc:
The query it's supposed to be running is...
SELECT page_namespace AS `namespace`,page_title AS `title`,0 AS `value` FROM `page` LEFT OUTER JOIN `image` ON ((substr( page_title, 1, length( page_title ) - length( substring_index( page_title, '.' ,-2 ) ) - 1 ) = img_name)) WHERE img_name IS NULL AND page_namespace = 710 ORDER BY namespace,title LIMIT 51
And the results from the DB on enwiki look good
+-----------+---------------------------------------------------------------------------+-------+ | namespace | title | value | +-----------+---------------------------------------------------------------------------+-------+ | 710 | 01_Locked_Out_of_Heaven.ogg.en.srt | 0 | | 710 | 02_Can't_Hold_Us_Down.ogg.en.srt | 0 | | 710 | 03_Pink_Try.ogg.en.srt | 0 | | 710 | 1985_Cole.ogg.en.srt | 0 | | 710 | 1993_Larry_King_Live_call_from_San_Luis_Obispo.ogg.en.srt | 0 | | 710 | All_The_Stars.ogg.en.srt | 0 | | 710 | All_out_of_love_(Air_Supply_song_-_sample).ogg | 0 | | 710 | And_heart_breaks_-_sample.ogg.en.srt | 0 | | 710 | Anywhere.ogg.en.srt | 0 | | 710 | BlackFlagNervousBreakdown.ogg.en.srt | 0 | | 710 | BlindFoldMeKelis.ogg | 0 | | 710 | BlondieHeartOfGlass.ogg.en.srt | 0 | | 710 | Borderline.ogg.en.srt | 0 | | 710 | Breathe_-_In_All_Honesty.ogg.en.srt | 0 | | 710 | Car_Radio.ogg.en.srt | 0 | | 710 | Carl_Douglas_-_Kung_Fu_Fighting.ogg.en.srt | 0 | | 710 | David_Bowie_-_Space_Oddity.ogg.en.srt | 0 | | 710 | DejaVuSample.ogg.en.srt | 0 | | 710 | Eminem_-_Berzerk.ogg.en.srt | 0 | | 710 | Eminem_Bad_Guy_sample.ogg.en.srt | 0 | | 710 | Example | 0 | | 710 | Example.ogg | 0 | | 710 | Fakin_It_S+G.ogg | 0 | | 710 | Fighter_sample.ogg.en.srt | 0 | | 710 | File:Sabotage_by_the_Beastie_Boys.ogg | 0 | | 710 | Gorillaz_-_Feel_Good_Inc.ogg.en.srt | 0 | | 710 | Halo.ogg.en.srt | 0 | | 710 | Hands_All_Over.ogg.en.srt | 0 | | 710 | Hate_Me.ogg.en.srt | 0 | | 710 | Heavydirtysoul.ogg.en.srt | 0 | | 710 | Heil_dir_im_Siegerkranz.ogg.de.srt | 0 | | 710 | Hey_Ya!.ogg.en.srt | 0 | | 710 | Highest_in_the_Room.ogg.en.srt | 0 | | 710 | House_of_Gold.ogg.en.srt | 0 | | 710 | Hunter.ogg.en.srt | 0 | | 710 | Hunter_(Björk_song_-_audio_sample).ogg | 0 | | 710 | I_Wonder.ogg.en.srt | 0 | | 710 | IfYou'dOnlyBelieve.ogg.en.srt | 0 | | 710 | If_You'dOnlyBelieve.ogg.en.srt | 0 | | 710 | Ill_Mind_of_Hopsin_5_audiosample.ogg.en.srt | 0 | | 710 | Ironic.ogg.en.srt | 0 | | 710 | It's_The_End_Of_The_World_As_We_Know_It.ogg.en.srt | 0 | | 710 | Jay_Torres_Interview_on_Telemedillín's_Vitrina_Trendy_program.ogg.en.srt | 0 | | 710 | Jay_Torres_Interview_on_Telemedillín's_Vitrina_Trendy_program.ogg.es.srt | 0 | | 710 | Jealousy,_Jealousy_by_Olivia_Rodrigo_(music_sample).ogg.en.srt | 0 | | 710 | Jjiniya.mp3.en.srt | 0 | | 710 | Kanye_West_The_Storm.ogg.en.srt | 0 | | 710 | Karnivool_-_New_Day.ogg | 0 | | 710 | Kongesangen.ogg.en.srt | 0 | | 710 | Kongesangen.ogg.nb.srt | 0 | | 710 | Legends.ogg.en.srt | 0 | +-----------+---------------------------------------------------------------------------+-------+ 51 rows in set (0.039 sec)
https://en.wikipedia.org/wiki/Special:OrphanedTimedText not so much
Something weird going on with the caching?
Nevermind, I read the page wrong, this is still happening but with all TimedText pages instead of all main space pages.
What I am seeing is actually TimedText files that are redirects or mismatched file extensions. Testing locally, it actually seems this bug was the same as T287152 and the fix there has also solved this behavior.