[Clipart] cch graphics now in db

[Jon Phillips]

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.
On Mar 12, 2013 8:44 AM, "Jakub Jankiewicz" <jcubic at onet.pl> wrote:

> 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
> http://openclipart.org/detail/176267/cch-zeimusu-2f2ce1df-by-cch-176267
> look similar to the clipart of zeimusu
> http://openclipart.org/detail/3776/black-watch-by-zeimusu
>
> But not all users appear in database like Zerosurf
> http://openclipart.org/search/?query=Zerosurf
>
>
> On Tue, 12 Mar 2013 01:18:13 -0400
> Wolfgang Spraul <wolfgang at fabricatorz.com> 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.
> > http://openclipart.org/user-cliparts/cch
> >
> > 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
> > clipart at lists.freedesktop.org
> > http://lists.freedesktop.org/mailman/listinfo/clipart
>
> --
> Jakub Jankiewicz, Web Developer
> http://jcubic.pl
>
> _______________________________________________
> clipart mailing list
> clipart at lists.freedesktop.org
> http://lists.freedesktop.org/mailman/listinfo/clipart
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.freedesktop.org/archives/clipart/attachments/20130312/e4814896/attachment.html>