Thank you for the info so far: The problem with getting technical info from a user :-(
OK. The user did not delete the individual items, he actually deleted the COMMUNITY. I dont see the data for the record in the community table. Are we SOL? Again, thank you all for the suggestions and the user GREATLY appreciates the efforts to saving his fanny... Jeff Pearson USC Libraries Peter Dietz wrote: > I would look in the database table "item". It has a field called > "item"."in_archive". Typically when an item gets deleted it sets > item.in_archive to FALSE > > So from the DB, you could look for all of the "deleted" items. So use > your favorite SQL query tool (perhaps pgAdmin3 if your DB is postgres) > SELECT * FROM item where item.in_archive = false; > > > Or get all the metadata for the deleted items. > SELECT > item.item_id, > item.in_archive, > metadatafieldregistry.element, > metadatafieldregistry.qualifier, > metadatavalue.text_value, > item.last_modified > FROM > public.item, > public.metadatavalue, > public.metadatafieldregistry > WHERE > item.item_id = metadatavalue.item_id AND > metadatavalue.metadata_field_id = > metadatafieldregistry.metadata_field_id AND > item.in_archive = FALSE > ORDER BY last_modified DESC; > > However, I think deletions to communities and collections make them go > away, the items may remain behind as an artifact. > > > Peter Dietz > Systems Developer/Engineer > Ohio State University Libraries > > > > On Fri, May 28, 2010 at 2:35 PM, Sands Alden Fish <[email protected] > <mailto:[email protected]>> wrote: > > Others should provide some clarification on this, but typically > deletions are not "hard deletes" but soft, in that there is a > deletion flag that a cleanup process operates on occasionally. > Perhaps the database still contains the items, and you can revert > the deletion by modifying the correct tables? > > Sorry that this isn't more detailed. I've never had to dig around > in that logic before. > > -- > sands fish > Software Engineer > MIT Libraries > Technology Research & Development > [email protected] <mailto:[email protected]> > E25-131 > > > > > On May 28, 2010, at 2:30 PM, Jeffrey W. Pearson wrote: > >> Quick question: >> >> We had a user delete things he should not have. We have been able to >> restore the filesystem stuff from backups. Unfortunately, the >> database >> backups have been lost. All we really need is the content files. Is >> there a way to rebuild the content files from just using what is >> on the >> file system? >> >> Any help would be GREATLY appreciated, especially by the user who >> deleted the data.... >> >> >> >> Jeff Pearson >> USC Libraries >> >> >> ------------------------------------------------------------------------------ >> >> _______________________________________________ >> Dspace-devel mailing list >> [email protected] >> <mailto:[email protected]> >> https://lists.sourceforge.net/lists/listinfo/dspace-devel > > > > ------------------------------------------------------------------------------ > > > _______________________________________________ > Dspace-devel mailing list > [email protected] > <mailto:[email protected]> > https://lists.sourceforge.net/lists/listinfo/dspace-devel > > ------------------------------------------------------------------------------ _______________________________________________ Dspace-devel mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/dspace-devel
