Broken links after migration Confluence

[Alexey Astafyev]

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?

[Danila Bystrov · Accepted solution]

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?

[Alexey Astafyev]

We created DB by command

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

Is it correctly, is it?

[Alexey Astafyev]

@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.

[Artem Fomin - DevOps Action]

Something like this?

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

[Alexey Astafyev]

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

[Artem Fomin - DevOps Action]

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

[Alexey Astafyev]

They point to Confluence internal pages

[Alexey Astafyev]

Is the way to use sql queries to find broken links?

[Kishan Sharma]

Hi @Alexey Astafyev Welcome to the Atlassian Community!

I would suggest opening a ticket with Atlassian support at https://support.atlassian.com/contact/ in order to have the links fixed. 

[Alexey Astafyev]

Ok, I've already done it.

[Dmitriy Dmitrov]

@Alexey Astafyevdid u fix this error?

[Alexey Astafyev]

@Dmitriy Dmitrov yes, we have recreated the database with the proper collation (as it was previous instance)