I parsed `img_metadata` in my [[https://commons.wikimedia.org/wiki/User:Dispenser/GIF_check|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_name, major_mime,"/",img_metadata, img_timestampinor_mime) AS MIME, img_usermetadata,
CONCAT(img_major_mi"File:", REPLACE(img_name,"/",img_minor_mime_"," ")) AS Example, COUNT(*) AS MIMECOUNT
FROM image
WHERE LENGTH(img_metadata)<9; /*smallest is 9 bytes: {"x";i:0} */
GROUP BY 1, /*smallest is 9 bytes: {"x":i:0} */2 ORDER BY COUNT(*) DESC;
```
3,211,717 files on commons
T32961| 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 |