Title: Missing tables in database Last modified: October 28, 2023 --- # Missing tables in database * Resolved [breegeek](https://wordpress.org/support/users/breegeek/) * (@breegeek) * [2 years, 7 months ago](https://wordpress.org/support/topic/missing-tables-in-database-3/) * Please help and Thanks in Advance (I’m losing my mind over this) * I’m having trouble with a Gelato plugin on my site that’s supposed to integrate with WooCommerce. The plugin fails to connect with Woocommerce no matter how many times I try to reinstall the plugin, troubleshoot other plugins, etc. * After spending hours with the (very helpful) support team, I think the issue is potentially with WooCommerce. I looked at the status page and saw an error under the database section that I don’t understand: wp-admin/admin.php?page=wc- status * Then it shows * ```wp-block-code Database  Missing base tables: wp_wc_orders, wp_wc_orders_meta. Some WooCommerce functionality may not work as expected.WooCommerce database version:8.2.1Database prefix wp_Total Database Size 15.19MBDatabase .. ``` * so forth and so on… * I don’t know what the missing tables are or how to fix it. * In addition, I got the logs under the status block: * ```wp-block-code ` ### WordPress Environment ### WordPress address (URL): https://breemakesart.com Site address (URL): https://breemakesart.com WC Version: 8.2.1 REST API Version: ✔ 8.2.1 WC Blocks Version: ✔ 11.1.2 Action Scheduler Version: ✔ 3.6.4 Log Directory Writable: ✔ WP Version: 6.3.2 WP Multisite: – WP Memory Limit: 256 MB WP Debug Mode: – WP Cron: ✔ Language: en_US External object cache: – ### Server Environment ### Server Info: Apache PHP Version: 8.1.24 PHP Post Max Size: 8 MB PHP Time Limit: 30 PHP Max Input Vars: 1000 cURL Version: 7.87.0 OpenSSL/1.1.1w SUHOSIN Installed: – MySQL Version: 5.7.43-cll-lve Max Upload Size: 2 MB Default Timezone is UTC: ✔ fsockopen/cURL: ✔ SoapClient: ❌ Your server does not have the SoapClient class enabled - some gateway plugins which use SOAP may not work as expected. DOMDocument: ✔ GZip: ✔ Multibyte String: ✔ Remote Post: ✔ Remote Get: ✔ ### Database ### WC Database Version: 8.2.1 WC Database Prefix: wp_ Total Database Size: 15.19MB Database Data Size: 12.91MB Database Index Size: 2.28MB wp_woocommerce_sessions: Data: 0.04MB + Index: 0.00MB + Engine MyISAM wp_woocommerce_api_keys: Data: 0.00MB + Index: 0.01MB + Engine MyISAM wp_woocommerce_attribute_taxonomies: Data: 0.00MB + Index: 0.00MB + Engine MyISAM wp_woocommerce_downloadable_product_permissions: Data: 0.00MB + Index: 0.00MB + Engine MyISAM wp_woocommerce_order_items: Data: 0.00MB + Index: 0.00MB + Engine MyISAM wp_woocommerce_order_itemmeta: Data: 0.00MB + Index: 0.00MB + Engine MyISAM wp_woocommerce_tax_rates: Data: 0.00MB + Index: 0.00MB + Engine MyISAM wp_woocommerce_tax_rate_locations: Data: 0.00MB + Index: 0.00MB + Engine MyISAM wp_woocommerce_shipping_zones: Data: 0.00MB + Index: 0.00MB + Engine MyISAM wp_woocommerce_shipping_zone_locations: Data: 0.00MB + Index: 0.00MB + Engine MyISAM wp_woocommerce_shipping_zone_methods: Data: 0.00MB + Index: 0.00MB + Engine MyISAM wp_woocommerce_payment_tokens: Data: 0.00MB + Index: 0.00MB + Engine MyISAM wp_woocommerce_payment_tokenmeta: Data: 0.00MB + Index: 0.00MB + Engine MyISAM wp_woocommerce_log: Data: 0.00MB + Index: 0.00MB + Engine MyISAM wp_actionscheduler_actions: Data: 1.96MB + Index: 0.57MB + Engine MyISAM wp_actionscheduler_claims: Data: 0.00MB + Index: 0.00MB + Engine MyISAM wp_actionscheduler_groups: Data: 0.00MB + Index: 0.01MB + Engine MyISAM wp_actionscheduler_logs: Data: 0.88MB + Index: 0.69MB + Engine MyISAM wp_commentmeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB wp_comments: Data: 0.02MB + Index: 0.09MB + Engine InnoDB wp_gg_attributes: Data: 0.00MB + Index: 0.00MB + Engine MyISAM wp_gg_galleries: Data: 0.00MB + Index: 0.00MB + Engine MyISAM wp_gg_galleries_resources: Data: 0.00MB + Index: 0.00MB + Engine MyISAM wp_gg_photos: Data: 0.00MB + Index: 0.00MB + Engine MyISAM wp_gg_settings_sets: Data: 0.00MB + Index: 0.00MB + Engine MyISAM wp_gg_tags: Data: 0.00MB + Index: 0.00MB + Engine MyISAM wp_links: Data: 0.02MB + Index: 0.02MB + Engine InnoDB wp_mailpoet_automations: Data: 0.00MB + Index: 0.00MB + Engine MyISAM wp_mailpoet_automation_runs: Data: 0.00MB + Index: 0.00MB + Engine MyISAM wp_mailpoet_automation_run_logs: Data: 0.00MB + Index: 0.00MB + Engine MyISAM wp_mailpoet_automation_run_subjects: Data: 0.00MB + Index: 0.00MB + Engine MyISAM wp_mailpoet_automation_triggers: Data: 0.00MB + Index: 0.00MB + Engine MyISAM wp_mailpoet_automation_versions: Data: 0.00MB + Index: 0.00MB + Engine MyISAM wp_mailpoet_custom_fields: Data: 0.00MB + Index: 0.00MB + Engine MyISAM wp_mailpoet_dynamic_segment_filters: Data: 0.00MB + Index: 0.00MB + Engine MyISAM wp_mailpoet_feature_flags: Data: 0.00MB + Index: 0.00MB + Engine MyISAM wp_mailpoet_forms: Data: 0.00MB + Index: 0.00MB + Engine MyISAM wp_mailpoet_log: Data: 0.02MB + Index: 0.00MB + Engine MyISAM wp_mailpoet_migrations: Data: 0.00MB + Index: 0.01MB + Engine MyISAM wp_mailpoet_newsletters: Data: 0.02MB + Index: 0.01MB + Engine MyISAM wp_mailpoet_newsletter_links: Data: 0.00MB + Index: 0.00MB + Engine MyISAM wp_mailpoet_newsletter_option: Data: 0.00MB + Index: 0.00MB + Engine MyISAM wp_mailpoet_newsletter_option_fields: Data: 0.00MB + Index: 0.01MB + Engine MyISAM wp_mailpoet_newsletter_posts: Data: 0.00MB + Index: 0.00MB + Engine MyISAM wp_mailpoet_newsletter_segment: Data: 0.00MB + Index: 0.00MB + Engine MyISAM wp_mailpoet_newsletter_templates: Data: 1.04MB + Index: 0.00MB + Engine MyISAM wp_mailpoet_scheduled_tasks: Data: 0.03MB + Index: 0.01MB + Engine MyISAM wp_mailpoet_scheduled_task_subscribers: Data: 0.01MB + Index: 0.01MB + Engine MyISAM wp_mailpoet_segments: Data: 0.00MB + Index: 0.01MB + Engine MyISAM wp_mailpoet_sending_queues: Data: 0.00MB + Index: 0.00MB + Engine MyISAM wp_mailpoet_settings: Data: 0.01MB + Index: 0.00MB + Engine MyISAM wp_mailpoet_statistics_bounces: Data: 0.00MB + Index: 0.00MB + Engine MyISAM wp_mailpoet_statistics_clicks: Data: 0.00MB + Index: 0.00MB + Engine MyISAM wp_mailpoet_statistics_forms: Data: 0.00MB + Index: 0.00MB + Engine MyISAM wp_mailpoet_statistics_newsletters: Data: 0.00MB + Index: 0.00MB + Engine MyISAM wp_mailpoet_statistics_opens: Data: 0.00MB + Index: 0.00MB + Engine MyISAM wp_mailpoet_statistics_unsubscribes: Data: 0.00MB + Index: 0.00MB + Engine MyISAM wp_mailpoet_statistics_woocommerce_purchases: Data: 0.00MB + Index: 0.00MB + Engine MyISAM wp_mailpoet_stats_notifications: Data: 0.00MB + Index: 0.00MB + Engine MyISAM wp_mailpoet_subscribers: Data: 0.00MB + Index: 0.02MB + Engine MyISAM wp_mailpoet_subscriber_custom_field: Data: 0.00MB + Index: 0.00MB + Engine MyISAM wp_mailpoet_subscriber_ips: Data: 0.00MB + Index: 0.00MB + Engine MyISAM wp_mailpoet_subscriber_segment: Data: 0.00MB + Index: 0.00MB + Engine MyISAM wp_mailpoet_subscriber_tag: Data: 0.00MB + Index: 0.00MB + Engine MyISAM wp_mailpoet_tags: Data: 0.00MB + Index: 0.00MB + Engine MyISAM wp_mailpoet_user_agents: Data: 0.00MB + Index: 0.00MB + Engine MyISAM wp_mailpoet_user_flags: Data: 0.00MB + Index: 0.00MB + Engine MyISAM wp_options: Data: 4.47MB + Index: 0.17MB + Engine InnoDB wp_postmeta: Data: 1.52MB + Index: 0.20MB + Engine InnoDB wp_posts: Data: 2.52MB + Index: 0.20MB + Engine InnoDB wp_termmeta: Data: 0.00MB + Index: 0.01MB + Engine MyISAM wp_terms: Data: 0.02MB + Index: 0.03MB + Engine InnoDB wp_term_relationships: Data: 0.02MB + Index: 0.02MB + Engine InnoDB wp_term_taxonomy: Data: 0.02MB + Index: 0.03MB + Engine InnoDB wp_toolset_post_guid_id: Data: 0.00MB + Index: 0.00MB + Engine MyISAM wp_usermeta: Data: 0.20MB + Index: 0.03MB + Engine InnoDB wp_users: Data: 0.02MB + Index: 0.05MB + Engine InnoDB wp_wc_admin_notes: Data: 0.03MB + Index: 0.00MB + Engine MyISAM wp_wc_admin_note_actions: Data: 0.02MB + Index: 0.01MB + Engine MyISAM wp_wc_category_lookup: Data: 0.00MB + Index: 0.00MB + Engine MyISAM wp_wc_customer_lookup: Data: 0.00MB + Index: 0.00MB + Engine MyISAM wp_wc_download_log: Data: 0.00MB + Index: 0.00MB + Engine MyISAM wp_wc_order_addresses: Data: 0.00MB + Index: 0.00MB + Engine MyISAM wp_wc_order_coupon_lookup: Data: 0.00MB + Index: 0.00MB + Engine MyISAM wp_wc_order_operational_data: Data: 0.00MB + Index: 0.00MB + Engine MyISAM wp_wc_order_product_lookup: Data: 0.00MB + Index: 0.00MB + Engine MyISAM wp_wc_order_stats: Data: 0.00MB + Index: 0.00MB + Engine MyISAM wp_wc_order_tax_lookup: Data: 0.00MB + Index: 0.00MB + Engine MyISAM wp_wc_product_attributes_lookup: Data: 0.00MB + Index: 0.00MB + Engine MyISAM wp_wc_product_download_directories: Data: 0.00MB + Index: 0.01MB + Engine MyISAM wp_wc_product_meta_lookup: Data: 0.00MB + Index: 0.01MB + Engine MyISAM wp_wc_rate_limits: Data: 0.00MB + Index: 0.00MB + Engine MyISAM wp_wc_reserved_stock: Data: 0.00MB + Index: 0.00MB + Engine MyISAM wp_wc_tax_rate_classes: Data: 0.00MB + Index: 0.01MB + Engine MyISAM wp_wc_webhooks: Data: 0.00MB + Index: 0.00MB + Engine MyISAM ### Post Type Counts ### attachment: 279 custom_css: 1 customize_changeset: 2 jetpack_migration: 2 jetpack-portfolio: 47 jp_img_sitemap: 1 jp_sitemap: 1 jp_sitemap_master: 1 jp_vid_sitemap: 1 mailpoet_page: 1 nav_menu_item: 5 page: 30 pdfposter: 1 post: 17 post_grid: 7 product: 2 revision: 506 rl_gallery: 1 sa_slider: 2 vp_lists: 1 wp_block: 1 wp_navigation: 1 ### Security ### Secure connection (HTTPS): ✔ Hide errors from visitors: ✔ ### Active Plugins (9) ### Afterpay Gateway for WooCommerce: by Afterpay – 3.6.1 Akismet Anti-spam: Spam Protection: by Automattic - Anti-spam Team – 5.3 Gelato Integration for WooCommerce: by Gelato – 1.2.1 Jetpack: by Automattic – 12.7.1 MailPoet: by MailPoet – 4.34.0 Pinterest for WooCommerce: by WooCommerce – 1.3.12 WooCommerce Payments: by Automattic – 6.6.2 WooCommerce PayPal Payments: by WooCommerce – 2.3.1 WooCommerce: by Automattic – 8.2.1 ### Inactive Plugins (1) ### WP Meta and Date remover: by Prasad Kirpekar – 2.2.1 ### Settings ### API Enabled: ✔ Force SSL: – Currency: USD ($) Currency Position: left Thousand Separator: , Decimal Separator: . Number of Decimals: 2 Taxonomies: Product Types: external (external) grouped (grouped) simple (simple) variable (variable) Taxonomies: Product Visibility: exclude-from-catalog (exclude-from-catalog) exclude-from-search (exclude-from-search) featured (featured) outofstock (outofstock) rated-1 (rated-1) rated-2 (rated-2) rated-3 (rated-3) rated-4 (rated-4) rated-5 (rated-5) Connected to WooCommerce.com: – Enforce Approved Product Download Directories: ✔ HPOS feature screen enabled: – HPOS feature enabled: – Order datastore: WC_Order_Data_Store_CPT HPOS data sync enabled: – ### WC Pages ### Shop base: #1217 - /shop/ Cart: #1218 - /cart/ Checkout: #1219 - /checkout/ My account: #1220 - /my-account/ Terms and conditions: ❌ Page not set ### Theme ### Name: Cronus Version: 0.0.32 Author URL: http://mythem.es/ Child Theme: ✔ Parent Theme Name: Tempo Parent Theme Version: 0.0.55 Parent Theme Author URL: http://mythem.es/ WooCommerce Support: ❌ Not declared ### Templates ### Overrides: – ### WooPayments ### Version: 6.6.2 Connected to WPCOM: Yes WPCOM Blog ID: 72566427 Account ID: acct_1NpEUCFoOW0LI1fI Payment Gateway: Enabled Test Mode: Disabled UPE: Enabled (deferred_intent_upe_with_fallback) UPE Enabled APMs: card WooPay: Disabled WooPay Incompatible Extensions: No Apple Pay / Google Pay: Enabled (product,cart,checkout) Fraud Protection Level: basic Multi-currency: Enabled Public Key Encryption: Disabled Auth and Capture: Enabled Documents: Disabled Logging: Disabled ### WooCommerce PayPal Payments ### Onboarded: ✔ Shop country code: US WooCommerce currency supported: ✔ Advanced Card Processing available in country: ✔ Pay Later messaging available in country: ✔ Webhook status: – PayPal Vault enabled: – ACDC Vault enabled: – Logging enabled: – Reference Transactions: – Used PayPal Checkout plugin: – Subscriptions Mode: Disabled ### Admin ### Enabled Features: activity-panels analytics product-block-editor coupons core-profiler customer-effort-score-tracks import-products-task experimental-fashion-sample-products shipping-smart-defaults shipping-setting-tour homescreen marketing mobile-app-banner navigation onboarding onboarding-tasks product-variation-management remote-inbox-notifications remote-free-extensions payment-gateway-suggestions shipping-label-banner subscriptions store-alerts transient-notices woo-mobile-welcome wc-pay-promotion wc-pay-welcome-page Disabled Features: customize-store minified-js new-product-management-experience settings async-product-editor-category-field Daily Cron: ✔ Next scheduled: 2023-10-28 17:57:47 +00:00 Options: ✔ Notes: 82 Onboarding: completed ### MailPoet ### Sending Method: MailPoet Send all site's emails with: Default WordPress sending method Task Scheduler method: Action Scheduler Cron ping URL: https://breemakesart.com?mailpoet_router&endpoint=cron_daemon&action=ping ### Action Scheduler ### Complete: 5,197 Oldest: 2023-09-27 17:53:12 +0000 Newest: 2023-10-28 17:41:58 +0000 Pending: 5 Oldest: 2023-10-28 17:43:04 +0000 Newest: 2023-10-29 03:54:47 +0000 Failed: 1 Oldest: 2023-09-11 18:36:52 +0000 Newest: 2023-09-11 18:36:52 +0000 ### Status report information ### Generated at: 2023-10-28 17:43:23 +00:00 ` ``` * The page I need help with: _[[log in](https://login.wordpress.org/?redirect_to=https%3A%2F%2Fwordpress.org%2Fsupport%2Ftopic%2Fmissing-tables-in-database-3%2F%3Foutput_format%3Dmd&locale=en_US) to see the link]_ Viewing 3 replies - 1 through 3 (of 3 total) * [cstielper](https://wordpress.org/support/users/cstielper/) * (@cstielper) * [2 years, 7 months ago](https://wordpress.org/support/topic/missing-tables-in-database-3/#post-17161835) * I am also seeing this error under my WC status as well. - This reply was modified 2 years, 7 months ago by [cstielper](https://wordpress.org/support/users/cstielper/). * [cstielper](https://wordpress.org/support/users/cstielper/) * (@cstielper) * [2 years, 7 months ago](https://wordpress.org/support/topic/missing-tables-in-database-3/#post-17161896) * For what it’s worth, I went to: * wp-admin/admin.php?page=wc-status&tab=tools * and clicked **Verify base database tables** and the error is no longer there. * [hrn1995 (woo-hc)](https://wordpress.org/support/users/aguinaldodarla/) * (@aguinaldodarla) * [2 years, 7 months ago](https://wordpress.org/support/topic/missing-tables-in-database-3/#post-17170497) * Hi [@breegeek](https://wordpress.org/support/users/breegeek/) * I understand that you’re getting an error when trying to connect and integrate the Gelato plugin with WooCommerce. It seems like the error is related to the database, so I would recommend trying out what [@cstielper](https://wordpress.org/support/users/cstielper/) did. To do this, you may go to **WooCommerce **> **Status **> **Tools**, then click `Verify database`. Please let us know how it goes. Viewing 3 replies - 1 through 3 (of 3 total) The topic ‘Missing tables in database’ is closed to new replies. * ![](https://ps.w.org/woocommerce/assets/icon.svg?rev=3234504) * [WooCommerce](https://wordpress.org/plugins/woocommerce/) * [Frequently Asked Questions](https://wordpress.org/plugins/woocommerce/#faq) * [Support Threads](https://wordpress.org/support/plugin/woocommerce/) * [Active Topics](https://wordpress.org/support/plugin/woocommerce/active/) * [Unresolved Topics](https://wordpress.org/support/plugin/woocommerce/unresolved/) * [Reviews](https://wordpress.org/support/plugin/woocommerce/reviews/) * 3 replies * 3 participants * Last reply from: [hrn1995 (woo-hc)](https://wordpress.org/support/users/aguinaldodarla/) * Last activity: [2 years, 7 months ago](https://wordpress.org/support/topic/missing-tables-in-database-3/#post-17170497) * Status: resolved