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/