XF 1.4 vBulletin import - can I change YouTube BBcodes via SQL?

[compactabt]

Hi!

I've imported a fairly large (3.5m post) forum from vBulletin 4 to XenForo.

Everything seems to have gone alarmingly smoothly but I'm stuck on two points. One I'll deal with in another post, but for the YouTube embeds, I'm struggling with solutions offered elsewhere on this forum.

In imported messages, a YouTube embed looks like this:

[video=youtube;r_rbWytPvEs][MEDIA=youtube]r_rbWytPvEs[/MEDIA]

But it needs to look like this:

[media=youtube]http://www.youtube.com/watch?v=r_rbWytPvEs[/media]

I've tried the steps suggested here but I either get a blank screen or I'll click the button and the page will simply refresh, having not done anything.

Is there any way I can get this done with an SQL query or two? It's the YouTube ID in the opening code that's the tricky bit - is it possible to use some sort of wildcard?

Thanks in advance!

 

[0ptima]

Go through this thread and install the addon, you may find the regex you are looking for.

https://xenforo.com/community/threads/post-content-find-replace.6548/

 

[Jake Bunce]

Here are specific instructions for your replacement:

https://xenforo.com/community/threads/video-code-after-import.24280/

Note that the example you posted appears to have been auto-parsed by XF as if you edited and saved that post after the import. Those posts that have been manually edited won't be matched by these instructions and will need to be manually fixed.

 

[compactabt]

Thanks both for your help - I've sorted out the parsing problem and also got the find and replace add-on working.

(The problem was the size of the forum - following Jake's advice here https://xenforo.com/community/threads/import-from-ipb-3-2-posts-not-parsed-at-all.39577/#post-435226 seems to be what did the trick.)