Support » Plugin: Yoast Test Helper » Error with Yoast Tables dont know how to resolve

  • When using Yoast Helper Tester plugin i see this message. All was fine with Yoast now i have these errors. Not sure where to start.

    WordPress database error: [Table ‘herroeso_db.wp_yoast_indexable’ doesn’t exist]
    UPDATE wp_yoast_indexable SET prominent_words_version = NULL

    WordPress database error: [Table ‘herroeso_db.wp_yoast_prominent_words’ doesn’t exist]
    TRUNCATE TABLE wp_yoast_prominent_words

    Fatal error: Uncaught Error: Class ‘WPSEO_Options’ not found in /home/herroeso/public_html/wp-content/plugins/yoast-test-helper/src/wordpress-plugins/yoast-seo.php:156 Stack trace: #0 /home/herroeso/public_html/wp-content/plugins/yoast-test-helper/src/wordpress-plugins/yoast-seo.php(225): Yoast\WP\Test_Helper\WordPress_Plugins\Yoast_SEO->reset_prominent_words_calculation() #1 /home/herroeso/public_html/wp-content/plugins/yoast-test-helper/src/wordpress-plugins/yoast-seo.php(103): Yoast\WP\Test_Helper\WordPress_Plugins\Yoast_SEO->reset_indexables() #2 /home/herroeso/public_html/wp-content/plugins/yoast-test-helper/src/wordpress-plugin-features.php(142): Yoast\WP\Test_Helper\WordPress_Plugins\Yoast_SEO->reset_feature() #3 /home/herroeso/public_html/wp-content/plugins/yoast-test-helper/src/wordpress-plugin-features.php(104): Yoast\WP\Test_Helper\WordPress_Plugin_Features->reset_feature() #4 /home/herroeso/public_html/wp-includes/class-wp-hook.php(303): Yoast\WP\Test_Helper\WordPress_Plugin_Features->handle_reset_feature() #5 in /home/herroeso/public_html/wp-content/plugins/yoast-test-helper/src/wordpress-plugins/yoast-seo.php on line 156
    There has been a critical error on this website. Please check your site admin email inbox for instructions.

    The page I need help with: [log in to see the link]

Viewing 15 replies - 1 through 15 (of 17 total)
  • Thread Starter spn2022

    (@spn2022)

    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":[
    Thread Starter spn2022

    (@spn2022)

    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

    Plugin Support Taco Verdonschot

    (@tacoverdo)

    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!

    Thread Starter spn2022

    (@spn2022)

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

    Thread Starter spn2022

    (@spn2022)

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

    Plugin Support Taco Verdonschot

    (@tacoverdo)

    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?

    Thread Starter spn2022

    (@spn2022)

    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 7 months, 2 weeks ago by spn2022.
    Thread Starter spn2022

    (@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/&#8217;, ‘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/&#8217;, ‘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/&#8217;, ‘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/&#8217;, ‘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/&#8217;, ‘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/&#8217;, ‘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

    Plugin Support Taco Verdonschot

    (@tacoverdo)

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

    Thread Starter spn2022

    (@spn2022)

    Yes I did and I still received the above errors

    Thank you for your help it’s really appreciated

    Thread Starter spn2022

    (@spn2022)

    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

    Thread Starter spn2022

    (@spn2022)

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

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

    Plugin Support Taco Verdonschot

    (@tacoverdo)

    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).

    Plugin Support Taco Verdonschot

    (@tacoverdo)

    @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.

Viewing 15 replies - 1 through 15 (of 17 total)
  • You must be logged in to reply to this topic.