Its good that Wolfgang is cleaning up because there have definitely been leaks in the pipes over the years and I remember a huge stack of failed uploads that never made it into our system. Good work. <div class="gmail_quote">On Mar 12, 2013 8:44 AM, "Jakub Jankiewicz" <<a href="mailto:jcubic@onet.pl">jcubic@onet.pl</a>> wrote: <blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"> I think that those that are not in database should be remove from the server, because before I added remove file on delete clipart by user the files was not removed, so they stay. As for cch files it look like the names of the users are in the tiles like this <a href="http://openclipart.org/detail/176267/cch-zeimusu-2f2ce1df-by-cch-176267" target="_blank">http://openclipart.org/detail/176267/cch-zeimusu-2f2ce1df-by-cch-176267</a> look similar to the clipart of zeimusu <a href="http://openclipart.org/detail/3776/black-watch-by-zeimusu" target="_blank">http://openclipart.org/detail/3776/black-watch-by-zeimusu</a> But not all users appear in database like Zerosurf <a href="http://openclipart.org/search/?query=Zerosurf" target="_blank">http://openclipart.org/search/?query=Zerosurf</a> On Tue, 12 Mar 2013 01:18:13 -0400 Wolfgang Spraul <<a href="mailto:wolfgang@fabricatorz.com">wolfgang@fabricatorz.com</a>> wrote: > I did a little cch db cleanup this morning. > There were 1499 .svg files named cch_ on the server that had > no representation in the aiki database. > 915 of those turned out to be md5sum duplicates of the others > so I deleted them (I understand this breaks some links to the > outside world, but there is so much junk on the server I need > to favor speed a little). I did not check the server logs > to see how often the deleted files were accessed lately. > > That left 584 md5sum-unique cch_ svg files which I re-added > to the aiki database under the 'cch' user. > <a href="http://openclipart.org/user-cliparts/cch" target="_blank">http://openclipart.org/user-cliparts/cch</a> > > I apologize in case this feels like some dirt being stirred > up, but the files were on the server regardless and now they > are just more visible again. > I understand we have 19 pages of cliparts with clipart_issue > set and 100+ pages without tags. Now there may be even more > cleanup work but I just start somewhere. > > A quick look over the first few pages of those 584 graphics > makes me believe some have some value and it's good that they > are more visible again. > > There are now a total of 47761 svg files on the server. I think > there are at least another 6000 in people folders that have no > aiki entries at all, I will look at those next. > _______________________________________________ > clipart mailing list > <a href="mailto:clipart@lists.freedesktop.org">clipart@lists.freedesktop.org</a> > <a href="http://lists.freedesktop.org/mailman/listinfo/clipart" target="_blank">http://lists.freedesktop.org/mailman/listinfo/clipart</a> -- Jakub Jankiewicz, Web Developer <a href="http://jcubic.pl" target="_blank">http://jcubic.pl</a> _______________________________________________ clipart mailing list <a href="mailto:clipart@lists.freedesktop.org">clipart@lists.freedesktop.org</a> <a href="http://lists.freedesktop.org/mailman/listinfo/clipart" target="_blank">http://lists.freedesktop.org/mailman/listinfo/clipart</a> </blockquote></div>