Error with Yoast Tables dont know how to resolve

So I tried a Yoast SEO Optimisation and received this error

Oops, something has gone wrong and we couldn't complete the optimization of your SEO data. Please click the button again to re-start the process.

Below are the technical details for the error. See this page for a more detailed explanation.

Error details
Error message
Error parsing the response to JSON.

Response
<div id="error"><p class="wpdberror"><strong>WordPress database error:</strong> [Table 'herroeso_db.wp_yoast_indexable' doesn't exist]<br /><code>
			SELECT term_id
			FROM wp_term_taxonomy AS T
			LEFT JOIN wp_yoast_indexable AS I
				ON T.term_id = I.object_id
				AND I.object_type = 'term'
				AND I.version = 2
			WHERE I.object_id IS NULL
				AND taxonomy IN ('category', 'post_tag', 'post_format', 'listing-category', 'features', 'list-tags', 'location', 'jag_testimonial_cat', 'jag_faq_taxonomy', 'jag_designation', 'page_cat')
			LIMIT 25</code></p></div>{"objects":[

And so i then returned to yoast help and did all the resets

Locate the Yoast SEO section and click on the ‘Reset indexables tables & migrations’, ‘Reset Prominent words calculation’, and ‘Reset Internal link counter’ buttons. After each click, the page will reload to confirm that each reset was successful. Note: Resetting the optimization doesn’t undo any of the hard work you’ve put into the plugin as the SEO data is also stored in WordPress’ default tables. It’ll just reset the custom Yoast tables that contain the combined data pulled from those default tables.

And I still have all the Table Errors nothing is fixed

Hi @spn2022,
I’m sorry to hear that you’re running into problem with Yoast SEO. To help you, we do need a bit more information from you. Can you please answer the following questions?

1. Wat problem you were trying to solve when you installed the Yoast Test Helper plugin?

2. Also, can you confirm that the database table herroeso_db.wp_yoast_indexable does exist?

Thanks!

i looked in sql manger and herroeso_db.wp_yoast_indexable does not exist

i created a new db table called herroeso_wpyoas can i point yoast to this new table?

Hi @spn2022,

I wouldn’t recommend manually creating new tables and trying to alter Yoast SEO’s code. Can you take the next steps:

1. Remove the Yoast SEO plugin from your site, either through the WP admin (really delete) or by removing it manually via FTP.
2. Reinstall Yoast SEO

Then, please confirm the following;

1. You have the latest version of Yoast SEO installed.
2. You have the latest version of Yoast Test Helper installed and activated.

Questions:
A. What happens when you try to activate Yoast SEO now?
B. If it still doesn’t work, what happens when you try to perform a reset through the Yoast Test Helper?

Thank you so much for all your replies really appreciated

OK. I deleted yoast seo plugin. And then i installed the latest version.

And i now see this

Thank you for creating with WordPress.Version 5.8.2
WordPress database error: [Table 'herroeso_db.wp_yoast_indexable' doesn't exist]
SELECT P.ID FROM wp_posts AS P WHERE P.post_type IN ('post', 'page', 'attachment', 'listing', 'jag_testimonial', 'jag_faq', 'jag_team', 'lp-ads', 'events', 'lp-reviews', 'lp-claims') AND P.post_status NOT IN ('auto-draft') AND P.ID not in ( SELECT I.object_id from wp_yoast_indexable as I WHERE I.object_type = 'post' AND I.version = 2 ) LIMIT 25

WordPress database error: [Table 'herroeso_db.wp_yoast_indexable' doesn't exist]
SELECT term_id FROM wp_term_taxonomy AS T LEFT JOIN wp_yoast_indexable AS I ON T.term_id = I.object_id AND I.object_type = 'term' AND I.version = 2 WHERE I.object_id IS NULL AND taxonomy IN ('category', 'post_tag', 'post_format', 'listing-category', 'features', 'list-tags', 'location', 'jag_testimonial_cat', 'jag_faq_taxonomy', 'jag_designation', 'page_cat') LIMIT 25

WordPress database error: [Table 'herroeso_db.wp_yoast_indexable' doesn't exist]
SELECT * FROM <code>wp_yoast_indexable</code> WHERE <code>object_type</code> = 'system-page' AND <code>object_sub_type</code> = '404' LIMIT 1

WordPress database error: [Table 'herroeso_db.wp_yoast_indexable' doesn't exist]
SELECT * FROM <code>wp_yoast_indexable</code> WHERE <code>object_type</code> = 'system-page' AND <code>object_sub_type</code> = '404' LIMIT 1

WordPress database error: [Table 'herroeso_db.wp_yoast_indexable' doesn't exist]
SELECT * FROM <code>wp_yoast_indexable</code> WHERE <code>object_type</code> = 'system-page' AND <code>object_sub_type</code> = 'search-result' LIMIT 1

WordPress database error: [Table 'herroeso_db.wp_yoast_indexable' doesn't exist]
SELECT * FROM <code>wp_yoast_indexable</code> WHERE <code>object_type</code> = 'system-page' AND <code>object_sub_type</code> = 'search-result' LIMIT 1

WordPress database error: [Table 'herroeso_db.wp_yoast_indexable' doesn't exist]
SELECT * FROM <code>wp_yoast_indexable</code> WHERE <code>object_type</code> = 'date-archive' LIMIT 1

WordPress database error: [Table 'herroeso_db.wp_yoast_indexable' doesn't exist]
SELECT * FROM <code>wp_yoast_indexable</code> WHERE <code>object_type</code> = 'date-archive' LIMIT 1

WordPress database error: [Table 'herroeso_db.wp_yoast_indexable' doesn't exist]
SELECT * FROM <code>wp_yoast_indexable</code> WHERE <code>object_type</code> = 'system-page' AND <code>object_sub_type</code> = '404' LIMIT 1

WordPress database error: [Table 'herroeso_db.wp_yoast_indexable' doesn't exist]
SELECT * FROM <code>wp_yoast_indexable</code> WHERE <code>object_type</code> = 'system-page' AND <code>object_sub_type</code> = '404' LIMIT 1

WordPress database error: [Table 'herroeso_db.wp_yoast_indexable' doesn't exist]
INSERT INTO <code>wp_yoast_indexable</code> (<code>object_type</code>, <code>object_sub_type</code>, <code>title</code>, <code>is_robots_noindex</code>, <code>blog_id</code>, <code>breadcrumb_title</code>, <code>version</code>, <code>created_at</code>, <code>updated_at</code>) VALUES ('system-page', '404', 'Page not found %%sep%% %%sitename%%', '1', '1', 'Error 404: Page not found', '1', '2021-12-25 10:40:42', '2021-12-25 10:40:42')

WordPress database error: [Table 'herroeso_db.wp_yoast_indexable' doesn't exist]
SELECT * FROM <code>wp_yoast_indexable</code> WHERE <code>object_type</code> = 'system-page' AND <code>object_sub_type</code> = 'search-result' LIMIT 1

WordPress database error: [Table 'herroeso_db.wp_yoast_indexable' doesn't exist]
SELECT * FROM <code>wp_yoast_indexable</code> WHERE <code>object_type</code> = 'system-page' AND <code>object_sub_type</code> = 'search-result' LIMIT 1

WordPress database error: [Table 'herroeso_db.wp_yoast_indexable' doesn't exist]
INSERT INTO <code>wp_yoast_indexable</code> (<code>object_type</code>, <code>object_sub_type</code>, <code>title</code>, <code>is_robots_noindex</code>, <code>blog_id</code>, <code>version</code>, <code>created_at</code>, <code>updated_at</code>) VALUES ('system-page', 'search-result', 'You searched for %%searchphrase%% %%page%% %%sep%% %%sitename%%', '1', '1', '1', '2021-12-25 10:40:42', '2021-12-25 10:40:42')

WordPress database error: [Table 'herroeso_db.wp_yoast_indexable' doesn't exist]
SELECT * FROM <code>wp_yoast_indexable</code> WHERE <code>object_type</code> = 'date-archive' LIMIT 1

WordPress database error: [Table 'herroeso_db.wp_yoast_indexable' doesn't exist]
SELECT * FROM <code>wp_yoast_indexable</code> WHERE <code>object_type</code> = 'date-archive' LIMIT 1

WordPress database error: [Table 'herroeso_db.wp_yoast_indexable' doesn't exist]
INSERT INTO <code>wp_yoast_indexable</code> (<code>object_type</code>, <code>title</code>, <code>description</code>, <code>is_robots_noindex</code>, <code>is_public</code>, <code>blog_id</code>, <code>permalink</code>, <code>version</code>, <code>created_at</code>, <code>updated_at</code>) VALUES ('date-archive', '%%date%% %%page%% %%sep%% %%sitename%%', '', '1', '0', '1', NULL, '1', '2021-12-25 10:40:42', '2021-12-25 10:40:42')

WordPress database error: [Table 'herroeso_db.wp_yoast_indexable' doesn't exist]
SELECT <code>object_sub_type</code> FROM <code>wp_yoast_indexable</code> WHERE <code>object_type</code> = 'post-type-archive' AND <code>version</code> = '2'

WordPress database error: [Table 'herroeso_db.wp_yoast_indexable' doesn't exist]
SELECT <code>object_sub_type</code> FROM <code>wp_yoast_indexable</code> WHERE <code>object_type</code> = 'post-type-archive' AND <code>version</code> = '2'

WordPress database error: [Table 'herroeso_db.wp_yoast_indexable' doesn't exist]
INSERT INTO <code>wp_yoast_indexable</code> (<code>object_type</code>, <code>object_sub_type</code>, <code>title</code>, <code>description</code>, <code>breadcrumb_title</code>, <code>permalink</code>, <code>is_robots_noindex</code>, <code>is_public</code>, <code>blog_id</code>, <code>version</code>, <code>object_published_at</code>, <code>object_last_modified</code>, <code>permalink_hash</code>, <code>created_at</code>, <code>updated_at</code>) VALUES ('post-type-archive', 'jag_testimonial', '%%pt_plural%% Archive %%page%% %%sep%% %%sitename%%', '', 'Testimonial', 'https://heroesofadventure.com/jag_testimonial/', '0', '1', '1', '2', NULL, NULL, '46:f36425f893cda360c07acca47377006b', '2021-12-25 10:40:42', '2021-12-25 10:40:42')

WordPress database error: [Table 'herroeso_db.wp_yoast_indexable' doesn't exist]
INSERT INTO <code>wp_yoast_indexable</code> (<code>object_type</code>, <code>object_sub_type</code>, <code>title</code>, <code>description</code>, <code>breadcrumb_title</code>, <code>permalink</code>, <code>is_robots_noindex</code>, <code>is_public</code>, <code>blog_id</code>, <code>version</code>, <code>object_published_at</code>, <code>object_last_modified</code>, <code>permalink_hash</code>, <code>created_at</code>, <code>updated_at</code>) VALUES ('post-type-archive', 'jag_faq', '%%pt_plural%% Archive %%page%% %%sep%% %%sitename%%', '', 'FAQ\'s', 'https://heroesofadventure.com/jag_faq/', '0', '1', '1', '2', NULL, NULL, '38:c2bb2c4cdb34d2c992892aa9de3005d0', '2021-12-25 10:40:42', '2021-12-25 10:40:42')

WordPress database error: [Table 'herroeso_db.wp_yoast_indexable' doesn't exist]
INSERT INTO <code>wp_yoast_indexable</code> (<code>object_type</code>, <code>object_sub_type</code>, <code>title</code>, <code>description</code>, <code>breadcrumb_title</code>, <code>permalink</code>, <code>is_robots_noindex</code>, <code>is_public</code>, <code>blog_id</code>, <code>version</code>, <code>object_published_at</code>, <code>object_last_modified</code>, <code>permalink_hash</code>, <code>created_at</code>, <code>updated_at</code>) VALUES ('post-type-archive', 'jag_team', '%%pt_plural%% Archive %%page%% %%sep%% %%sitename%%', '', 'Team member', 'https://heroesofadventure.com/team/', '0', '1', '1', '2', NULL, NULL, '35:ae9e969617c15ed52c0f9faaaa0bdc9d', '2021-12-25 10:40:43', '2021-12-25 10:40:43')

WordPress database error: [Table 'herroeso_db.wp_yoast_indexable' doesn't exist]
INSERT INTO <code>wp_yoast_indexable</code> (<code>object_type</code>, <code>object_sub_type</code>, <code>title</code>, <code>description</code>, <code>breadcrumb_title</code>, <code>permalink</code>, <code>is_robots_noindex</code>, <code>is_public</code>, <code>blog_id</code>, <code>version</code>, <code>object_published_at</code>, <code>object_last_modified</code>, <code>permalink_hash</code>, <code>created_at</code>, <code>updated_at</code>) VALUES ('post-type-archive', 'lp-ads', '%%pt_plural%% Archive %%page%% %%sep%% %%sitename%%', '', 'Ads', 'https://heroesofadventure.com/lp-ads/', '0', '1', '1', '2', NULL, NULL, '37:ec8c4be1e6ff4d44a09289f03b8e5450', '2021-12-25 10:40:43', '2021-12-25 10:40:43')

WordPress database error: [Table 'herroeso_db.wp_yoast_indexable' doesn't exist]
INSERT INTO <code>wp_yoast_indexable</code> (<code>object_type</code>, <code>object_sub_type</code>, <code>title</code>, <code>description</code>, <code>breadcrumb_title</code>, <code>permalink</code>, <code>is_robots_noindex</code>, <code>is_public</code>, <code>blog_id</code>, <code>version</code>, <code>object_published_at</code>, <code>object_last_modified</code>, <code>permalink_hash</code>, <code>created_at</code>, <code>updated_at</code>) VALUES ('post-type-archive', 'lp-reviews', '%%pt_plural%% Archive %%page%% %%sep%% %%sitename%%', '', 'Reviews', 'https://heroesofadventure.com/lp-reviews/', '0', '1', '1', '2', NULL, NULL, '41:7f037227545566125f0fa72cabc052cd', '2021-12-25 10:40:43', '2021-12-25 10:40:43')

WordPress database error: [Table 'herroeso_db.wp_yoast_indexable' doesn't exist]
INSERT INTO <code>wp_yoast_indexable</code> (<code>object_type</code>, <code>object_sub_type</code>, <code>title</code>, <code>description</code>, <code>breadcrumb_title</code>, <code>permalink</code>, <code>is_robots_noindex</code>, <code>is_public</code>, <code>blog_id</code>, <code>version</code>, <code>object_published_at</code>, <code>object_last_modified</code>, <code>permalink_hash</code>, <code>created_at</code>, <code>updated_at</code>) VALUES ('post-type-archive', 'lp-claims', '%%pt_plural%% Archive %%page%% %%sep%% %%sitename%%', '', 'Claims', 'https://heroesofadventure.com/lp-claims/', '0', '1', '1', '2', '2021-02-03 18:05:23', '2021-02-03 18:05:23', '40:72ec2992aa705e9b620e3c6c3ddc3515', '2021-12-25 10:40:43', '2021-12-25 10:40:43')

WordPress database error: [Table 'herroeso_db.wp_yoast_indexable' doesn't exist]
SELECT P.ID, P.post_content FROM wp_posts AS P LEFT JOIN wp_yoast_indexable AS I ON P.ID = I.object_id AND I.link_count IS NOT NULL AND I.object_type = 'post' LEFT JOIN wp_yoast_seo_links AS L ON L.post_id = P.ID AND L.target_indexable_id IS NULL AND L.type = 'internal' AND L.target_post_id IS NOT NULL AND L.target_post_id != 0 WHERE ( I.object_id IS NULL OR L.post_id IS NOT NULL ) AND P.post_status = 'publish' AND P.post_type IN ('post', 'page', 'listing', 'jag_testimonial', 'jag_faq', 'jag_team', 'lp-ads', 'events', 'lp-reviews') LIMIT 5

WordPress database error: [Table 'herroeso_db.wp_yoast_indexable' doesn't exist]
SELECT T.term_id, T.description FROM wp_term_taxonomy AS T LEFT JOIN wp_yoast_indexable AS I ON T.term_id = I.object_id AND I.object_type = 'term' AND I.link_count IS NOT NULL WHERE I.object_id IS NULL AND T.taxonomy IN ('category', 'post_tag', 'post_format', 'listing-category', 'features', 'list-tags', 'location', 'jag_testimonial_cat', 'jag_faq_taxonomy', 'jag_designation', 'page_cat') LIMIT 5

• This reply was modified 2 years, 11 months ago by spn2022.

Thank you for creating with WordPress.Version 5.8.2
WordPress database error: [Table ‘herroeso_db.wp_yoast_indexable’ doesn’t exist]
SELECT P.ID FROM wp_posts AS P WHERE P.post_type IN (‘post’, ‘page’, ‘attachment’, ‘listing’, ‘jag_testimonial’, ‘jag_faq’, ‘jag_team’, ‘lp-ads’, ‘events’, ‘lp-reviews’, ‘lp-claims’) AND P.post_status NOT IN (‘auto-draft’) AND P.ID not in ( SELECT I.object_id from wp_yoast_indexable as I WHERE I.object_type = ‘post’ AND I.version = 2 ) LIMIT 25

WordPress database error: [Table ‘herroeso_db.wp_yoast_indexable’ doesn’t exist]
SELECT term_id FROM wp_term_taxonomy AS T LEFT JOIN wp_yoast_indexable AS I ON T.term_id = I.object_id AND I.object_type = ‘term’ AND I.version = 2 WHERE I.object_id IS NULL AND taxonomy IN (‘category’, ‘post_tag’, ‘post_format’, ‘listing-category’, ‘features’, ‘list-tags’, ‘location’, ‘jag_testimonial_cat’, ‘jag_faq_taxonomy’, ‘jag_designation’, ‘page_cat’) LIMIT 25

WordPress database error: [Table ‘herroeso_db.wp_yoast_indexable’ doesn’t exist]
SELECT * FROM wp_yoast_indexable WHERE object_type = ‘system-page’ AND object_sub_type = ‘404’ LIMIT 1

WordPress database error: [Table ‘herroeso_db.wp_yoast_indexable’ doesn’t exist]
SELECT * FROM wp_yoast_indexable WHERE object_type = ‘system-page’ AND object_sub_type = ‘404’ LIMIT 1

WordPress database error: [Table ‘herroeso_db.wp_yoast_indexable’ doesn’t exist]
SELECT * FROM wp_yoast_indexable WHERE object_type = ‘system-page’ AND object_sub_type = ‘search-result’ LIMIT 1

WordPress database error: [Table ‘herroeso_db.wp_yoast_indexable’ doesn’t exist]
SELECT * FROM wp_yoast_indexable WHERE object_type = ‘system-page’ AND object_sub_type = ‘search-result’ LIMIT 1

WordPress database error: [Table ‘herroeso_db.wp_yoast_indexable’ doesn’t exist]
SELECT * FROM wp_yoast_indexable WHERE object_type = ‘date-archive’ LIMIT 1

WordPress database error: [Table ‘herroeso_db.wp_yoast_indexable’ doesn’t exist]
SELECT * FROM wp_yoast_indexable WHERE object_type = ‘date-archive’ LIMIT 1

WordPress database error: [Table ‘herroeso_db.wp_yoast_indexable’ doesn’t exist]
SELECT * FROM wp_yoast_indexable WHERE object_type = ‘system-page’ AND object_sub_type = ‘404’ LIMIT 1

WordPress database error: [Table ‘herroeso_db.wp_yoast_indexable’ doesn’t exist]
SELECT * FROM wp_yoast_indexable WHERE object_type = ‘system-page’ AND object_sub_type = ‘404’ LIMIT 1

WordPress database error: [Table ‘herroeso_db.wp_yoast_indexable’ doesn’t exist]
INSERT INTO wp_yoast_indexable (object_type, object_sub_type, title, is_robots_noindex, blog_id, breadcrumb_title, version, created_at, updated_at) VALUES (‘system-page’, ‘404’, ‘Page not found %%sep%% %%sitename%%’, ‘1’, ‘1’, ‘Error 404: Page not found’, ‘1’, ‘2021-12-25 10:40:42’, ‘2021-12-25 10:40:42’)

WordPress database error: [Table ‘herroeso_db.wp_yoast_indexable’ doesn’t exist]
SELECT * FROM wp_yoast_indexable WHERE object_type = ‘system-page’ AND object_sub_type = ‘search-result’ LIMIT 1

WordPress database error: [Table ‘herroeso_db.wp_yoast_indexable’ doesn’t exist]
SELECT * FROM wp_yoast_indexable WHERE object_type = ‘system-page’ AND object_sub_type = ‘search-result’ LIMIT 1

WordPress database error: [Table ‘herroeso_db.wp_yoast_indexable’ doesn’t exist]
INSERT INTO wp_yoast_indexable (object_type, object_sub_type, title, is_robots_noindex, blog_id, version, created_at, updated_at) VALUES (‘system-page’, ‘search-result’, ‘You searched for %%searchphrase%% %%page%% %%sep%% %%sitename%%’, ‘1’, ‘1’, ‘1’, ‘2021-12-25 10:40:42’, ‘2021-12-25 10:40:42’)

WordPress database error: [Table ‘herroeso_db.wp_yoast_indexable’ doesn’t exist]
SELECT * FROM wp_yoast_indexable WHERE object_type = ‘date-archive’ LIMIT 1

WordPress database error: [Table ‘herroeso_db.wp_yoast_indexable’ doesn’t exist]
SELECT * FROM wp_yoast_indexable WHERE object_type = ‘date-archive’ LIMIT 1

WordPress database error: [Table ‘herroeso_db.wp_yoast_indexable’ doesn’t exist]
INSERT INTO wp_yoast_indexable (object_type, title, description, is_robots_noindex, is_public, blog_id, permalink, version, created_at, updated_at) VALUES (‘date-archive’, ‘%%date%% %%page%% %%sep%% %%sitename%%’, ”, ‘1’, ‘0’, ‘1’, NULL, ‘1’, ‘2021-12-25 10:40:42’, ‘2021-12-25 10:40:42’)

WordPress database error: [Table ‘herroeso_db.wp_yoast_indexable’ doesn’t exist]
SELECT object_sub_type FROM wp_yoast_indexable WHERE object_type = ‘post-type-archive’ AND version = ‘2’

WordPress database error: [Table ‘herroeso_db.wp_yoast_indexable’ doesn’t exist]
SELECT object_sub_type FROM wp_yoast_indexable WHERE object_type = ‘post-type-archive’ AND version = ‘2’

WordPress database error: [Table ‘herroeso_db.wp_yoast_indexable’ doesn’t exist]
INSERT INTO wp_yoast_indexable (object_type, object_sub_type, title, description, breadcrumb_title, permalink, is_robots_noindex, is_public, blog_id, version, object_published_at, object_last_modified, permalink_hash, created_at, updated_at) VALUES (‘post-type-archive’, ‘jag_testimonial’, ‘%%pt_plural%% Archive %%page%% %%sep%% %%sitename%%’, ”, ‘Testimonial’, ‘https://heroesofadventure.com/jag_testimonial/’, ‘0’, ‘1’, ‘1’, ‘2’, NULL, NULL, ’46:f36425f893cda360c07acca47377006b’, ‘2021-12-25 10:40:42’, ‘2021-12-25 10:40:42’)

WordPress database error: [Table ‘herroeso_db.wp_yoast_indexable’ doesn’t exist]
INSERT INTO wp_yoast_indexable (object_type, object_sub_type, title, description, breadcrumb_title, permalink, is_robots_noindex, is_public, blog_id, version, object_published_at, object_last_modified, permalink_hash, created_at, updated_at) VALUES (‘post-type-archive’, ‘jag_faq’, ‘%%pt_plural%% Archive %%page%% %%sep%% %%sitename%%’, ”, ‘FAQ\’s’, ‘https://heroesofadventure.com/jag_faq/’, ‘0’, ‘1’, ‘1’, ‘2’, NULL, NULL, ’38:c2bb2c4cdb34d2c992892aa9de3005d0′, ‘2021-12-25 10:40:42’, ‘2021-12-25 10:40:42’)

WordPress database error: [Table ‘herroeso_db.wp_yoast_indexable’ doesn’t exist]
INSERT INTO wp_yoast_indexable (object_type, object_sub_type, title, description, breadcrumb_title, permalink, is_robots_noindex, is_public, blog_id, version, object_published_at, object_last_modified, permalink_hash, created_at, updated_at) VALUES (‘post-type-archive’, ‘jag_team’, ‘%%pt_plural%% Archive %%page%% %%sep%% %%sitename%%’, ”, ‘Team member’, ‘https://heroesofadventure.com/team/’, ‘0’, ‘1’, ‘1’, ‘2’, NULL, NULL, ’35:ae9e969617c15ed52c0f9faaaa0bdc9d’, ‘2021-12-25 10:40:43’, ‘2021-12-25 10:40:43’)

WordPress database error: [Table ‘herroeso_db.wp_yoast_indexable’ doesn’t exist]
INSERT INTO wp_yoast_indexable (object_type, object_sub_type, title, description, breadcrumb_title, permalink, is_robots_noindex, is_public, blog_id, version, object_published_at, object_last_modified, permalink_hash, created_at, updated_at) VALUES (‘post-type-archive’, ‘lp-ads’, ‘%%pt_plural%% Archive %%page%% %%sep%% %%sitename%%’, ”, ‘Ads’, ‘https://heroesofadventure.com/lp-ads/’, ‘0’, ‘1’, ‘1’, ‘2’, NULL, NULL, ’37:ec8c4be1e6ff4d44a09289f03b8e5450′, ‘2021-12-25 10:40:43’, ‘2021-12-25 10:40:43’)

WordPress database error: [Table ‘herroeso_db.wp_yoast_indexable’ doesn’t exist]
INSERT INTO wp_yoast_indexable (object_type, object_sub_type, title, description, breadcrumb_title, permalink, is_robots_noindex, is_public, blog_id, version, object_published_at, object_last_modified, permalink_hash, created_at, updated_at) VALUES (‘post-type-archive’, ‘lp-reviews’, ‘%%pt_plural%% Archive %%page%% %%sep%% %%sitename%%’, ”, ‘Reviews’, ‘https://heroesofadventure.com/lp-reviews/’, ‘0’, ‘1’, ‘1’, ‘2’, NULL, NULL, ’41:7f037227545566125f0fa72cabc052cd’, ‘2021-12-25 10:40:43’, ‘2021-12-25 10:40:43’)

WordPress database error: [Table ‘herroeso_db.wp_yoast_indexable’ doesn’t exist]
INSERT INTO wp_yoast_indexable (object_type, object_sub_type, title, description, breadcrumb_title, permalink, is_robots_noindex, is_public, blog_id, version, object_published_at, object_last_modified, permalink_hash, created_at, updated_at) VALUES (‘post-type-archive’, ‘lp-claims’, ‘%%pt_plural%% Archive %%page%% %%sep%% %%sitename%%’, ”, ‘Claims’, ‘https://heroesofadventure.com/lp-claims/’, ‘0’, ‘1’, ‘1’, ‘2’, ‘2021-02-03 18:05:23’, ‘2021-02-03 18:05:23′, ’40:72ec2992aa705e9b620e3c6c3ddc3515’, ‘2021-12-25 10:40:43’, ‘2021-12-25 10:40:43’)

WordPress database error: [Table ‘herroeso_db.wp_yoast_indexable’ doesn’t exist]
SELECT P.ID, P.post_content FROM wp_posts AS P LEFT JOIN wp_yoast_indexable AS I ON P.ID = I.object_id AND I.link_count IS NOT NULL AND I.object_type = ‘post’ LEFT JOIN wp_yoast_seo_links AS L ON L.post_id = P.ID AND L.target_indexable_id IS NULL AND L.type = ‘internal’ AND L.target_post_id IS NOT NULL AND L.target_post_id != 0 WHERE ( I.object_id IS NULL OR L.post_id IS NOT NULL ) AND P.post_status = ‘publish’ AND P.post_type IN (‘post’, ‘page’, ‘listing’, ‘jag_testimonial’, ‘jag_faq’, ‘jag_team’, ‘lp-ads’, ‘events’, ‘lp-reviews’) LIMIT 5

WordPress database error: [Table ‘herroeso_db.wp_yoast_indexable’ doesn’t exist]
SELECT T.term_id, T.description FROM wp_term_taxonomy AS T LEFT JOIN wp_yoast_indexable AS I ON T.term_id = I.object_id AND I.object_type = ‘term’ AND I.link_count IS NOT NULL WHERE I.object_id IS NULL AND T.taxonomy IN (‘category’, ‘post_tag’, ‘post_format’, ‘listing-category’, ‘features’, ‘list-tags’, ‘location’, ‘jag_testimonial_cat’, ‘jag_faq_taxonomy’, ‘jag_designation’, ‘page_cat’) LIMIT 5

Did you perform all the resets through the Yoast Test Helper plugin again while Yoast SEO is active?

Yes I did and I still received the above errors

Thank you for your help it’s really appreciated

Could you or would you be interested in looking at the error your self it may say time but I don’t know if I can ask so thanks and sorry in advance

https://okeyravi.com/create-yoast-seo-tables/

Is this fix valid? I think yoast creates more than two tables ?

I’m afraid this goes beyond what I can help you with through these forums, as this doesn’t seem to be a general problem with the Yoast Test Helper plugin, but rather an issue with Yoast SEO itself.

The best way to get help on that is through the Premium support team at Yoast. You can learn more about that on https://yoast.com/help/support/#premium.

I’m sorry I can’t help you here ??

Same issue over here as OP. I think it has something to do with PHP8.1.

Is Yoast Test helper compatible with PHP8.1?

There was nothing wrong with my Yoast SEO. I did download Yoast Test Helper and clicked on reset indexables. After that the errors showed up as OP. I had to rename Yoast Test Helper plugin. Now Yoast SEO is corrupt (even if I remove and install Yoast).

@spn2022 and @worldsdream,
Can you please confirm you’re running the RC of WordPress 5.9, as that’s the first version of WordPress with any support for PHP 8.1?

If you’re not, we strongly advise you not to switch to PHP 8.1 just yet.