XF 1.2 BBcode YouTube embeds

[Vidmarc]

Since importing from vB4, all of our YouTube embedded videos are appearing like this:

[YOUTUBE]8_ocrenOCPo[/YOUTUBE]

Any suggestions as to how to fix it?

 

[Jeremy]

You'll need to either edit the post or use Kier's post replacement tool to replace all instances in the database.

 

[Vidmarc]

Thanks - where can I find the replacement BBcode tool?

 

[Jeremy]

http://xenforo.com/community/resources/post-content-find-replace.1549/

 

[Paul B]

For simple content such as that, you can use an SQL query, which is what I did.

UPDATE xf_post SET message = REPLACE(message,'current_content','new_content');

Take a backup first though.

 

[Vidmarc]

No idea what I need to do to replace those BB codes. Can anybody help please?

I guess I need to search for the first and last parts of the code and replace these?

[YOUTUBE]

[/YOUTUBE]

 

[Paul B]

UPDATE xf_post SET message = REPLACE(message,'[YOUTUBE]','[media=youtube]');

UPDATE xf_post SET message = REPLACE(message,'[/YOUTUBE]','[/media]');

Rebuild the search index once done.

 

[Vidmarc]

Thanks, what field do I add these to?

Quick Find
Regular expression
Replacement String

 

[Paul B]

As I mentioned in my earlier post, you can enter those as direct SQL queries in phpMyAdmin, rather than use the add-on.

 

[Vidmarc]

I've no idea about phpMyAdmin, would rather use the add on tool.

 

[Jeremy]

http://xenforo.com/community/threads/post-content-find-replace.6548/page-16#post-611439

 

[Vidmarc]

"Please enter a message with no more than 5 pieces of media."

Any clues?

 

[Jeremy]

You'll need to either up the user group permissions or modify the option (I forget which one media is defined in).