Confluence 4.1.6 does not recognize this as a link

Hi,

I have the following link when i add this to the page in Confluence 4.1.6 it treats it as a simple text any idea what te issue is?

http://qa.test.com/php/tsi_tests_set.php?product=test_cloud&version=Version^1.0.0^build^V001^GA-1&area=&category=runtime&report_type=byPlatform&oracle_sid=test&username

I see this in the source editor

<a>http://qa.test.com/php/tsi_tests_set.php?product=test_cloud&version=Version^1.0.0^build^V001^GA-1&area=&category=runtime&report_type=byPlatform&oracle_sid=test&username</a>

thanks

1 answer

1 accepted

1 vote
Accepted answer

Hi Dave,

It's the Caret ("^") characters that are causing the problem. Try encoding them using %5E, e.g.:

http://qa.test.com/php/tsi_tests_set.php?product=test_cloud&version=Version%5E1.0.0%5Ebuild%5EV001%5EGA-1&area=&category=runtime&report_type=byPlatform&oracle_sid=test&username

Hope that helps?

Andrew.

Thanks Andrew this is a good workaround but i have 1000s of links that are broken and i am not sure how i can go and fix all those ....

I will wait to see if someone can provide me with an option to replace all my broken links in an automated way

thanks

Hi Dave,

A couple of questions:

1. What database platform are you using?
2. How many unique URLs need to be changed? Is it 1000's of unqiue URLs or a handful of unique URLs repeated 1000's of times at different locations/versions of pages?

Depending on database platform and if it's a handful of repeated URLs you could change them directly in the database with SQL simialr to the following:

UPDATE BODYCONTENT
SET BODY = REPLACE(BODY,'<a>http://qa.test.com/php/tsi_tests_set.php?product=test_cloud&version=Version^1.0.0^build^V001^GA-1&area=&category=runtime&report_type=byPlatform&oracle_sid=test&username</a>','<a href="http://qa.test.com/php/tsi_tests_set.php?product=test_cloud&version=Version%5E1.0.0%5Ebuild%5EV001%5EGA-1&area=&category=runtime&report_type=byPlatform&oracle_sid=test&username">http://qa.test.com/php/tsi_tests_set.php?product=test_cloud&version=Version%5E1.0.0%5Ebuild%5EV001%5EGA-1&area=&category=runtime&report_type=byPlatform&oracle_sid=test&username</a>');
COMMIT;

i.e

UPDATE BODYCONTENT
SET BODY = REPLACE(BODY,'string to find','replacement string');
COMMIT;

After updating the database you then need to flush the caches via Browse -> Confluence Admin -> Cache Statistics -> Flush All

The above SQL works on Confluence 4.x and MySQL

NB: in the replacement you have to insert the full link, e.g. <a href=...>link text</a> as just updating "^" to "%5E" will not fix the broken link.

Hope that helps,

Andrew.

Andrew, thanks for the detail response ...I am using Oracle and have 100s of unique URLs, will give it a try....

Glad I could help, the same syntax should work for Oracle.

Usual warnings apply of making sure you have a backup, test with a small number of URLs first, try in a test environment, etc. :-)

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

987 views 0 5
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