Hello Craig, then the problem isn't related to this known upgrade and postgres issue. Seemed to be from the description of your error.
Any other error messages in the log files? Hope that helps Claudia Jürgen Am 07.02.2011 07:58, schrieb Craig Strydom: > > 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<claudia.juer...@ub.tu-dortmund.de> 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/dspace-tech@lists.sourceforge.net/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 DSpace-tech@lists.sourceforge.net >> 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 > DSpace-tech@lists.sourceforge.net > https://lists.sourceforge.net/lists/listinfo/dspace-tech > > > > > ------------------------------------------------------------------------------ > 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 > DSpace-tech@lists.sourceforge.net > https://lists.sourceforge.net/lists/listinfo/dspace-tech -- Claudia Juergen Universitaetsbibliothek Dortmund Eldorado 0231/755-4043 https://eldorado.tu-dortmund.de/ ------------------------------------------------------------------------------ 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 DSpace-tech@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/dspace-tech
