[Clipart] next historical question

[Oleg Koptev]

Very strange. I have about 100 cliparts, and seems that all are shown up in
OCAL.
How can the clipart be out of db but show on the ocal? is it hardlinks or
smth. else?

--
<http://vpopolam.ru/>
Freely listen and download our EP on http://vpopolam.ru/en/music
Слушай и бесплатно скачивай наш EP на http://vpopolam.ru/music


2013/3/12 Jakub Jankiewicz <jcubic at onet.pl>

> There was some issue with ArtFavor clipart and one of the authors
> requested to remove them all, so I remove them from database but they
> remain on disk. I don't know about the rest, but you need to know that
> delete clipart by use didn't remove the file from the disk once.
>
> Maybe rejon, pianoBrad and boobaloo will know about that since they are
> on your list, they all have librarian accounts.
>
> On Tue, 12 Mar 2013 05:23:31 -0400
> Wolfgang Spraul <wolfgang at fabricatorz.com> wrote:
>
> > OK I have continued some cleanup, roughly summing up:
> >
> > *) deleted about 500 .svg files that had pd_issue set in the
> > database, but were still present in the filesystem (and publicly
> > accessible). Also deleted about 4200 derivative .pngs of those
> > pd_issue graphics
> >
> > *) imported about 500 old cch graphics into the database, and
> > deleted about 1000 duplicates of those graphics (see earlier
> > mail)
> >
> > *) renamed about 200 files with .SVG (capitalized) extension
> > that didn't show up in the database. The database had a few
> > (13) .SVG graphics which I also renamed to .svg. Going forward,
> > I will try to disable .SVG (capitalized) or auto-lowercase for
> > new uploads.
> >
> > Now I am looking at 6308 .svg files that show up in the filesystem,
> > but not in the database. They belong to the following users:
> >
> >     962 ArtFavor
> >     785 Anonymous
> >     176 inky2010
> >      88 rejon
> >      84 gustavorezende
> >      80 pianoBrad
> >      73 Gerald_G
> >      69 brandynne
> >      68 slanteigne
> >      66 Merlin2525
> >      62 jiangyi_99
> >      57 cibo00
> >      54 gsagri04
> >      52 boobaloo
> >      51 10binary
> > plus another 856 users with less than 50 graphics, for a total of
> > 6308.
> >
> > Any idea what that might be? I think I will roughly do this:
> >
> > 1. make sure that all those users exist in the database, if not
> > create them.
> > 2. check some graphics manually to understand whether they are old
> > 'problem' uploads, spam, non-pd, duplicates, etc.
> > 3. import all those 6308 into the database same as I did for the 'cch'
> > user this morning.
> >
> > The problem with #3 is that unlike the cch import, this one will be
> > harder to reverse once I did it. In the cch case, it's all listed
> > under that specific user. But for these 6308 graphics, they are spread
> > out among hundreds of users. So once I import them, they will be
> > everywhere and if there are problems with those graphics, they would
> > need to be flagged pd_issue etc. and then deleted again.
> >
> > Feedback?
> > _______________________________________________
> > 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/74a42294/attachment.html>