nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

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?

Accepted answers

Danila Bystrov

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?

All comments

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.

Danila Bystrov

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

Ok, I've already done it.

Alexey Astafyev

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

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

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

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)

Zander Human

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

Welcome!

It looks like you're new here. Sign in or register to get started.

Quick Links

Find more posts tagged with

confluence

server

confluence-server