Dear Tim, Thank you for your reply. We might have to upgrade sooner or later, but for the time being I ended up removing the reference from the "requestitem" table manually.
Thanks, Evelin DSpace Technical Support a következőt írta (2023. augusztus 16., szerda, 21:21:55 UTC+2): > Hi Evelin, > > This was a bug that was fixed in 7.5: > https://github.com/DSpace/DSpace/issues/8654 Here's the fix: > https://github.com/DSpace/DSpace/pull/8660 > > So, the safest approach is to upgrade to 7.5 or 7.6 and that will allow > you to delete this Item. > > Otherwise, you could manually delete that row in your "requestitem" > database table. > > Tim > > On Wednesday, August 16, 2023 at 4:18:34 AM UTC-5 Evelin Bányai wrote: > >> Okay, I see the following error on the server side: >> >> Caused by: org.postgresql.util.PSQLException: ERROR: update or delete on >> table "item" violates foreign key constraint "requestitem_item_id_fkey" on >> table "requestitem" Detail: Key >> (uuid)=(0db42ab6-6e51-4c4b-a04c-d043ef63247b) is still referenced from >> table "requestitem". >> >> What is the safest why to deal with this issue? >> >> >> Thanks, >> Evelin >> >> Evelin Bányai a következőt írta (2023. augusztus 16., szerda, 8:20:23 >> UTC+2): >> >>> Thanks for the info and the update. >>> >>> No, not really. I'll try and look if I can see anything on the server >>> side. Unfortunately, we have error code 500... and there is only one >>> un-deletable item. Otherwise deleting anything else works fine. >>> >>> Aroldo Rique a következőt írta (2023. augusztus 15., kedd, 23:15:23 >>> UTC+2): >>> >>>> We found the problem. It was missing to enable the delete command in >>>> the reverse proxy. >>>> >>>> Em ter., 15 de ago. de 2023 às 17:46, Aroldo Rique <[email protected]> >>>> escreveu: >>>> >>>>> Error 403... >>>>> >>>>> [image: image.png] >>>>> >>>>> Em ter., 15 de ago. de 2023 às 16:59, Aroldo Rique <[email protected]> >>>>> escreveu: >>>>> >>>>>> Did you manage to solve the problem? >>>>>> I have a similar error currently (dspace 7.5). When trying to delete >>>>>> an item, the following error occurs: "An error occurred while deleting >>>>>> the >>>>>> item". >>>>>> This happens when I try to delete anything, be it community, >>>>>> collection, item, or even a bitstream of an item. No error message >>>>>> appears >>>>>> in the log. I don't know what to do anymore... >>>>>> >>>>>> Em quinta-feira, 10 de agosto de 2023 às 08:49:24 UTC-3, Evelin >>>>>> Bányai escreveu: >>>>>> >>>>>>> Dear All, >>>>>>> >>>>>>> We have a problem with one particular item which cannot be deleted. >>>>>>> Probably due to this we cannot delete the parent collection and >>>>>>> community >>>>>>> of this item. When we try to permanently delete it we get the following >>>>>>> message: >>>>>>> An error occurred while deleting the item. >>>>>>> >>>>>>> I can see this error message in the inspector: >>>>>>> DELETE [url_of_the_item] 500 >>>>>>> >>>>>>> Can anyone help us to solve this issue? >>>>>>> >>>>>>> We can withdraw the item, but we need to delete the community and >>>>>>> its collection, and simply withdrawing this bad item doesn't help. We >>>>>>> are >>>>>>> able to delete other items/collections. >>>>>>> >>>>>>> >>>>>>> Thanks, >>>>>>> Evelin >>>>>>> >>>>>> -- >>>>>> 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 a topic in >>>>>> the Google Groups "DSpace Technical Support" group. >>>>>> To unsubscribe from this topic, visit >>>>>> https://groups.google.com/d/topic/dspace-tech/mDJd_OtXo5Y/unsubscribe >>>>>> . >>>>>> To unsubscribe from this group and all its topics, send an email to >>>>>> [email protected]. >>>>>> To view this discussion on the web visit >>>>>> https://groups.google.com/d/msgid/dspace-tech/a604d722-7451-4228-9544-2b1791d9fca7n%40googlegroups.com >>>>>> >>>>>> <https://groups.google.com/d/msgid/dspace-tech/a604d722-7451-4228-9544-2b1791d9fca7n%40googlegroups.com?utm_medium=email&utm_source=footer> >>>>>> . >>>>>> >>>>> -- 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/e73f9b78-e3cf-4172-bed2-af6919b15934n%40googlegroups.com.
