Missing tables in database
-
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-statusThen it shows
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:
` ### 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: https://mythem.es/ Child Theme: ? Parent Theme Name: Tempo Parent Theme Version: 0.0.55 Parent Theme Author URL: https://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 to see the link]
- The topic ‘Missing tables in database’ is closed to new replies.