Thanks for this, Terry. That is exactly what I am doing. I sign on to the web ui, in our case jspui, and try to delete the community. I get an error message in the browser that there was a system error, and if it continues, I should contact the administrator. When I look in the dspace log, I can see the exception about the foreign key constraint, etc.
I should say, I deleted a few communities just before I tried this one, and they went away quietly, without error messages. Then this community threw this error, and any other community deletions that I try now throw the same error. I can see the entry for this community in the community2community table as the child of the top level community. Best regards, Paul On Wed, Nov 22, 2017 at 4:51 PM, Terry Brady <[email protected]> wrote: > This does not directly answer your question, but it might be helpful. > > I sign into the UI as a repository administrator when I want to delete > communities, collections, and items. The code handles all of the > dependencies when deleting. > > On Wed, Nov 22, 2017 at 6:19 AM, Paul Warner <[email protected]> > wrote: > >> Hi all, >> >> I am running DSpace 6.1 on Suse. >> >> I have tried to delete a community I just created, since I found a >> different way to solve my organization problem. I got an error that the >> update or delete in the table 'community' violates foreignkey-constraint >> 'community2community_child_comm_id_fkey' from the table >> 'community2community'. >> >> I have seen some posts from earlier versions of dspace saying that these >> constraints and even the tables themselves are no longer needed. Should I >> be seeing this error then with DSpace 6.1? I will alter or delete the >> tables if that is what I should do - but I just want to make sure that is >> still the right thing to do. I presume it is irreversible, and I don't >> want to damage my installation. >> >> Thanks! >> >> Best regards, >> Paul >> >> -- >> 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 [email protected]. >> To post to this group, send email to [email protected]. >> Visit this group at https://groups.google.com/group/dspace-tech. >> For more options, visit https://groups.google.com/d/optout. >> > > > > -- > Terry Brady > Applications Programmer Analyst > Georgetown University Library Information Technology > https://github.com/terrywbrady/info > 425-298-5498 <(425)%20298-5498> (Seattle, WA) > > -- > You received this message because you are subscribed to a topic in the > Google Groups "DSpace Technical Support" group. > To unsubscribe from this topic, visit https://groups.google.com/d/ > topic/dspace-tech/Ihb0hInEqFU/unsubscribe. > To unsubscribe from this group and all its topics, send an email to > [email protected]. > To post to this group, send email to [email protected]. > Visit this group at https://groups.google.com/group/dspace-tech. > For more options, visit https://groups.google.com/d/optout. > -- 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 [email protected]. To post to this group, send email to [email protected]. Visit this group at https://groups.google.com/group/dspace-tech. For more options, visit https://groups.google.com/d/optout.
