XF 1.3 Trying to run a SQL query for youtube links

[dawg]

I have already tried the find and replace and is not working for me since i have thousands and thousands of video links. I tried the example code to load 5000 at a time but it degrades over time and you are saving 20 videos at a time. I just dont have the time.


I just want to fix youtube nothing else. I tries this SQL query but nothing. The variable is stumping me.

UPDATE xf_post SET message = REPLACE(message,'#\[video=youtube;([^\]]+)\]([^\[]+)\[/video\]#siU','[media=youtube]');

Any help would be appreciated.

 

[caliman]

Here you go:
http://xenforo.com/community/threads/bbcode-youtube-embeds.60297/#post-641423

 

[dawg]

Here you go:
http://xenforo.com/community/threads/bbcode-youtube-embeds.60297/#post-641423

Already tried that. I get:

 0 rows affected. (Query took 24.8778 sec)

Not sure what to do from here.

 

[caliman]

It's probably upper case - change youtube to YOUTUBE.

 

[dawg]

It's probably upper case - change youtube to YOUTUBE.

But i dont see how that command will fix a link like this one.

[video=youtube;-pzXyOWa7dg]http://www.youtube.com/watch?v=-pzXyOWa7dg[/video]

Doesn't work lower or upper case. I think we need some kind of variable but I'm no expert.

 

[caliman]

That doesn't look like stock vB video code. At least 3.8. I don't recognize that format.

 

[dawg]

That doesn't look like stock vB video code. At least 3.8. I don't recognize that format.

Yeah it's Vbulletin 4 leftover code.

 

[Jake Bunce]

Instructions for your replacement:

http://xenforo.com/community/threads/video-code-after-import.24280/#post-297772

 

[dawg]

Instructions for your replacement:

http://xenforo.com/community/threads/video-code-after-import.24280/#post-297772

Hi jake i tried that tool for hours with no success. I found your snipet of code where you can limit the amount of instances it looks for but i have

162132 matches in xf_post

It would take me a month. When i try more than a couple of thousand i get a memory time out.