Re: [dspace-tech] Community could not be deleted, backend or SQL statement to remove community
Hello Tim, Much appreciated for the reply I will follow on steps shared especially checking error from web browser. Regards, Lewatle On Tuesday 16 January 2024 at 20:08:46 UTC+2 DSpace Technical Support wrote: > 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 joem...@gmail.com 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
Re: [dspace-tech] Community could not be deleted, backend or SQL statement to remove community
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 joem...@gmail.com 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]
Re: [dspace-tech] Community could not be deleted, backend or SQL statement to remove community
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
Re: [dspace-tech] Community could not be deleted, backend or SQL statement to remove community
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 > 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 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 > . > -- 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+unsubscr...@googlegroups.com. To view this discussion on the web visit https://groups.google.com/d/msgid/dspace-tech/5e6696bc-3b1b-4c3b-a1d7-719b51cf4866n%40googlegroups.com.
Re: [dspace-tech] Community could not be deleted, backend or SQL statement to remove community
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 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 dspace-tech+unsubscr...@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. -- 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+unsubscr...@googlegroups.com. To view this discussion on the web visit https://groups.google.com/d/msgid/dspace-tech/CAK%3DKc-vGj91qgHV9bu86%3DFR_KPKoUqfwE%3DD2CGMjF8xq-J9CCA%40mail.gmail.com.