Subject: | uploads.db.bz2 - duplicate values in uploads.file |
As of this writing, the uploads table claims 113 files were uploaded
more than once.
Show quoted text
sqlite> select count(1) from (select author, filename, count(author +
filename) as c from uploads group by author, filename having c > 1) as whee;
113
...
In at least one case, a file has been inserted under two different
distributions: one with the proper distribution name, and another with a
".pm" suffix.
Show quoted textsqlite> select dist from uploads where author = 'ASCOPE' and filename =
'Net-ITE.pm-0.03.tar.gz';
Net-ITE.pm
Net-ITE