How can I carry out an automatic search of all pages/posts on my site for any content embedded using oEmbed (preferably Facebook/Instagram content)?
The reason I ask is because this WPBeginner post says that on October 24th, all Facebook or Instagram content embedded on a site using oEmbed will be deprecated, and such content will be (slightly) broken. I’d like to first determine how much oEmbed content I have on my site. My site is has a relatively large amount of pages/posts (content added by others), so manually searching each will be a bit tedious.
Would I perhaps need to carry out a database search? Or a text search through all the files?
FYI my site uses Classic Editor throughought–not Gutenberg.
Thanks.
Answers:
Thank you for visiting the Q&A section on Magenaut. Please note that all the answers may not help you solve the issue immediately. So please treat them as advisements. If you found the post helpful (or not), leave a comment & I’ll get back to you as soon as possible.
Method 1
In case anyone else wants to know the answer, I was able to find it elsewhere. If you run this SQL query on your database:
SELECT * FROM wp_postmeta WHERE (meta_value LIKE '%facebook%') OR (meta_value LIKE '%instagram%')
the search results will contain, in-part, a list of all posts with FB/IG oEmbed content. You may have to change the prefix wp_ to whatever prefix matches your database (I had to). And you also may have to specify your database name in the query. I tested that query and it indeed works as advertised. I’m also told that this SQL query might contain only a list of all posts with FB/IG oEmbed content (but I haven’t tested it):
SELECT * FROM wp_postmeta WHERE (meta_value LIKE '%fb-root%') OR (meta_value LIKE '%instagram-media%')
One last thing is that the SQL query results indicated that my site had one post with FB oEmbed content. But when I opened that post, it didn’t contain any rich oEmbed content (i.e. content described in this article, e.g. nice image, nice icon, nice text formatting, etc) All that exists on the page is a standard link to a Facebook page (screenshot). Because of this, I took no action to fix the issue–based on the description of the issue, this particular content will be unaffected.
See this post on the WordPress forums for more info.
All methods was sourced from stackoverflow.com or stackexchange.com, is licensed under cc by-sa 2.5, cc by-sa 3.0 and cc by-sa 4.0