This question is in reference to Atlassian Documentation: Deleting a Page
So we have an issue where it looks like someone created a page with invalid characters in the title and now when we try to goto the page we get a runtime error. So with that being said, I was hoping for a back end way to delete the page...
If you can find the id of the page then you can use the API to delete the page. We ran into a similar issue and I had to first use the API to get a list of the pages in the space, then find the broken page in the list and get the page ID, then use the API to delete the page.
I had similar problems in the past and fixed them without CLI
p.s.: Just found it:
select * from bodycontent join content on content.CONTENTID=bodycontent.CONTENTID and content.SPACEID='YYY' where body like '%XXXXX%';
As a result you find a list of pages - look for the line which fits your page and you find the ContentID we are looking for in third column named CONTENTID
You may not have to go through all this trouble. If you can figure out the pageId, then you could simply press delete on another page, edit the pageId attribute to be the page you want to delete, and press enter to load the URL and it should update to delete the page you want.
This might avoid having to use the API, CLI, or database.
Well, if your page has special characters in the title, then you can just search for it and copy the pageId out of the link URL. If it's not, one thing you could do is to open the browser console (I like to use Chrome for this) on the search page, switch to the network tab, run the search (so that it will show a request to the confluence server for the search), click on the request, and click the Preview tab. Then expand the "results" section, and you should be able to see the pageId next to the page titles.
so I've hit another snag. So I did a query against the database (MS SQL Server) and got the records in the content table but my new issue is that there is no PageID. That being said, Is it safe to turf from the database directly? and If so, does anyone know what all tables I have to reference?
Hi Community! I’m Elaine, Confluence Product Manager. You may have read my earlier post about page tree in space navigation sidebar. I'm excited to share another improvement that helps you organize ...
Connect with like-minded Atlassian users at free events near you!Find a group
Connect with like-minded Atlassian users at free events near you!
Unfortunately there are no AUG chapters near you at the moment.Start an AUG
You're one step closer to meeting fellow Atlassian users at your local meet up. Learn more about AUGs