[
http://jira.dspace.org/jira/browse/DS-596?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Claudia Jürgen resolved DS-596.
-------------------------------
Resolution: Fixed
Fix Version/s: 1.7.0
> Cannot Delete Community which has two or more levels of SubCommunities
> ----------------------------------------------------------------------
>
> Key: DS-596
> URL: http://jira.dspace.org/jira/browse/DS-596
> Project: DSpace 1.x
> Issue Type: Bug
> Components: DSpace API
> Affects Versions: 1.6.1
> Environment: Any
> Reporter: Tim Donohue
> Assignee: Claudia Jürgen
> Fix For: 1.7.0
>
> Attachments: Community.java.patch
>
>
> If you have a Community which has two or more levels of subcommunities, a
> database error will be thrown when you attempt to delete it.
> As an example, suppose you have the following hierarchy:
> Community 1
> - Sub-Community 1.1
> - Sub-Sub-Community 1.1.1
> In that example, if you attempt to delete "Community 1", then you will end
> up receiving a "PSQLException" similar to the following:
> org.postgresql.util.PSQLException: ERROR: update or delete on table
> "community" violates foreign key constraint "com2com_child_fk" on table
> "community2community"
> Detail: Key (community_id)=(SOME_ID) is still referenced from table
> "community2community".
> (Where "SOME_ID" will be the internal ID of the "Sub-Community 1.1)
> Essentially, it looks like the Sub-Community 1.1 is unable to be deleted as
> its ID is not removed from community2community.
> You can see this error by logging in as an Admin and trying to delete the
> following Top-Level Community on the Demo Server (it has both a sub-community
> & a sub-sub-community):
> http://demo.dspace.org/xmlui/handle/10673/203
> However, it's worth noting that Community deletion works fine if you only
> have "Sub-Communities" and do not have an "Sub-Sub-Communities".
> I haven't had a chance to figure out *why* this happens -- just wanted to
> note that it is happening.
> Here's a slightly larger Java stacktrace:
> org.postgresql.util.PSQLException: ERROR: update or delete on table
> "community" violates foreign key constraint "com2com_child_fk" on table
> "community2community"
> Detail: Key (community_id)=(42) is still referenced from table
> "community2community".
> at
> org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:1531)
> at
> org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1313)
> at
> org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:188)
> at
> org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:452)
> at
> org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:354)
> at
> org.postgresql.jdbc2.AbstractJdbc2Statement.executeUpdate(AbstractJdbc2Statement.java:308)
> at
> org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:102)
> at
> org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:102)
> at
> org.dspace.storage.rdbms.DatabaseManager.updateQuery(DatabaseManager.java:460)
> at
> org.dspace.storage.rdbms.DatabaseManager.deleteByValue(DatabaseManager.java:605)
> at
> org.dspace.storage.rdbms.DatabaseManager.delete(DatabaseManager.java:572)
> at
> org.dspace.storage.rdbms.DatabaseManager.delete(DatabaseManager.java:807)
> at org.dspace.content.Community.rawDelete(Community.java:1053)
> at org.dspace.content.Community.removeSubcommunity(Community.java:954)
> at org.dspace.content.Community.rawDelete(Community.java:1030)
> at org.dspace.content.Community.delete(Community.java:1001)
> at
> org.dspace.app.xmlui.aspect.administrative.FlowContainerUtils.processDeleteCommunity(FlowContainerUtils.java:922)
> at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
> at
> sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
> at
> sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
> at java.lang.reflect.Method.invoke(Method.java:597)
> ....
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
http://jira.dspace.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
------------------------------------------------------------------------------
Sell apps to millions through the Intel(R) Atom(Tm) Developer Program
Be part of this innovative community and reach millions of netbook users
worldwide. Take advantage of special opportunities to increase revenue and
speed time-to-market. Join now, and jumpstart your future.
http://p.sf.net/sfu/intel-atom-d2d
_______________________________________________
Dspace-devel mailing list
Dspace-devel@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/dspace-devel
