https://bugzilla.wikimedia.org/show_bug.cgi?id=41832
Bawolff (Brian Wolff) <[email protected]> changed: What |Removed |Added ---------------------------------------------------------------------------- CC| |[email protected] --- Comment #12 from Bawolff (Brian Wolff) <[email protected]> --- Looks almost like some sort of referential integrity issue. [I say this without being very familiar with flagged revs]. https://pl.wikipedia.org/wiki/Jeziora_Afryki?stable=1 (As being viewed today) is revision 33110538 (17:52, 13 October 2012) and was auto-sighted at the same time (17:52, 13 October 2012). Some (not all) of its images are missing, being displayed as if the file did not exist (aka, the part immediately after the | is being displayed as the link text, as if the link was not a file link but a normal link). Additionally one image have a thumb to an incorrect url (for example: https://upload.wikimedia.org/wikipedia/commons/thumb/archive/4/49//22px-Flag_of_Kenya.svg.png which is missing the part in the middle. This appears unrelated to flagged revisions. Flagged revisions has simply stablilized this image to a missing image. Note the missing entry at [[commons:Flag_of_Kenya.svg]] for 06:19, 21 November 2009. This should probably be investigated separately. To pick an example, [[File:Flag of Algeria.svg]] is one of these images not being displayed and just has a "normal" link with just the parameter after the pipe. If we look at the database, specifically the flaggedimages table, we see the corresponding row: mysql> select * from flaggedimages where fi_rev_id = '33110538' and fi_name='Flag_of_Algeria.svg'; +-----------+---------------------+------------------+---------------------------------+ | fi_rev_id | fi_name | fi_img_timestamp | fi_img_sha1 | +-----------+---------------------+------------------+---------------------------------+ | 33110538 | Flag_of_Algeria.svg | 20100812000321 | healu33sru52htiec9mxn90y26mh5r9 | +-----------+---------------------+------------------+---------------------------------+ However Flag_of_Algeria.svg (at commons) with timestamp 20100812000321 has sha1 of 4zxh8rze9pa662xcx6qvnjshy6w4nq6. The healu33sru52htiec9mxn90y26mh5r9 sha1 corresponds to an image with timestamp 20120317155611. Since the timestamp and sha1 are out of sync, it appears no image is used. However, The page was (auto)-sighted in october, so one would expect that neither would be the version used, and instead the most recent version of the image, from 20120317171026 (sha1: nuyez3fxwzypk3rno0pbprxfcr06kl0) would be used. (Note: if you disregard auto-sight, the last manual sight was in december 2011 which would correspond to the 20100812000321 (4zxh8...) image). Last of all, some images are displayed properly, but seem inappropriately stabilized to the wrong version. for [[commons:file:Flag_of_the_Democratic_Republic_of_the_Congo.svg]], the version used is 20090110091808. However, we would expect the version from 2012-06-30T03:12:56 to be used (unless auto-sights are discounted and only manual sights update which image is used). -- You are receiving this mail because: You are watching all bug changes. _______________________________________________ Wikibugs-l mailing list [email protected] https://lists.wikimedia.org/mailman/listinfo/wikibugs-l
