Re: [dspace-tech] can't delete empty (but once full) community

[Andrea Schweer]

Hi, On 11/11/15 08:58, cem.uwater...@gmail.com wrote: We remapped every item in a collection to other collections.  When viewing the collection no items showed.  We deleted the collection.  That collection and its items were the only contents of a community.  The community does not display any items and searching and browsing produces no hits.  Yet an error arises when attempting to delete the community. ERROR: update or delete on table "community" violates foreign key constraint "communities2item_community_id_fkey" on table "communities2item" Detail: Key (community_id)=(6) is still referenced from table "communities2item". This is a known bug, currently scheduled for DSpace 6.0: https://jira.duraspace.org/browse/DS-2578 -- basically, that table is a leftover from pre-Discovery times. It's safe to delete everything from the communities2item table, see the Jira ticket for some more detail. cheers, Andrea -- Dr Andrea Schweer IRR Technical Specialist, ITS Information Systems The University of Waikato, Hamilton, New Zealand +64-7-837 9120 -- You received this message because you are subscribed to the Google Groups "DSpace Technical Support" group. To unsubscribe from this group and stop receiving emails from it, send an email to dspace-tech+unsubscr...@googlegroups.com. To post to this group, send email to dspace-tech@googlegroups.com. Visit this group at http://groups.google.com/group/dspace-tech. For more options, visit https://groups.google.com/d/optout.