[bug] [forum] Most of the older links seems broken (trivial fix)

[mrd83]

Hi,
this report is not related directly to the app (as subject clarifies). As I believe at some point you moved the forum from `www.` subdomain to the current `forum.` subdomain, which also forced you to move the vhost root from "forum" in the previous vhost to "/" in the current one (saying as concise as I can). Proof:

• old links look like: hXYps://www.aqua-mail.com/forum/index.php?topic=5068.0 [actual link - sorry, I'm"not allowed to post external links ]
• new ones: https://forum.aqua-mail.com/index.php?topic=5068.0 [actual link]

Same goes for some of the blog links (and probably some others too)

As you probably already deducted - above examples include the fix (;]):

• open your favourite DB management tool, find the table and column that holds forum posts
• find string (safest example): "hXYps://www.aqua-mail.com/forum" NOTE: "XY" added to circumvent lack of privileges
• replace with: "https://forum.aqua-mail.com" (note the lack of slash char)
• PGSQL query simplest possible example:
  
  UPDATE mytable
  SET mycolumn = REPLACE(mycolumn, 'str1', 'str2')
  WHERE mycolumn ILIKE '%str1%';

I left both "str1" and "str2" on purpose (less clutter) - but I'm confident it won't be a problem 

P.S.: of course there are other ways (apache/nginx "rewrite" for example) - I just prefer not to write an entire arricle here 

Have fun,
regards
Mike

[Martin - Aqua Mail Support]

Hello mrd83,

Thank you for the detailed report and feedback; much appreciated.

You’re right, this looks related to older forum/blog links from the previous www.aqua-mail.com/forum structure not being properly redirected or updated after the move to the current forum.aqua-mail.com subdomain.

I’ve transferred the information, including your examples and suggested fix, to the team for review. They’ll check the best approach, whether that’s updating stored links, adding redirects/rewrite rules, or another solution.

Thanks again for taking the time to explain it so clearly.