How to fix WordPress theme {{unknown}} oembed_cache issue?

How does the begin topic resolve {{unknown}} oembed_cache?

will get new mediapeople just learnWordPress website, using the robin begin theme.

Found {{unknown}}, oembed_cache errors

OnphpMyAdminan examinationMySQL database, found a lot of errors...

post_content field, lots of errors found:{{unknown}} ▼

The `post_content` field contained numerous errors: {{unknown}}

post_type field, lots of errors found:oembed_cache ▼

The `post_type` field contained numerous errors: oembed_cache

How to find "oembed_cache,{{unknown}}" error?

OnMySQLIn the database, search for "oembed_cache" ▼

Search for "oembed_cache" in the phpMyAdmin MySQL database. 

  1. What to search for:oembed_cache
  2. Find:at least one word
  3. in the following list:select all
  4. Click "Execute"

Then, in the wp_posts data table, I searched for "oembed_cache" and found 691...

It can be seen that the robin's begin theme is a very bloated WordPress theme:

  • There is a big gap in the WordPress article ID for every 1 article updated.
  • For example: just updated an article, the article ID is 1.
  • Then within half an hour, another article was updated, and the article ID was 1.
  • The gap between 2 article IDs is 10.

Solution

Step 1: Switch to another WordPress theme (a theme not developed by Robin).

Step 2: Enter phpMyAdmin database management.

Step 3: Click on the website's MySQL database.

Step 4: Click on the wp_posts data table

Step 5: Click on the "Search" option

Step 6: Click "Find and Replace" ▼

  • Find: oembed_cache
  • Replace with: posts
  • Field: post_type

phpMyAdmin database management: Click "Find and Replace" for MySQL table fields

  • After clicking "Execute", click "Replace".

Step 7: Background settings Items per page: 100

  • enterWordPress backend, and in all articles, click Show Options in the upper right corner.
  • Set pagination in the background, the number of items per page: 100 (or more)
  • Click Apply.

Setting the number of items per page depends on the maximum loading time of your website PHP. For details, please refer to this article▼

Step 8: In all articles, search for "{{unknown}}"

Step 9: Bulk Edit Articles

After checking all the "(untitled)" articles, select the "Edit" application ▼

Batch editing of posts in the WordPress admin panel

  1. Comments: Allowed
  2. Ping Announcement: Allowed
  3. Status: Draft
  4. Click "Update"

If there are still articles to be edited in bulk, click "Next" and continue to repeat the batch editing until it is complete.

Attention points

Before operating the phpMyAdmin database, be sure to make a backup of the MySQL database, otherwise you will be responsible for the consequences.

Comment

Your email address will not be published. Required fields * Callout

Scroll to Top