XF 2.1 Help with MyBB import faulty BB code

[Heraldic Age]

Hi all,

I've successfully imported a large mybb forum into Xenforo and I'm quite satisfied, however my posts contain BB code in some cases which is not applicable to xenforo, such as Youtube embeds, old mentions (@"user") instead of @User, and so on. and a bunch of font size BB code.

What are SQL queries I can run to delete this content from all posts and private messages, without deleting the posts and pms themselves? So I just want to remove the faulty bb code and so on, while keeping all the posts.

 

[Paul B]

You can use this add-on to change the bb code.

Post Content Find / Replace

This is a direct port of the original Post Content Find / Replace add-on for XF 1.x. You may wish to search the original resource discussion for solutions to common tasks performed with this add-on.

xenforo.com

 

[Heraldic Age]

You can use this add-on to change the bb code.

Post Content Find / Replace

This is a direct port of the original Post Content Find / Replace add-on for XF 1.x. You may wish to search the original resource discussion for solutions to common tasks performed with this add-on.

xenforo.com

Thanks. That's great. Does this also work on PMs?

 

[Heraldic Age]

You can use this add-on to change the bb code.

Post Content Find / Replace

This is a direct port of the original Post Content Find / Replace add-on for XF 1.x. You may wish to search the original resource discussion for solutions to common tasks performed with this add-on.

xenforo.com

Doesn't seem to work unfortunately.. Briefly loads and nothing happens.

 

[FreelancerHH]

@lskm

I know I'm pretty much late. ;-)

Did you find a solution for this so far? We have the same problem (MyBB 1.8.x to XenForo 2.2.2 with Importer 1.4.0).

A simple SQL update query won't help here since XenForo 2 requires the UserID for the mention tag.