On 07/13/2011 06:06 AM, Andrew Parkinson wrote: > Please can anyone help me with my problem below: > > (Apologies if I am going about this request the wrong way, it is the > first time I've used this method - if I am doing something wrong please > advise corrections...) >
You're doing great, don't worry :) > > I have a page in a space in my wiki that I cannot delete - this is a > page that the users need not see, and the ?link needs removing to > prevent 'recreating' the page. > > I have tried several ways to remove this but it is persistent. > > > > I have tried - > > * Directly deleting the page. [results in the error below - and > leaves the link to the page with a '?' as being ready to create if > clicked] > * Moving the page to another space e.g. the Sandbox [results in > the page being copied to the sand box, but still leaves the link to the > page with a '?' as being ready to create if clicked] > * Creating an entirely new space and recreating all the other > pages (not moving them) except the unwanted page, and then deleting the > old space. [results in the deleted space showing with a '?' as being > ready to create if clicked - and there is still reference to the > unwanted page in this old space in the document index] > * I have checked all permissions and reset them on the unwanted > page/link/space to allow deletion - and I am trying to perform these > actions as Admin. [results in same as above] > > > > The error displayed when I delete the page is: > > > java.sql.SQLException: Violation of unique constraint $$: duplicate > value(s) for column(s) $$: SYS_CT_116 in statement [insert into > xwikirecyclebin (XDD_ID, XDD_FULLNAME, XDD_LANGUAGE, XDD_DATE, > XDD_DELETER, XDD_XML) values (null, ?, ?, ?, ?, ?)] > Looks like the table used for storing deleted documents has a problem. Can you try going to the document trash and delete any documents that might be there? You can find the trash by going to the Document Index, and selecting the Deleted Documents tab. Then try again to delete the problematic document. If it appears to be missing, restart the wiki. -- Sergiu Dumitriu http://purl.org/net/sergiu/ _______________________________________________ users mailing list [email protected] http://lists.xwiki.org/mailman/listinfo/users
