Community could not be deleted, backend or SQL statement to remove community

[Lewatle Johannes Phaladi]

Hi All,

Is there any SQL statement to remove community, I have failed to remove it from frontend and now I would like to delete this community with its subcommunity using SQL statement please share any statement that might be helpful to delete this community on DSpace 7.6

Regards,

Lewatle 

[Jose Blanco]

Hi Lewatle,

I think it's a complicated thing to do via the database. I would look
at the log file and see why it's not letting you delete it via the UI.
It might be an item in the collection that is somehow not able to be
deleted and if you can find out why that item is not deleting, you
might be able to address that issue and then delete the collection.
That is my guess.

-Jose

> --
> All messages to this mailing list should adhere to the Code of Conduct: https://www.lyrasis.org/about/Pages/Code-of-Conduct.aspx
> ---
> 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...@googlegroups.com.
> To view this discussion on the web visit https://groups.google.com/d/msgid/dspace-tech/1d949908-65a1-46f8-aed1-905d0b38fa1an%40googlegroups.com.

[Lewatle Johannes Phaladi]

Hello Jose,

The community is removed/deleted only for none logged in users but after I login still the community appears and when logged out community is not visible.

Regards,

Lewatle 

[Lewatle Johannes Phaladi]

Hi DSpace Support and Jose,

Please see the following log file that is printed when trying to delete community and collection :

2024-01-16 07:25:01,365 INFO  a293bd5e-f0b4-421f-8508-0d3f2228614c b7e8eeff-84c8-4223-870b-67077c4bc20d org.dspace.app.rest.utils.DSpaceAPIRequestLoggingFilter @ Before request [GET /server/api/authz/authorizations/search/object] originated from /
2024-01-16 07:25:01,367 INFO  a293bd5e-f0b4-421f-8508-0d3f2228614c 2da86b2c-98ee-4228-9c9f-a1ed3b6d87ac org.dspace.app.rest.utils.DSpaceAPIRequestLoggingFilter @ Before request [GET /server/api/authz/authorizations/search/object] originated from /
2024-01-16 07:25:01,368 INFO  a293bd5e-f0b4-421f-8508-0d3f2228614c f610434d-7966-4397-8262-f2193c55646d org.dspace.app.rest.utils.DSpaceAPIRequestLoggingFilter @ Before request [GET /server/api/authz/authorizations/search/object] originated from /
2024-01-16 07:25:01,369 INFO  a293bd5e-f0b4-421f-8508-0d3f2228614c 3ce69b09-5a2c-4e04-a865-cb61956da99b org.dspace.app.rest.utils.DSpaceAPIRequestLoggingFilter @ Before request [GET /server/api/authz/authorizations/search/object] originated from /
2024-01-16 07:25:01,405 INFO  a293bd5e-f0b4-421f-8508-0d3f2228614c 38b27ef7-5190-4d89-af23-1d28afccc70e org.dspace.app.rest.utils.DSpaceAPIRequestLoggingFilter @ Before request [GET /server/api/core/items/d268de6b-baea-4bf5-91be-511104c246bc/thumbnail] originated from /
2024-01-16 07:25:01,410 INFO  a293bd5e-f0b4-421f-8508-0d3f2228614c 52c157e7-620e-468e-9af8-eb93976a2ea8 org.dspace.app.rest.utils.DSpaceAPIRequestLoggingFilter @ Before request [GET /server/api/core/items/d268de6b-baea-4bf5-91be-511104c246bc] originated from /
2024-01-16 07:25:01,495 INFO  a293bd5e-f0b4-421f-8508-0d3f2228614c d15888ea-be0f-4384-82ac-7676a04f8c46 org.dspace.app.rest.utils.DSpaceAPIRequestLoggingFilter @ Before request [GET /server/api/authz/authorizations/search/object] originated from /
2024-01-16 07:25:01,495 INFO  a293bd5e-f0b4-421f-8508-0d3f2228614c 3b876c6b-cfb0-4915-8b14-7df7cc28b646 org.dspace.app.rest.utils.DSpaceAPIRequestLoggingFilter @ Before request [GET /server/api/authz/authorizations/search/object] originated from /
2024-01-16 07:25:01,495 INFO  a293bd5e-f0b4-421f-8508-0d3f2228614c 6ad58131-a968-4535-addf-f3a2827cefd9 org.dspace.app.rest.utils.DSpaceAPIRequestLoggingFilter @ Before request [GET /server/api/authz/authorizations/search/object] originated from /
2024-01-16 07:25:01,495 INFO  a293bd5e-f0b4-421f-8508-0d3f2228614c 10ce8665-1352-4a34-ab71-205870920cf0 org.dspace.app.rest.utils.DSpaceAPIRequestLoggingFilter @ Before request [GET /server/api/authz/authorizations/search/object] originated from /
2024-01-16 07:25:01,567 INFO  a293bd5e-f0b4-421f-8508-0d3f2228614c d3f6b60d-b7a6-4b15-8d95-e2559ab6ae4f org.dspace.app.rest.utils.DSpaceAPIRequestLoggingFilter @ Before request [GET /server/api/core/communities/1534a1c1-070b-46da-8296-11820af70170/parentCommunity] originated from /items/d268de6b-baea-4bf5-91be-511104c246bc/full
2024-01-16 07:25:01,567 INFO  a293bd5e-f0b4-421f-8508-0d3f2228614c 4395d449-a1ae-428b-8a8f-9224297cb8af org.dspace.app.rest.utils.DSpaceAPIRequestLoggingFilter @ Before request [GET /server/api/core/items/d268de6b-baea-4bf5-91be-511104c246bc/bundles] originated from /items/d268de6b-baea-4bf5-91be-511104c246bc/full
2024-01-16 07:25:01,580 INFO  a293bd5e-f0b4-421f-8508-0d3f2228614c 8e0b7d09-5977-45f6-aad3-0a5ee4abc250 org.dspace.app.rest.utils.DSpaceAPIRequestLoggingFilter @ Before request [GET /server/api/authz/authorizations/search/object] originated from /items/d268de6b-baea-4bf5-91be-511104c246bc/full
2024-01-16 07:25:01,580 INFO  a293bd5e-f0b4-421f-8508-0d3f2228614c 6ea0a178-9e15-428c-9d6f-9b26382bd8d5 org.dspace.app.rest.utils.DSpaceAPIRequestLoggingFilter @ Before request [GET /server/api/system/systemwidealerts/search/active] originated from /items/d268de6b-baea-4bf5-91be-511104c246bc/full
2024-01-16 07:25:01,582 INFO  a293bd5e-f0b4-421f-8508-0d3f2228614c ab1b3a38-d676-4b21-9ddb-3fbbc13925dc org.dspace.app.rest.utils.DSpaceAPIRequestLoggingFilter @ Before request [GET /server/signposting/links/d268de6b-baea-4bf5-91be-511104c246bc] originated from /items/d268de6b-baea-4bf5-91be-511104c246bc/full
2024-01-16 07:25:01,613 INFO  a293bd5e-f0b4-421f-8508-0d3f2228614c 1a68212d-87ba-4400-97fb-3f8727ff22ce org.dspace.app.rest.utils.DSpaceAPIRequestLoggingFilter @ Before request [GET /server/api/core/items/d268de6b-baea-4bf5-91be-511104c246bc/mappedCollections] originated from /items/d268de6b-baea-4bf5-91be-511104c246bc/full
2024-01-16 07:25:01,627 INFO  a293bd5e-f0b4-421f-8508-0d3f2228614c ec4e79e0-12ea-4a91-b6f0-e6753d3d4c49 org.dspace.app.rest.utils.DSpaceAPIRequestLoggingFilter @ Before request [GET /server/api/authz/authorizations/search/object] originated from /items/d268de6b-baea-4bf5-91be-511104c246bc/full
2024-01-16 07:25:01,627 INFO  a293bd5e-f0b4-421f-8508-0d3f2228614c 96d19d33-ea9e-4540-a390-a4a2de6ce977 org.dspace.app.rest.utils.DSpaceAPIRequestLoggingFilter @ Before request [GET /server/api/authz/authorizations/search/object] originated from /items/d268de6b-baea-4bf5-91be-511104c246bc/full
2024-01-16 07:25:01,671 INFO  a293bd5e-f0b4-421f-8508-0d3f2228614c 2bf968e4-4222-495f-a40a-34c32aa0f901 org.dspace.app.rest.utils.DSpaceAPIRequestLoggingFilter @ Before request [GET /server/api/core/bundles/31887367-5300-477b-85f2-88a28ef95f1e/bitstreams] originated from /items/d268de6b-baea-4bf5-91be-511104c246bc/full
2024-01-16 07:25:01,671 INFO  a293bd5e-f0b4-421f-8508-0d3f2228614c 35dc107c-d735-4cdd-b324-e521e0fb01fa org.dspace.app.rest.utils.DSpaceAPIRequestLoggingFilter @ Before request [GET /server/api/core/bundles/28b3cf44-b045-4be5-8321-c773360ce0e8/primaryBitstream] originated from /items/d268de6b-baea-4bf5-91be-511104c246bc/full
2024-01-16 07:25:01,685 INFO  a293bd5e-f0b4-421f-8508-0d3f2228614c 9430023b-565a-4c5b-922b-e00ab66794c2 org.dspace.app.rest.utils.DSpaceAPIRequestLoggingFilter @ Before request [GET /server/api/core/bundles/31887367-5300-477b-85f2-88a28ef95f1e/primaryBitstream] originated from /items/d268de6b-baea-4bf5-91be-511104c246bc/full
2024-01-16 07:25:01,686 INFO  a293bd5e-f0b4-421f-8508-0d3f2228614c 8ac8775e-dcf2-48c0-8cce-6f8de4f43ef7 org.dspace.app.rest.utils.DSpaceAPIRequestLoggingFilter @ Before request [GET /server/api/core/bundles/28b3cf44-b045-4be5-8321-c773360ce0e8/bitstreams] originated from /items/d268de6b-baea-4bf5-91be-511104c246bc/full
2024-01-16 07:25:01,688 INFO  a293bd5e-f0b4-421f-8508-0d3f2228614c b29d9ba9-46e0-468c-9311-06ac7f9f1558 org.dspace.app.rest.utils.DSpaceAPIRequestLoggingFilter @ Before request [GET /server/api/core/bitstreams/b1d63e27-06a5-4ae5-b188-5cbbe4a4c867/thumbnail] originated from /items/d268de6b-baea-4bf5-91be-511104c246bc/full
2024-01-16 07:25:01,705 INFO  a293bd5e-f0b4-421f-8508-0d3f2228614c 0868a33c-2dfe-4b05-bfff-2bb48889d449 org.dspace.app.rest.utils.DSpaceAPIRequestLoggingFilter @ Before request [GET /server/api/config/properties/websvc.opensearch.enable] originated from /items/d268de6b-baea-4bf5-91be-511104c246bc/full
2024-01-16 07:25:01,723 INFO  a293bd5e-f0b4-421f-8508-0d3f2228614c c57b602e-eba3-44a1-8171-0593de52ca4d org.dspace.app.rest.utils.DSpaceAPIRequestLoggingFilter @ Before request [GET /server/api/config/properties/websvc.opensearch.svccontext] originated from /items/d268de6b-baea-4bf5-91be-511104c246bc/full
2024-01-16 07:25:01,741 INFO  a293bd5e-f0b4-421f-8508-0d3f2228614c aabf604b-3f29-4052-984e-8d1352f23d16 org.dspace.app.rest.utils.DSpaceAPIRequestLoggingFilter @ Before request [GET /server/api/authz/authorizations/search/object] originated from /items/d268de6b-baea-4bf5-91be-511104c246bc/full
2024-01-16 07:25:01,741 INFO  a293bd5e-f0b4-421f-8508-0d3f2228614c fa074cdc-5594-4c4b-815a-daee6b8f6403 org.dspace.app.rest.utils.DSpaceAPIRequestLoggingFilter @ Before request [GET /server/api/authz/authorizations/search/object] originated from /items/d268de6b-baea-4bf5-91be-511104c246bc/full
2024-01-16 07:25:01,762 INFO  a293bd5e-f0b4-421f-8508-0d3f2228614c b5acc14b-bed5-416d-90bf-2b7380b8286b org.dspace.app.rest.utils.DSpaceAPIRequestLoggingFilter @ Before request [GET /server/api/core/bitstreams/5a30fc61-a834-4387-9069-db798a1fe238/thumbnail] originated from /items/d268de6b-baea-4bf5-91be-511104c246bc/full
2024-01-16 07:25:01,774 INFO  a293bd5e-f0b4-421f-8508-0d3f2228614c d5704d17-7653-495b-b0af-61f4b76cdbb6 org.dspace.app.rest.utils.DSpaceAPIRequestLoggingFilter @ Before request [GET /server/api/authz/authorizations/search/object] originated from /items/d268de6b-baea-4bf5-91be-511104c246bc/full
2024-01-16 07:25:01,792 INFO  a293bd5e-f0b4-421f-8508-0d3f2228614c 4325f3bd-40b8-422c-bc81-dd18eddc87f1 org.dspace.app.rest.utils.DSpaceAPIRequestLoggingFilter @ Before request [GET /server/api/authz/authorizations/search/object] originated from /items/d268de6b-baea-4bf5-91be-511104c246bc/full
2024-01-16 07:25:01,850 INFO  unknown 5404d848-b9a8-41f8-bedf-16691ae75c4b org.dspace.app.rest.utils.DSpaceAPIRequestLoggingFilter @ Before request [GET /server/] originated from unknown

Regards,

Lewatle 

[DSpace Technical Support]

Hi Lewatle

Those logs don't appear to show a request to "DELETE /server/api/core/communities/[uuid]".  That's the request that should be sent by the User Interface whenever you click the Delete button on a Community.  See the REST Contract for Community deletion... these are the docs that describe this request:  https://github.com/DSpace/RestContract/blob/main/communities.md#deleting-a-community

Since that request isn't shown in the logs you shared (there's no line in those logs that even contains "DELETE"), I suspect either they are the wrong logs **or** the User interface is throwing an error before the DELETE command can be sent.  If it's an error in the User Interface, then you should use our Troubleshooting guide to locate the error details from your web browser's "DevTools" Console: https://wiki.lyrasis.org/display/DSPACE/Troubleshoot+an+error#Troubleshootanerror-DSpace7.x(orabove)

Without the specific error it's difficult to help.  I do agree though that it's much easier to delete a Community via either the User Interface or REST API than via the database.  Deleting via the database would be extremely complex and not recommended (as you could result in a corrupted database).

Tim

[Lewatle Johannes Phaladi]

Hello Tim,

Much appreciated for the reply I will follow on steps shared especially checking error from web browser.

Regards,

Lewatle