Ruzbeh, Assuming the table names haven't changed from 1.4.x and there is no bitstream management in 1.5.x, you could probably do something like:
update bitstream set deleted=true where name like '%.pdf.jpg'; and then run $DSPACE/bin/cleanup to get rid of the thumb files in the assetstore You might also need to also do: delete from bundle2bitstream where bitstream_id in (select bitstream_id from bitstream where name like '%.pdf.jpg'); as I'm not sure whether the cleanup job will do this or whether this is done when a bitstream is manually deleted. Alternatively you could just write a quick java program to delete these using the API which could be safer than relying on my memory! Scott. > ---------------------------------------------------------------------- > > Message: 1 > Date: Sun, 5 Apr 2009 15:51:25 -0700 (PDT) > From: Ruzbeh <ruzbe...@yahoo.com> > Subject: [Dspace-tech] PDF Thumbnails, installed, but caused a lot of > trouble! > To: DSpace-tech@lists.sourceforge.net > Message-ID: <409153.6872...@web38808.mail.mud.yahoo.com> > Content-Type: text/plain; charset="us-ascii" > > Hi everybody > > I installed the mediafilter available > athttp://sts.anu.edu.au/drs/downloads/index.php on 1.5.0. > But during the bin/filter-media operations, handling a few items threw > exceptions. > The exception was caused because ImageMagick Could not convert some pdfs with > special sets of fonts into jpeg! It seemed non-vital at > first, but now, when I enable the browse list to show thumbnails, the jsp > page throws an IOException > with "Format Not Supported" message, while performing the method of > InputStream.read() > which causes a jspexception and that causes > and the page remains only half-rendered. > > 1) I would appreciate it if somebody helped me with this issue. I tried to > manually, force the filter-media > to handle those bad handled items, but I didn't succeed! And then I tried to > pin down every bad handled item with > filter-media, in which I failed too! > 2)I tried to manually delete those bitstreams generated by the > filtermedia, but there are at least 400 pdf items in my database!!! Any help > or suggestion regarding > the removal of some bitstreams from items? any procedure who checks all the > bitstreams could > prove handy, because all the newly generated bitstreams end up in ".pdf.jpg". > > > > Roozbeh Ebrahimi, > BSc of pure Mathematics at > Sharif University of Tech. > > ------------------------------------------------------------------------------ This SF.net email is sponsored by: High Quality Requirements in a Collaborative Environment. Download a free trial of Rational Requirements Composer Now! http://p.sf.net/sfu/www-ibm-com _______________________________________________ DSpace-tech mailing list DSpace-tech@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/dspace-tech
