I have been here for over a decade as a reader. I guess I'm finally perplexed and need help.
So, I have had a vbulletin forum for 17 years and now I imported it to Xenforo. Everything was good.
The problem is; I have 1.5 thousand posts and 22k of them contain links from different places in the forum.
Basically, see links here when someone in the past hit a link directing something to find something.
If someone reads the old posts and clicks on a link, they will go to page 404 not found.
These links must be edited in Xenforo format
If only I could somehow remove the thread tag on the old vb4 links
Then, after that, I can simply use a simple SQL update query to fix the rest.
So, I have 22k links in the posts table, all with different ID # and different tags.
Each tag starts with a script –
If someone is kind enough to help me, write me a regular expression or a complex sql command that removes all the final tags that come after the thread ID.
Both thread identification and tags will be different from one link to another, of course.
The only consistency is the hyphen, before the tag and the backslash after the tag. The backslash is only seen in the data table.
Here is an exact copy of the previous sample link copied from the sql table, the final backslash can be useful
Centos7 / mysql57
db table: xf_post
db index: message
Thanks to anyone who helps