I parsed img_metadata in my GIF check report. I figured these errors would be fixed with newer software and an update script (T32961). Over the years more files appeared on the list. Currently, 3,211,696 files on Commons (8.89%) are missing metadata.
SELECT CONCAT(img_major_mime,"/",img_minor_mime) AS MIME, img_metadata,
CONCAT("File:", REPLACE(img_name,"_"," ")) AS Example, COUNT(*) AS COUNT
FROM image
WHERE LENGTH(img_metadata)<9 /*smallest is 9 bytes: {"x";i:0} */
GROUP BY 1, 2 ORDER BY COUNT(*) DESC;| MIME | img_metadata | Example | COUNT(*) |
|---|---|---|---|
| image/jpeg | 0 | File:"A Perspective View of Fort William" by Jan Van Ryne, 1754.jpg | 3,182,426 |
| image/jpeg | -1 | File:!-2013-wschowa-przyczyna-gorna-palac-abri.jpg | 16,140 |
| image/png | 0 | File:"Après le bain" (dessin par Georges A. Gardenty, 1893).png | 8,179 |
| audio/midi | Blank | File:"Bebop-rebop" early bop phrase.mid | 4,817 |
| image/gif | 0 | File:1. FCA Darmstadt.gif | 124 |
| application/pdf | b:0; | File:A imprensa em Goa nos séculos XVI, XVII e XVIII.pdf | 10 |
Update from 2022-02-03
| MIME | img_metadata | Example | COUNT |
|---|---|---|---|
| image/jpeg | 0 | File:"Batavians defeating Romans on the Rhine" by Otto van Veen.jpg | 3109304 |
| image/png | 0 | File:(แรงเสียดทาน).png | 68819 |
| image/jpeg | -1 | File:"Friends for ever" (carte postale de propagande franco-américaine, janvier 1917).jpg | 15941 |
| audio/midi | File:"Bebop-rebop" early bop phrase.mid | 4844 | |
| application/sla | File:(8567) 1996 HW1 3D model.stl | 2385 | |
| image/gif | 0 | File:1. FCA Darmstadt.gif | 697 |
| application/pdf | File:06.45 Management rep letter.pdf | 60 } | |