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
On Tuesday, January 16, 2024 at 1:33:30 AM UTC-6 [email protected] wrote:

> 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 
> On Friday 12 January 2024 at 10:40:13 UTC+2 Lewatle Johannes Phaladi wrote:
>
>> 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 
>>
>> On Thursday 11 January 2024 at 17:02:13 UTC+2 Jose Blanco wrote:
>>
>>> 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 
>>>
>>>
>>> On Thu, Jan 11, 2024 at 7:08 AM Lewatle Johannes Phaladi 
>>> <[email protected]> wrote: 
>>> > 
>>> > 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 
>>> > 
>>> > -- 
>>> > 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 [email protected]. 
>>> > To view this discussion on the web visit 
>>> https://groups.google.com/d/msgid/dspace-tech/1d949908-65a1-46f8-aed1-905d0b38fa1an%40googlegroups.com.
>>>  
>>>
>>>
>>

-- 
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 [email protected].
To view this discussion on the web visit 
https://groups.google.com/d/msgid/dspace-tech/a8c0e80d-38be-4c88-803d-c55c368e3e3fn%40googlegroups.com.

Reply via email to