Bad Request - Invalid URL when loading page Confluence

[Deleted user]

Hello!

We currently have the problem that someone created a page and by mistake somehow entered a "tab" symbol in the page name.  Now the page is published and we are unable to access the page again. When we try to view page we get the notification: "Bad request - Invalid URL" HTTP Error 400, The Request URL is invalid. 

Looking for a troubleshooting solution I found the following information: https://confluence.atlassian.com/confkb/bad-request-invalid-url-when-loading-page-722144482.html

However, I have troubles to get the Id, since in Confluence 6.7 as soon as you click on edit, it's not editpage.action.....anymore but it is /resumedraft.action?draftId=<darft-id>draftShareId=<draft shared number>

Has someone an idea where to get this numbers from? Is there any possibility to access the page again?

Thank you very much in advance for your help!

[AnnWorley]

@[deleted] Please try a SQL select statement on your database to get the pageid.

A little research on my Confluence 6.7 database revealed that the pageid column is null for the PAGE content type in the database. So you have to use the contentid as page ID for the latest version. To see all the versions, please try this SQL:

select contentid, version, title from content where contenttype = 'PAGE' and title like %<PAGE_TITLE>%;

Then use the contentid for the highest version as the pageId in the URL:

<baseURL>/pages/editpage.action?pageId=<CONTENTID_FROM_QUERY>

 I look forward to hearing how it goes.

Thanks,

Ann

[Thomas Schlegel]

Hi Claudia,

if you know the page id, you don't need the draft and share-ids.

Do you see the link to the page e.g. in the page tree? Then you can click with the right-mouse-button on the link and copy the url to the clipboard.

Then paste the link in a new browser window, and change "viewpage" to "editpage".

[Deleted user]

Hey Thomas,

Thank you very much for your quick reply!

I already tried to do that, but it doesn't work. When I copy the link from the page tree I just get https://jira.alicona.com/confluence/display/<SPACEKEY>/<PAGENAME>

If I try to use the option/version from the link I shared above, which would be <baseURL>/pages/editpage.action?pageId=<PAGEID_FROM_QUERY>, I need a page ID, which I don't have.

So, somehow this option doesn't seem to work for me :(

[Thomas Schlegel]

@[deleted] do you see the page in the "recently updated" macro?

There is a link "view change" - this one should also provide you the page id

[Thomas Schlegel]

@[deleted]

If you put the children-macro on the parent page of the broken page, it should also give you the page-id, if you hover over the link.

[Harish bhat]

The other way to fix this issue is:

1. Go to any editable page
2. Click on edit button, navigate to insert more content->other macros option
3. in the search tab, enter "space page ids with Title"
4. Temporarily insert it and do a preview
5. You will find the page id of all the pages.
6. Use the problematic pageid and edit using : <baseURL>/pages/editpage.action?pageId=<pageid>
7. Now delete the line or heading/title that is creating problem and try publishing the page again.
       In my case the heading had something like
              [title]:- [id]... I had to delete the "[" and keep plain text to resolve the issue
8. 

[Harish bhat]

see below comment

[AnnWorley]

Hi Claudia,

In Confluence 6.7 you may get the page ID by going to View History on the ... menu while viewing the page:

[Deleted user]

Hi Ann,

thank you very much for your quick reply!

Unfortunately that doesn't work for me. Since I'm unable to access the page itself  - I can't view it -  I'm unable to view the page history.

[Thomas Schlegel]

@AnnWorley but she can't view the page...

[AnnWorley]

Oh derp - thanks @Thomas Schlegel!

[Thomas Schlegel]

:-)

[Deleted user]

Unfortunately not, so this is not an option (I see it in the recent space activity macro, but since there were no changes made because the page was freshly published for the first time, I can't click on view changes.