Author Topic: [bug] [forum] Most of the older links seems broken (trivial fix)  (Read 71 times)

mrd83

  • Newbie
  • *
  • Posts: 1
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:
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  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