confluence Anchors not working after upgraade from 4.2 to 5.3

After upgrade the pages with existing anchors does not work anymore. The Anchor macro is still there but a # was added to the name of the anchor and thus all the links to this anchor does not work.

We are talking about thousands of anchor. Any resolution but doing some DB updates?

6 answers

1 accepted

0 votes
Accepted answer

Heya Peter,

By taking a look at the behaviour, it looks like one of our known bugs:

After migration from 3.5.13 to 4.2.x, 4.3.x and 5.5.1 In page anchor displays with #anchorname instead of just anchorname

Through this one, we can see that we have a workaround to remove the hash from the link (as you have asked) and basically, it would be:

You can inject SQL query to remove the hash from the link. For example this is the SQL query for MySQL.

UPDATE BODYCONTENT SET BODY = REPLACE(BODY, 'link-body>#', 'link-body>') WHERE BODY LIKE '%ac:anchor%link-body>#%';

Hope it helps ya,


It does not work on Cloud as well.

We have Confluence 5.7 and the anchor macro is not working for us either. Is this a known bug?

Thank you!



Social Venture Partners 

It is not working for 5.4.2 version as well.

Not working in cloud for me.

Also there is no way to link anchors while using numerical format:

Example: ../wiki/pages/viewpage.action?pageId=19726602

Adding hashtag doens't work.


please check your anchor to ensure that there are no spaces or underscores. These screw up the macro.

Suggest an answer

Log in or Sign up to answer
Community showcase
Published Nov 29, 2018 in New to Confluence

How to use Confluence Cloud for stakeholder management

Most of us don’t need much convincing that stakeholder management is important. It just makes sense that keeping everyone in-the-know on projects and assigning clearly defined roles is key to having ...

1,223 views 4 6
Read article

Atlassian User Groups

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!

Find my local user group

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

Groups near you