Database error in Multisite with version 20.5

  • Resolved ScriptsTown

    (@scriptstown)


    3 years, 1 month ago

    In Multisite with version 20.5, it shows this error:

    WordPress database error Table 'exampledb.wp_16_users' doesn't exist for query 
			SELECT indexable_table.object_id
			FROM wp_16_yoast_indexable indexable_table
			LEFT JOIN wp_16_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\Integrations\Cleanup_Integration->clean_indexables_for_object_type_and_source_table
Viewing 3 replies - 1 through 3 (of 3 total)
  • Plugin Support Maybellyne

    (@maybellyne)

    3 years, 1 month ago

    Hello @scriptstown

    Thanks for reaching out about your WordPress database errors. We have seen unexpected issues where the previously optimized data is invalid or incomplete. We’ll start with resetting the optimization to ensure we remove invalid data. However, we know that resetting the data may sound intimidating, but our How to reset the Yoast indexables guide will walk you through the process step by step. We’ve also summarized the steps below:

    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 ScriptsTown

    (@scriptstown)

    3 years, 1 month ago

    The issue remains after I have gone through these steps in Multisite.

    There’s another recent support thread with this same error in version 20.5 (in Multisite only).

    • This reply was modified 3 years, 1 month ago by ScriptsTown.
    Plugin Support Michael Tiña

    (@mikes41720)

    3 years, 1 month ago

    Hi @scriptstown

    Thanks for confirming that the issue still occurs even after resetting the data and redoing the SEO data optimization process.

    Based on the information you’ve provided, it looks to be isolated to multisite setups on Yoast SEO 20.5. We did note an enhancement in the latest release changelog:

    • Cleans up indexables that got orphaned because posts/terms/users got deleted while Yoast SEO was deactivated.

    I suspect it may be related to the enhancement, and it may be a bug. We’re actively using the bug tracking on our GitHub repository, so your best next step would be to create a new issue for our developers here.

    You will need an account to create a new issue. Please provide as much information about the issue, including the URL to this conversation. This guide will help you submit a complete report which may result in a faster resolution.

Viewing 3 replies - 1 through 3 (of 3 total)

The topic ‘Database error in Multisite with version 20.5’ is closed to new replies.