• Resolved breegeek

    (@breegeek)


    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

    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]

Viewing 3 replies - 1 through 3 (of 3 total)
  • I am also seeing this error under my WC status as well.

    • This reply was modified 1 year, 1 month ago by cstielper.

    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)

    (@aguinaldodarla)

    Hi @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 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.