This page last changed on Aug 26, 2009 by jlargman.
You may be able to access the edit page URL by hitting ctrl+e

If you have a page that you can't access (for example, due to an incompatible plugin that won't render a macro), you can delete or edit the page by manually entering the appropriate URL. The URL looks like this:

http://<baseurl>/pages/removepage.action?pageId=<pageID>
http://<baseurl>/pages/editpage.action?pageId=<pageID>
http://<baseurl>/pages/editblogpost.action?pageId=<pageID>

Substitute your page ID for the one you wish to delete. To determine the page ID, you may be able to access it from the edit page URL by hitting ctrl+e. If not, you can obtain this information from the database using an SQL query like this:

SELECT CONTENTID FROM content WHERE TITLE = '<pagename>' AND VERSION = '1';

This may return multiple results if there are pages with the same name in different spaces, so you may have to further determine the correct one.

To delete an attachment manually, you can use a URL like:

http://<baseurl>/pages/removeattachment.action?pageId=32787&fileName=harbour.jpg&version=1

To view the attachments on a page:

http://<baseurl>/pages/viewpageattachments.action?pageId=<pageId>

Get the page ID similarly.

To get the wiki markup from the database directly, try:

SELECT BODY FROM BODYCONTENT WHERE CONTENTID IN (SELECT CONTENTID FROM content WHERE TITLE = '<insert name of page or blog post>');
Document generated by Confluence on Jul 09, 2010 01:11