Querying non-existant DB table in Multisite

  • Hi, I noticed the following error in the PHP error log. It is coming from site #3 running in a WP Multisite and Yoast SEO seems to be looking for the sub-site users table, which obviously is not there. The plugin is activated per sub-site, not network wide…

    WordPress database error Table 'xxx.xxx_3_users' doesn't exist for query 
			SELECT indexable_table.object_id
			FROM wpx8_3_yoast_indexable indexable_table
			LEFT JOIN wpx8_3_users AS source_table
			ON indexable_table.object_id = source_table.ID
			WHERE source_table.ID IS NULL
			AND indexable_table.object_id IS NOT NULL
			AND indexable_table.object_type = 'user'
			LIMIT 1000 made by do_action_ref_array('wpseo_start_cleanup_indexables'), WP_Hook->do_action, WP_Hook->apply_filters, Yoast\WP\SEO\Integrations\Cleanup_Integration->run_cleanup, Yoast\WP\SEO\Integrations\Cleanup_Integration->Yoast\WP\SEO\Integrations\{closure}, Yoast\WP\SEO\Repositories\Indexable_Cleanup_Repository->clean_indexables_for_object_type_and_source_table

    No idea what triggered this error but it does not feel good. Can this be fixed? Or is Yoast SEO incompatible with WP Network / Multiste installations?

Viewing 4 replies - 1 through 4 (of 4 total)
  • Plugin Support Maybellyne

    (@maybellyne)

    Hello Rolf,

    Thanks for reaching out about the WordPress database error. Of course, the Yoast SEO plugin is compatible with the WordPress multisite setup. On the affected subsite, please try the following:

    1. Install & activate the Yoast Test Helper plugin
    2. Go to Tools > Yoast Test
    3. 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 the specific reset was successful.
    4. Go to SEO > Tools, and under SEO data, click the “Start SEO data optimization” button to allow Yoast to rescan your content.

    Please let us know if the reported issue remains after resetting the optimized data.

    Thread Starter Rolf Allard van Hagen

    (@ravanh)

    Hi @maybellyne during step 3 I get these type of errors in the PHP log file (for each subsite that has Yoast activated) :

    [03-Jul-2023 14:05:59 UTC] WordPress database error Table 'XXX.wpx8_X_yoast_prominent_words' doesn't exist for query TRUNCATE TABLE wpx8_X_yoast_prominent_words made by do_action('admin_post_wordpress-seo-feature-reset'), WP_Hook->do_action, WP_Hook->apply_filters, Yoast\WP\Test_Helper\WordPress_Plugin_Features->handle_reset_feature, Yoast\WP\Test_Helper\WordPress_Plugin_Features->reset_feature, Yoast\WP\Test_Helper\WordPress_Plugins\Yoast_SEO->reset_feature, Yoast\WP\Test_Helper\WordPress_Plugins\Yoast_SEO->reset_prominent_words_calculation
[03-Jul-2023 14:06:07 UTC] WordPress database error Table 'XXX.wpx8_4_yoast_prominent_words' doesn't exist for query TRUNCATE TABLE wpx8_X_yoast_prominent_words made by do_action('admin_post_wordpress-seo-feature-reset'), WP_Hook->do_action, WP_Hook->apply_filters, Yoast\WP\Test_Helper\WordPress_Plugin_Features->handle_reset_feature, Yoast\WP\Test_Helper\WordPress_Plugin_Features->reset_feature, Yoast\WP\Test_Helper\WordPress_Plugins\Yoast_SEO->reset_feature, Yoast\WP\Test_Helper\WordPress_Plugins\Yoast_SEO->reset_indexables, Yoast\WP\Test_Helper\WordPress_Plugins\Yoast_SEO->reset_prominent_words_calculation
    Plugin Support Maybellyne

    (@maybellyne)

    I’m sorry the error persists, @ravanh.

    Our developers are aware of this behavior and there’s an open bug report to investigate further and provide a lasting resolution. If you have any further information that may help our development team solve this bug, please leave a comment or subscribe to the GitHub report to get updates on the issue.

    Thread Starter Rolf Allard van Hagen

    (@ravanh)

    Hi @maybellyne thanks ??

Viewing 4 replies - 1 through 4 (of 4 total)
  • The topic ‘Querying non-existant DB table in Multisite’ is closed to new replies.