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
Answer accepted

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 Tuesday in Confluence

Confluence Admin Certification now $150 for Community Members

More and more people are building their careers with Atlassian, and we want you to be at the front of this wave! Important Dates Start the Certification Prep Course by 2 April 2019 Take your e...

212 views 2 10
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