Hi Jose,
Referring to https://wiki.duraspace.org/display/DSDOC5x/Upgrading+DSpace#UpgradingDSpace-UpgradeSteps (point 11) starting from version 5.x the table "COMMUNITIES2ITEM" is deprecated and can be emptied. Hope this helps Riccardo On Thu, 2018-12-13 at 15:05 -0500, Jose Blanco wrote: > When I try to replace an item using this command: > ./dspace import -r -e 1 -c 123 -s some_dir -m mapfile_test_one > > It wont work because the item is mapped into a community. I kind of > want to remove this mapping using sql, but am unsure. Not really sure > why the item would be in that table. > > org.postgresql.util.PSQLException: ERROR: update or delete on table > "item" violates foreign key constraint "$2" on table > "communities2item" > > Detail: Key (item_id)=(55981) is still referenced from table > "communities2item". > -- -- Riccardo Fazio DSpace and DSpace-CRIS developer 4Science, www.4science.it (an Itway Group Company) office: UP Urban Places - Via Tiburtina, 652, 00159 Roma RM tel: +39 3339341798 -- Questo messaggio e' stato analizzato da Libra ESVA ed e' risultato non infetto. This message was scanned by Libra ESVA and is believed to be clean. -- All messages to this mailing list should adhere to the DuraSpace Code of Conduct: https://duraspace.org/about/policies/code-of-conduct/ --- 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 post to this group, send email to dspace-tech@googlegroups.com. Visit this group at https://groups.google.com/group/dspace-tech. For more options, visit https://groups.google.com/d/optout.
