1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

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

Discussion in 'Troubleshooting and Problems' started by compactabt, Mar 14, 2015.

  1. compactabt

    compactabt Member

    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:

    Code:
    [video=youtube;r_rbWytPvEs][MEDIA=youtube]r_rbWytPvEs[/MEDIA]
    But it needs to look like this:

    Code:
    [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!
     
  2. 0ptima

    0ptima Well-Known Member

  3. Jake Bunce

    Jake Bunce XenForo Moderator Staff Member

    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.
     
  4. compactabt

    compactabt Member

Share This Page