Hi Ricardo
Perhaps this will help:
http://wiki.lib.sun.ac.za/index.php/SUNScholar/Browse_Indexes/3.2#WARNING
Cheers
hg
*Hilton Gibson*
Ubuntu Linux Systems Administrator
JS Gericke Library
Room 1025D
Stellenbosch University
Private Bag X5036
Stellenbosch
7599
South Africa
Tel: +27 21 808 4100 | Cell: +27 84 646 4758
http://scholar.sun.ac.za
http://bit.ly/goodir
http://library.sun.ac.za
http://za.linkedin.com/in/hiltongibson
On 31 July 2014 15:58, <[email protected]> wrote:
> Hi.
>
> I tried to remove a non empty colletion. There were two itens there but
> DSpace replied with a SQL error.
>
> Two things bother me.
>
> 1. DSpace warns that it will remove items, so why the error?
>
> 2. The SQL error points to a table "communities2item" that I couldn't
> realize what it is used for and consequently I don't know if I can simply
> remove the line that points to the item. Besides that I'm not sure what
> other side effects this error caused in the database. Even now I cannot
> remove the collection that seems now to be empty. I don't know if the
> reffered item (with item_id 5) is still there.
>
> An error has occurred
>
> Ir para a página inicial
> <http://acervo.novacartografiasocial.com.br:8088/xmlui>
>
> org.postgresql.util.PSQLException: ERROR: update or delete on table "item"
> violates foreign key constraint "communities2item_item_id_fkey" on table
> "communities2item"
> Detail: Key (item_id)=(5) is still referenced from table "communities2item
> ".
>
> Cocoon stacktrace [show]
>
> Java stacktrace [show]
>
>
>
> Java full stacktrace [show]
>
>
>
> The Manakin <https://wiki.duraspace.org/display/DSPACE/Manakin> interface
> of the DSpace <http://dspace.org/> digital repository software.
>
>
>
> Any help is wellcome.
>
> Thanks.
>
> Ricardo
>
>
> ------------------------------------------------------------------------------
> Infragistics Professional
> Build stunning WinForms apps today!
> Reboot your WinForms applications with our WinForms controls.
> Build a bridge from your legacy apps to the future.
>
> http://pubads.g.doubleclick.net/gampad/clk?id=153845071&iu=/4140/ostg.clktrk
> _______________________________________________
> DSpace-tech mailing list
> [email protected]
> https://lists.sourceforge.net/lists/listinfo/dspace-tech
> List Etiquette:
> https://wiki.duraspace.org/display/DSPACE/Mailing+List+Etiquette
>
------------------------------------------------------------------------------
Infragistics Professional
Build stunning WinForms apps today!
Reboot your WinForms applications with our WinForms controls.
Build a bridge from your legacy apps to the future.
http://pubads.g.doubleclick.net/gampad/clk?id=153845071&iu=/4140/ostg.clktrk
_______________________________________________
DSpace-tech mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/dspace-tech
List Etiquette: https://wiki.duraspace.org/display/DSPACE/Mailing+List+Etiquette
