Support » Plugin: Yoast SEO » WordPress database error Table

WordPress database error Table

  • Resolved nikkins82

    (@nikkins82)


    9 months, 2 weeks ago

    Updating from 13.3 to 14.4.1 in a local development environment for a multisite with 7 subthemes.

    I get the output below in the wp debug log after refreshing the site after the manual update. I have not clicked on the button “Start processing and speed up your site now” to re-index the subtheme yet.

    Looking for guidance on how to proceed. Thanks!

    [06-Jul-2020 19:57:07 UTC] WordPress database error Table 'blogs.wp_7_yoast_indexable' doesn't exist for query UPDATE wp_7_yoast_indexable SET permalink = NULL WHERE object_type = 'post' AND object_sub_type = 'attachment' made by require_once('wp-admin/admin.php'), require_once('wp-load.php'), require_once('/app/web/wp-config.php'), require_once('wp-settings.php'), do_action('plugins_loaded'), WP_Hook->do_action, WP_Hook->apply_filters, wpseo_init, WPSEO_Upgrade->__construct, array_walk, WPSEO_Upgrade->run_upgrade_routine, WPSEO_Upgrade->upgrade_141, WPSEO_Upgrade->reset_permalinks_of_attachments_for_141

Viewing 6 replies - 1 through 6 (of 6 total)
  • Plugin Support Michael Tina

    (@mikes41720)

    9 months, 2 weeks ago

    Hello,

    Can you confirm you are also using the latest version of WordPress 5.4.2, as well as the rest of your plugins and themes?

    If you try to run the Indexables ‘speed up your site’ feature, does this resolve the issue?

    Thread Starter nikkins82

    (@nikkins82)

    9 months, 2 weeks ago

    Hello and thanks for your quick reply. Yes all dependencies and WP Core are up to date.

    The output shared above is served immediately after updating the plugin to 14.4.1. If I run the re-indexing, WordPress database error Table output does not reappear after refreshing the site /or purging the cache. Is the issue resolved if the output does not reappear??

    When I try to update with previous versions, such as 14.3, I do not receive this output.

    I also did not receive the same output while updating other standalone WP installations to 14.4.1. Could this possibly be a multisite issue with the latest update?

    * My concern is the negative effect that this update could potentially cause to our 4k+ blog posts that maintain our google ranking – basing this on previous Yoast reviews/support requests with the unfortunatly bumpy 14.0 release.

    Thanks!

    • This reply was modified 9 months, 2 weeks ago by nikkins82.
    Plugin Support Jeroen Rotty

    (@jeroenrotty)

    9 months, 2 weeks ago

    Hi @nikkins82,

    Thank you for your reply and details.

    We expect that when you run the re-indexing without any error message or notice on the Tools page, it runs as it should and it can complete. Do you see a green checkmark after the re-indexing on the SEO → Tools → SEO Data?

    Thread Starter nikkins82

    (@nikkins82)

    9 months, 2 weeks ago

    Hi @jeroenrotty Yes, checkmarks are green after re-indexing for all subthemes in the multisite. The wp debug log does not display an error after as well.

    If you are suggesting that the plugin update should not negative affect our website, could help me interrupt what the original output means to better understand and for future reference?

    Thanks again!

    [06-Jul-2020 19:57:07 UTC] WordPress database error Table 'blogs.wp_7_yoast_indexable' doesn't exist for query UPDATE wp_7_yoast_indexable SET permalink = NULL WHERE object_type = 'post' AND object_sub_type = 'attachment' made by require_once('wp-admin/admin.php'), require_once('wp-load.php'), require_once('/app/web/wp-config.php'), require_once('wp-settings.php'), do_action('plugins_loaded'), WP_Hook->do_action, WP_Hook->apply_filters, wpseo_init, WPSEO_Upgrade->__construct, array_walk, WPSEO_Upgrade->run_upgrade_routine, WPSEO_Upgrade->upgrade_141, WPSEO_Upgrade->reset_permalinks_of_attachments_for_141

    Plugin Support Jeroen Rotty

    (@jeroenrotty)

    9 months, 2 weeks ago

    Hi @nikkins82,

    Thank you for your reply. We understand the concern. We just did a local test by installing the plugin manually on a multisite and we get the same error notification you mentioned. However, this is due to the design of how updates manually install, this does not have any (negative) impact.

    When you see that the subsites have the green checkmark under the SEO data, this is just fine and the metadata is copied over to the Yoast indexable database table. This error is not expected to show up again at any time.

    Thread Starter nikkins82

    (@nikkins82)

    9 months, 2 weeks ago

    Great, I will proceed with the update.

    I appreciate your quick response and the extra steps taken to troubleshoot on your end.

Viewing 6 replies - 1 through 6 (of 6 total)
  • The topic ‘WordPress database error Table’ is closed to new replies.

Views