XF 2.2 post migration link problem

[htsumer]

I moved the forum. This is how the links come out after moving



when i edit and delete the URL tags and save, it gets fixed





how can i refresh the whole forum

 

[Paul B]

To update URLs in posts, you can use the post replace add-on, or if all of the URLs have a common string, you can run a simple query:

UPDATE xf_post SET message = REPLACE(message, 'original_content', 'new_content');

Ensure you make any changes to a test installation first, before trying it on your live site.

 

[htsumer]

does this only affect xf_post?
I'm just asking because I'm going to make a backup of xf_post. No test site

 

[htsumer]

unfortunately it didn't happen



I refreshed the page

 

[Paul B]

You need to replace original_content and new_content in the query as required.

For example, if you moved the forum from /community to /forums, you would use:

UPDATE xf_post SET message = REPLACE(message, 'https://example.com/community', 'https://example.com/forums');

 

[htsumer]

sorry i don't understand

 

[htsumer]

You need to replace original_content and new_content in the query as required.

For example, if you moved the forum from /community to /forums, you would use:

'UPDATE xf_post SET message = REPLACE(message, 'https://example.com/community', 'https://example.com/forums');

I moved from x domain to y domain

 

[Paul B]

Then adjust the query and add the old and new domain as shown in the example above.

 

[htsumer]

I moved maasmutemeti.com from maasmutemetleri.net. Separate hosts

 

[Paul B]

If the site was moved from .net to .com:

UPDATE xf_post SET message = REPLACE(message, 'maasmutemetleri.net', 'maasmutemeti.com');

 

[htsumer]

There is no problem with the links in the content, I changed all of them from the database. The links are currently not old links of your own site. Do I need to run the query in this case too? My point is that the links look plain. I want it like this

 

[Paul B]

I misunderstood.

What happens when you test unfurling in the ACP - /admin.php?tools/test-url-unfurling ?

Is any error returned?

 

[htsumer]

Hayır

 

[Chromaniac]

I wonder if it's safe enough to find and replace [URL] to [URL unfurl="true"].

 

[Paul B]

I'm still not clear on what the actual issue is.

When you post a URL for your own site, does it fail to unfurl even though unfurl="true" is present in the bb code?

If so, that's likely going to be a server config issue.

 

[htsumer]

links open. The problem is that the url remains. Editing it is fixed.

View attachment 2021-09-03 16-37-49_Trim.mp4

 

[Chromaniac]

these links should fix with time as xenforo would clear cache periodically. though i have noticed a weird behavior with links on my board as well. this makes me believe that these links might not get fixed automatically with time because of some unusual behavior with xenforo.

for instance i create a link like this:

https://xenforo.com/community/threads/post-migration-link-problem.197848/#post-1534478

and post the thread. it would unfurl fine.

if i edit the post and remove the last bit #post-1534478, xenforo would ignore the link change. but if i post a clean link, it would be processed just fine. this makes no logic as the link was changed through editing and it should have unfurled on editing. but somehow it doesn't.

one possible way to re-unfurl all links would be to truncate the unfurl table in database (DO NOT DO THIS LOL. XenForo does not refresh links historically it seems.). i haven't personally tried it because i have a feeling that it would kill all unfurled urls and they would not be processed again.

I thought this was connected to Cache BB Code output setting but it seems to have died with xenforo 1.x.

 

[Chromaniac]

So it seems like URLs only unfurled if they are processed by the XenForo editor. They are added to the database. Never removed. I can still see the first URL I tried after updating to the version that added support for unfurling URLs. Cleaning that table basically killed all unfurled URLs. I am still not sure why XenForo ignores any editing in an existing URL. It should be treated as a fresh link because there is no identifier in the code.

 

[htsumer]

This could be what's causing the error.
I replaced all url in database with find replace. That's how I loaded the database. Changing thousands of old urls due to migration can only be done from the database.

 

[Chromaniac]

yeah. i am not sure if it has been reported as a bug before. this is something that xenforo developers should know as it seems to be by design. though i still do not get why the link does not get updated if i edit an existing link. would post it as a bug and see if it gets a response.

Not a bug - Two issues related to unfurling URLs

First one is really weird. Here is what happens. I post a link in a post. I publish the post. Link is unfurled. I edit the post and edit just the link bit. Publish the post. Updated link appears as linked url and does not get unfurled. I am not sure why XenForo does not update the URL on...

xenforo.com