AquaMail Forum

English - Android => Bug reports => Topic started by: mrd83 on June 27, 2026, 06:00:04 pm

Title: [bug] [forum] Most of the older links seems broken (trivial fix)
Post by: mrd83 on June 27, 2026, 06:00:04 pm

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 ] (https://forum.aqua-mail.com/forum/index.php?topic=5068.0)
• new ones: https://forum.aqua-mail.com/index.php?topic=5068.0 [actual link (https://forum.aqua-mail.com/index.php?topic=5068.0)]

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 (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  8)

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