spn2022

Forum Replies Created

Viewing 9 replies - 1 through 9 (of 9 total)
  • Forum: Plugins
    In reply to: [Yoast Test Helper] Error with Yoast Tables dont know how to resolve
    Thread Starter spn2022

    (@spn2022)

    4 years, 5 months ago

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

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

    Forum: Plugins
    In reply to: [Yoast Test Helper] Error with Yoast Tables dont know how to resolve
    Thread Starter spn2022

    (@spn2022)

    4 years, 5 months ago

    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

    Forum: Plugins
    In reply to: [Yoast Test Helper] Error with Yoast Tables dont know how to resolve
    Thread Starter spn2022

    (@spn2022)

    4 years, 5 months ago

    Yes I did and I still received the above errors

    Thank you for your help it’s really appreciated

    Forum: Plugins
    In reply to: [Yoast Test Helper] Error with Yoast Tables dont know how to resolve
    Thread Starter spn2022

    (@spn2022)

    4 years, 5 months ago

    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

    Forum: Plugins
    In reply to: [Yoast Test Helper] Error with Yoast Tables dont know how to resolve
    Thread Starter spn2022

    (@spn2022)

    4 years, 5 months ago

    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 4 years, 5 months ago by spn2022.
    Forum: Plugins
    In reply to: [Yoast Test Helper] Error with Yoast Tables dont know how to resolve
    Thread Starter spn2022

    (@spn2022)

    4 years, 5 months ago

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

    Forum: Plugins
    In reply to: [Yoast Test Helper] Error with Yoast Tables dont know how to resolve
    Thread Starter spn2022

    (@spn2022)

    4 years, 5 months ago

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

    Forum: Plugins
    In reply to: [Yoast Test Helper] Error with Yoast Tables dont know how to resolve
    Thread Starter spn2022

    (@spn2022)

    4 years, 5 months ago

    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

    Forum: Plugins
    In reply to: [Yoast Test Helper] Error with Yoast Tables dont know how to resolve
    Thread Starter spn2022

    (@spn2022)

    4 years, 5 months ago

    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":[
Viewing 9 replies - 1 through 9 (of 9 total)