Query to Reset BB Code Media Sites

[Chris D]

Chris Deeming submitted a new resource:

Query to reset BB Code Media Sites - Reset the BB Code Media Sites to default

TRUNCATE xf_bb_code_media_site;

INSERT INTO xf_bb_code_media_site
    (media_site_id, site_title, site_url, match_urls, embed_html, match_is_regex)
VALUES
    ('facebook', 'Facebook', 'http://www.facebook.com', 'facebook.com/*video.php?v={$id:digits}\nfacebook.com/*photo.php?v={\$id:digits}', '<iframe src="https://www.facebook.com/video/embed?video_id={$id}" width="500" height="300" frameborder="0"></iframe>', 0),
    ('vimeo', 'Vimeo', 'http://www.vimeo.com',...

Read more about this resource...

 

[DRE]

Thank you for this query! This resource came in handy because I have a site full of non-embedded YouTube links due to a seriously annoying Xenforo 1.3 bug explained in detail here. I was not able to embed videos in XenMediaGallery due to deleting my youtube bb media site and not being able to re-add it.

I asked you about this issue here because it took too long for my post to be approved. You told me to run this query. I ran the query with Querier by @euantor and it didn't work so I went to my phpmyadmin and ran it there. It appeared nothing had changed as youtube videos in my thread still would not show. That's probably due to that Xenforo 1.3 bug. As an experiment, I created a new album and tried adding a youtube video and it worked. So you solved my XenMediaGallery problem as well thank you.

 

[Chris D]

Chris Deeming updated Query to reset BB Code Media Sites with a new update entry:

Rebuild the BB Code Media Cache

Added to the main guide:

In case you add these and see no effect, it probably means the BB Codes are cached.

If that is the case, this query may help:

DELETE FROM xf_data_registry WHERE data_key = 'bbCode'

Read the rest of this update entry...

 

[DRE]

Tried that and the query said '1 row deleted' but I still don't see any videos in threads. Is it my browser?

 

[Chris D]

Hmm

Only other thing I can think of is the bbcode parse cache.

If that's enabled switch it off by setting it to 0.

 

[DRE]

Where do I do that at?

 

[rdn]

Is the code up to date with XF 1.5.22?
Thanks!