Community
Products
Confluence
Questions
Broken links after migration Confluence

Broken links after migration Confluence

Hi there.

We've recently migrated Confluence with small update (7.4 => 7.13) to another server by XLM backup. No errors/warnings were during restore process. And on the first view everything looked great. But as soon as we began using the new instance we noticed many pages with broken links. They are highlighted red color.

How can we find all broken links and fix them?

5 answers

1 accepted

2 votes

Answer accepted

Had today the same problem

seems like recreating db with LC_COLLATE C and LC_CTYPE C solves the problem.

Did you change LC_COLLATE 'C' LC_CTYPE 'C' to

LC_COLLATE 'en_GB.UTF-8' LC_CTYPE 'en_GB.UTF-8' or smth else?

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.

Comment

We created DB by command

CREATE DATABASE DBName WITH ENCODING 'UNICODE' LC_COLLATE 'C' LC_CTYPE 'C' TEMPLATE template0;

Is it correctly, is it?

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.

Comment

@Danila Bystrov

thanks a lot for your advice. I have double checked DB settings on both instances and noticed that LC_COLLATE and LC_CTYPE were different. Recreating DB has solved our issue.

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.

Comment

Like • Kishan Sharma likes this

1 vote

Something like this?

UPDATE BODYCONTENT
SET BODY = REPLACE( BODY, 'OLDURL', 'NEWURL' )
WHERE BODY LIKE '%OLDURL%';

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.

Comment

I am afraid it's not suitable, because base URL hasn't been changed

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.

Comment

Then where do these links point to? External resources? Jira?

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.

Comment

They point to Confluence internal pages

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.

Comment

0 votes

Hi, I had problem after migrating to cloud where link were broken, I used this new application Easy Link Checker to find where these links are.

Let me know if this app worked for you as well.

➡️ Easy Link Checker