[Solved] WordPress Yoast plugin: Table ‘wp_yoast_indexable’ doesn’t exist

Question

I migrated my WordPress website to a new domain. Before migrating, I had disabled all Plugins. After relocating, I found that the "Yoast" plugin table contained the old domain name, so I deleted all tables for the "Yoast" plugin. I reinstalled the "Yoast" plugin. But I now see an error in the error_log - Table 'wp_yoast_indexable' doesn't exist.

How can I fix this error?

Answer 1

When you install a WordPress plugin, it writes information into several tables (e.g., options table). Unfortunately, all those information is not deleted when you delete the plugin.
When installing the "Yoast" plugin, it adds four tables to the database and writes some information into other WP tables, too. When you deleted the "Yoast" table, did you delete "Yoast" related information from other tables? If not, reinstalling "Yoast" will give the error.

Fortunately, there is a solution to this error. Do the following to fix the error:

1. Log into the WP as admin and go to the admin dashboard.
2. Install the "Yoast Test Helper" plugin.
3. Go to "Tools" and select "Yoast Test".
4. Find the button "Reset indexables tables & migrations" and click it.

These steps should reset the needed tables and fix the error.