Hi Claudia,
There are no "referential integrity violation" error in the log files.
Here are my db foreign keys for "\d community2collection"
Table "public.community2collection"
Column | Type | Modifiers
---------------+---------+-----------
id | integer | not null
community_id | integer |
collection_id | integer |
Indexes:
"community2collection_pkey" PRIMARY KEY, btree (id)
"community2collection_collection_id_idx" btree (collection_id)
"community2collection_community_id_idx" btree (community_id)
Foreign-key constraints:
"comm2coll_collection_fk" FOREIGN KEY (collection_id) REFERENCES
collection(collection_id) DEFERRABLE
"community2collection_community_id_fkey" FOREIGN KEY (community_id)
REFERENCES community(community_id)
Would this line
"community2collection_community_id_fkey" FOREIGN KEY (community_id)
REFERENCES community(community_id)
be the line to use against $2?
ALTER TABLE community2collection DROP CONSTRAINT "$2";
ALTER TABLE collection2item DROP CONSTRAINT "$2";
ALTER TABLE community2community DROP CONSTRAINT "$2";
Can running these commands cause other errors?
Thank you for your help.
Craig.
>>> Claudia Jürgen<[email protected]> 2/3/2011 11:32 AM
>>>
Hello Craig,
can you provide details from your log files? Do you got database
related
errors like "org.postgresql.util.PSQLException: ERROR:<unnamed>
referential integrity violation"?
Are unable to delete a collection and/or community too? If so, you
most
probably ran into this error during your upgrade process, see:
http://www.mail-archive.com/[email protected]/msg11522.html
(includes detailed description and fix).
Hope that helps
Claudia Jürgen
Am 03.02.2011 09:23, schrieb Craig Strydom:
>
> Hi All,
>
> I have upgraded our Dspace 1.4.2 to 1.7.0 successfully but seem to
> have a permission problem.
>
> Doing the following gives an error: 1. Re-submiting an item that was
> rejected for rework 2. Changing a file of an existing record 3.
> Permanently deleting a record - even as administrator
>
> "The system has experienced an internal error. Please try to do what
> you were doing again, and if the problem persists, please contact us
> so we can fix the problem."Could user permissions have been
> incorrectly transferred to the new server during
> upgrade?Regards,Craig.
>
>
>
>
>
>
------------------------------------------------------------------------------
>
>
Special Offer-- Download ArcSight Logger for FREE (a $49 USD value)!
> Finally, a world-class log management solution at an even better
> price-free! Download using promo code Free_Logger_4_Dev2Dev. Offer
> expires February 28th, so secure your free ArcSight Logger TODAY!
> http://p.sf.net/sfu/arcsight-sfd2d
>
>
>
> _______________________________________________ DSpace-tech mailing
> list [email protected]
> https://lists.sourceforge.net/lists/listinfo/dspace-tech
--
Claudia Juergen
Universitaetsbibliothek Dortmund
Eldorado
0231/755-4043
https://eldorado.tu-dortmund.de/
------------------------------------------------------------------------------
Special Offer-- Download ArcSight Logger for FREE (a $49 USD value)!
Finally, a world-class log management solution at an even better
price-free!
Download using promo code Free_Logger_4_Dev2Dev. Offer expires
February 28th, so secure your free ArcSight Logger TODAY!
http://p.sf.net/sfu/arcsight-sfd2d
_______________________________________________
DSpace-tech mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/dspace-tech
--
This message is subject to the CSIR's copyright terms and conditions, e-mail
legal notice, and implemented Open Document Format (ODF) standard.
The full disclaimer details can be found at
http://www.csir.co.za/disclaimer.html.
This message has been scanned for viruses and dangerous content by MailScanner,
and is believed to be clean. MailScanner thanks Transtec Computers for their
support.
------------------------------------------------------------------------------
The modern datacenter depends on network connectivity to access resources
and provide services. The best practices for maximizing a physical server's
connectivity to a physical network are well understood - see how these
rules translate into the virtual world?
http://p.sf.net/sfu/oracle-sfdevnlfb
_______________________________________________
DSpace-tech mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/dspace-tech
