<div dir="ltr"><div>Very strange. I have about 100 cliparts, and seems that all are shown up in OCAL. </div>How can the clipart be out of db but show on the ocal? is it hardlinks or smth. else? <div><div class="gmail_extra"> <div><div style="text-align:left">-- <a href="http://vpopolam.ru/" target="_blank"><img src="https://dl.dropbox.com/u/939165/boobaloo_funky_sticker.png"></a> Freely listen and download our EP on <a href="http://vpopolam.ru/en/music" target="_blank">http://vpopolam.ru/en/music</a> Слушай и бесплатно скачивай наш EP на <a href="http://vpopolam.ru/music" target="_blank">http://vpopolam.ru/music</a></div></div> <div class="gmail_quote">2013/3/12 Jakub Jankiewicz <<a href="mailto:jcubic@onet.pl" target="_blank">jcubic@onet.pl</a>> <blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"> 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. <div><div class="h5"> On Tue, 12 Mar 2013 05:23:31 -0400 Wolfgang Spraul <<a href="mailto:wolfgang@fabricatorz.com">wolfgang@fabricatorz.com</a>> 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 > <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> </div></div>-- 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> </div></div></div>