Title: Database error in Multisite with version 20.5
Last modified: April 13, 2023

---

# Database error in Multisite with version 20.5

 *  Resolved [ScriptsTown](https://wordpress.org/support/users/scriptstown/)
 * (@scriptstown)
 * [3 years, 1 month ago](https://wordpress.org/support/topic/database-error-in-multisite-with-version-20-5/)
 * In Multisite with version 20.5, it shows this error:
 *     ```wp-block-code
       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](https://wordpress.org/support/users/maybellyne/)
 * (@maybellyne)
 * [3 years, 1 month ago](https://wordpress.org/support/topic/database-error-in-multisite-with-version-20-5/#post-16665467)
 * Hello [@scriptstown](https://wordpress.org/support/users/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](https://yoast.com/help/how-to-reset-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](https://wordpress.org/plugins/yoast-test-helper/)
    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](https://wordpress.org/support/users/scriptstown/)
 * (@scriptstown)
 * [3 years, 1 month ago](https://wordpress.org/support/topic/database-error-in-multisite-with-version-20-5/#post-16671512)
 * The issue remains after I have gone through these steps in Multisite.
 * There’s another recent [support thread](https://wordpress.org/support/topic/wordpress-database-error-wpcq-users-table-missing/)
   with this same error in version 20.5 (in Multisite only).
    -  This reply was modified 3 years, 1 month ago by [ScriptsTown](https://wordpress.org/support/users/scriptstown/).
 *  Plugin Support [Michael Tiña](https://wordpress.org/support/users/mikes41720/)
 * (@mikes41720)
 * [3 years, 1 month ago](https://wordpress.org/support/topic/database-error-in-multisite-with-version-20-5/#post-16671776)
 * Hi [@scriptstown](https://wordpress.org/support/users/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](https://developer.yoast.com/changelog/yoast-seo/20.5/#enhancements):
    - 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](https://github.com/Yoast/wordpress-seo/issues).
 * 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](https://yoast.com/help/how-to-write-a-good-bug-report/#utm_source=support&utm_medium=forum&utm_campaign=support-link)
   will help you submit a complete report which may result in a faster resolution.
    -  This reply was modified 3 years, 1 month ago by [Michael Tiña](https://wordpress.org/support/users/mikes41720/).

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

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

 * ![](https://ps.w.org/wordpress-seo/assets/icon-256x256.gif?rev=3419908)
 * [Yoast SEO - Advanced SEO with real-time guidance and built-in AI](https://wordpress.org/plugins/wordpress-seo/)
 * [Frequently Asked Questions](https://wordpress.org/plugins/wordpress-seo/#faq)
 * [Support Threads](https://wordpress.org/support/plugin/wordpress-seo/)
 * [Active Topics](https://wordpress.org/support/plugin/wordpress-seo/active/)
 * [Unresolved Topics](https://wordpress.org/support/plugin/wordpress-seo/unresolved/)
 * [Reviews](https://wordpress.org/support/plugin/wordpress-seo/reviews/)

 * 3 replies
 * 3 participants
 * Last reply from: [Michael Tiña](https://wordpress.org/support/users/mikes41720/)
 * Last activity: [3 years, 1 month ago](https://wordpress.org/support/topic/database-error-in-multisite-with-version-20-5/#post-16671776)
 * Status: resolved