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/