• A few hours ago I updated WooCommerce to its latest version. There are said to be base missing tables:

    wpro_wc_orders, wpro_wc_order_addresses, wpro_wc_order_operational_data, wpro_wc_orders_meta.”

    Some WooCommerce functionality may not work as expected !!

    I’ve added screenshots below. How do I fix missing db tables?

    View post on imgur.com

    The page I need help with: [log in to see the link]

Viewing 5 replies - 1 through 5 (of 5 total)
  • Thread Starter dardargraphic

    (@dardargraphic)

    ` WordPress Environment
    
    WordPress address (URL): https://suheyla-handbag.com
    Site address (URL): https://suheyla-handbag.com
    WC Version: 8.8.2
    REST API Version: ? 8.8.2
    Action Scheduler Version: ? 3.7.4
    Log Directory Writable: ?
    WP Version: 6.5.2
    WP Multisite: –
    WP Memory Limit: 256 MB
    WP Debug Mode: –
    WP Cron: ?
    Language: en_US
    External object cache: – Server Environment
    
    Server Info: LiteSpeed
    PHP Version: 7.4.33
    PHP Post Max Size: 100 MB
    PHP Time Limit: 300
    PHP Max Input Vars: 10000
    cURL Version: 7.87.0
    OpenSSL/1.1.1w
    
    SUHOSIN Installed: –
    MySQL Version: 8.0.36-cll-lve
    Max Upload Size: 100 MB
    Default Timezone is UTC: ?
    fsockopen/cURL: ?
    SoapClient: ?
    DOMDocument: ?
    GZip: ?
    Multibyte String: ?
    Remote Post: ?
    Remote Get: ? Database
    
    WC Database Version: 8.8.2
    WC Database Prefix: wpro_
    Total Database Size: 25.85MB
    Database Data Size: 24.45MB
    Database Index Size: 1.40MB
    wpro_woocommerce_sessions: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wpro_woocommerce_api_keys: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wpro_woocommerce_attribute_taxonomies: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wpro_woocommerce_downloadable_product_permissions: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wpro_woocommerce_order_items: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wpro_woocommerce_order_itemmeta: Data: 0.02MB + Index: 0.02MB + Engine MyISAM
    wpro_woocommerce_tax_rates: Data: 0.00MB + Index: 0.01MB + Engine MyISAM
    wpro_woocommerce_tax_rate_locations: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wpro_woocommerce_shipping_zones: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wpro_woocommerce_shipping_zone_locations: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wpro_woocommerce_shipping_zone_methods: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wpro_woocommerce_payment_tokens: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wpro_woocommerce_payment_tokenmeta: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wpro_woocommerce_log: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wpro_actionscheduler_actions: Data: 0.52MB + Index: 0.23MB + Engine MyISAM
    wpro_actionscheduler_claims: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wpro_actionscheduler_groups: Data: 0.00MB + Index: 0.01MB + Engine MyISAM
    wpro_actionscheduler_logs: Data: 0.35MB + Index: 0.26MB + Engine MyISAM
    wpro_awb_critical_css: Data: 1.54MB + Index: 0.00MB + Engine MyISAM
    wpro_commentmeta: Data: 0.00MB + Index: 0.01MB + Engine MyISAM
    wpro_comments: Data: 0.02MB + Index: 0.01MB + Engine MyISAM
    wpro_fusion_form_entries: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wpro_fusion_form_fields: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wpro_fusion_form_submissions: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wpro_fusion_forms: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wpro_links: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wpro_options: Data: 5.42MB + Index: 0.08MB + Engine MyISAM
    wpro_paytr_iframe_transaction: Data: 0.01MB + Index: 0.00MB + Engine MyISAM
    wpro_postmeta: Data: 7.18MB + Index: 0.47MB + Engine MyISAM
    wpro_posts: Data: 8.84MB + Index: 0.14MB + Engine MyISAM
    wpro_revslider_slides: Data: 0.47MB + Index: 0.02MB + Engine InnoDB
    wpro_term_relationships: Data: 0.01MB + Index: 0.02MB + Engine MyISAM
    wpro_term_taxonomy: Data: 0.00MB + Index: 0.01MB + Engine MyISAM
    wpro_termmeta: Data: 0.01MB + Index: 0.02MB + Engine MyISAM
    wpro_terms: Data: 0.00MB + Index: 0.01MB + Engine MyISAM
    wpro_usermeta: Data: 0.01MB + Index: 0.01MB + Engine MyISAM
    wpro_users: Data: 0.00MB + Index: 0.01MB + Engine MyISAM
    wpro_wc_admin_note_actions: Data: 0.02MB + Index: 0.01MB + Engine MyISAM
    wpro_wc_admin_notes: Data: 0.03MB + Index: 0.00MB + Engine MyISAM
    wpro_wc_category_lookup: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wpro_wc_customer_lookup: Data: 0.00MB + Index: 0.01MB + Engine MyISAM
    wpro_wc_download_log: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wpro_wc_order_coupon_lookup: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wpro_wc_order_product_lookup: Data: 0.00MB + Index: 0.01MB + Engine MyISAM
    wpro_wc_order_stats: Data: 0.00MB + Index: 0.01MB + Engine MyISAM
    wpro_wc_order_tax_lookup: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wpro_wc_product_attributes_lookup: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wpro_wc_product_download_directories: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wpro_wc_product_meta_lookup: Data: 0.00MB + Index: 0.01MB + Engine MyISAM
    wpro_wc_rate_limits: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wpro_wc_reserved_stock: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wpro_wc_tax_rate_classes: Data: 0.00MB + Index: 0.01MB + Engine MyISAM
    wpro_wc_webhooks: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wpro_wws_analytics: Data: 0.00MB + Index: 0.00MB + Engine MyISAM Post Type Counts
    
    attachment: 1367
    awb_off_canvas: 1
    fusion_element: 2
    fusion_form: 3
    fusion_icons: 1
    fusion_tb_layout: 7
    fusion_tb_section: 12
    nav_menu_item: 17
    page: 11
    post: 1
    product: 87
    revision: 183
    shop_coupon: 1
    shop_order: 12
    wp_global_styles: 1
    wp_navigation: 2 Security
    
    Secure connection (HTTPS): ?
    Hide errors from visitors: ? Active Plugins (10)
    
    Cloudflare: by Cloudflare
    Inc. – 4.12.7
    
    Avada Builder: by ThemeFusion – 3.11.7
    Avada Core: by ThemeFusion – 5.11.7
    Easy HTTPS (SSL) Redirection: by Tips and Tricks HQ – 1.9.2
    NitroPack: by NitroPack Inc. – 1.13.0
    PayTR Virtual POS WooCommerce - iFrame API: by PayTR ?deme ve Elektronik Para Kurulu?u A.?. – 2.0.4
    PWA: by PWA Plugin Contributors – 0.8.1
    WooCommerce Stripe Gateway: by WooCommerce – 8.2.0
    WooCommerce: by Automattic – 8.8.2
    WordPress WhatsApp Support: by WeCreativez – 2.4.3 Inactive Plugins (0) Dropin Plugins ()
    
    advanced-cache.php: advanced-cache.php 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: ? Logging
    
    Enabled: ?
    Handler: Automattic\WooCommerce\Internal\Admin\Logging\LogHandlerFileV2
    Retention period: 30 days
    Level threshold: –
    Log directory size: 100 KB WC Pages
    
    Shop base: #28 - /shop/
    Cart: ? Page does not contain the [woocommerce_cart] shortcode or the woocommerce/cart block.
    Checkout: ? Page does not contain the [woocommerce_checkout] shortcode or the woocommerce/checkout block.
    My account: #31 - /my-account/
    Terms and conditions: #1295 - /terms-and-conditions/ Theme
    
    Name: Avada Child
    Version: 1.0.0
    Author URL: https://theme-fusion.com
    Child Theme: ?
    Parent Theme Name: Avada
    Parent Theme Version: 7.11.7
    Parent Theme Author URL: https://themeforest.net/user/ThemeFusion
    WooCommerce Support: ? Templates
    
    Overrides: Avada/woocommerce/cart/cart.php
    Avada/woocommerce/checkout/form-pay.php
    Avada/woocommerce/checkout/review-order.php
    Avada/woocommerce/single-product/short-description.php
    Avada/woocommerce/single-product/tabs/additional-information.php
    Avada/woocommerce/single-product/tabs/description.php Admin
    
    Enabled Features: activity-panels
    analytics
    product-block-editor
    coupons
    core-profiler
    customize-store
    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
    product-virtual-downloadable
    product-external-affiliate
    product-grouped
    product-linked
    product-pre-publish-modal
    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: minified-js
    new-product-management-experience
    product-custom-fields
    settings
    async-product-editor-category-field
    launch-your-store
    
    Daily Cron: ? Next scheduled: 2024-04-19 11:02:22 +03:00
    Options: ?
    Notes: 74
    Onboarding: completed Action Scheduler
    
    Complete: 1,987
    Oldest: 2024-03-19 14:42:54 +0300
    Newest: 2024-04-19 13:04:55 +0300
    
    Failed: 5
    Oldest: 2024-01-30 14:04:17 +0300
    Newest: 2024-03-09 14:05:34 +0300
    
    Pending: 3
    Oldest: 2024-04-19 13:21:08 +0300
    Newest: 2024-04-20 11:08:38 +0300 Status report information
    
    Generated at: 2024-04-19 13:11:17 +03:00

    Hey there, @dardargraphic! Thanks for contacting us. I’m happy to help you.

    Please could you temporarily switch your site to the default Storefront theme and disable all plugins except for WooCommerce.

    Once that is done, navigate to WooCommerce > Status Tools, and Update databse to see if those tables are created.

    Please let me know how this goes!

    Looking forward to your reply.

    Have a wonderful day!

    Thread Starter dardargraphic

    (@dardargraphic)

    Hi Carol,

    I did what you said, changed my theme to Storefront and disabled (not deleted) all plugins except Woocommerce. I’ve added new screenshots below. But I guess there has been no change.

    Warmly regards

    View post on imgur.com

    Thread Starter dardargraphic

    (@dardargraphic)

    Of course, and then once this was done, I navigated to WooCommerce > Status > Tools and Database to see if these tables were created.

    Hey, @dardargraphic! Thank you for trying.

    Since updating the table did not help, I’d suggest that you ask your host to do it for you. This Github has SQL instructions to proceed and create them in the correct way.

    https://github.com/woocommerce/woocommerce/blob/f994ba1839c2472aaa95560f7cfcfc259372e739/plugins/woocommerce/includes/class-wc-install.php#L1221

    I hope this was clarifying. If you face any issues or have any questions, please let us know so we can assist you further.

    Have a wonderful day!

Viewing 5 replies - 1 through 5 (of 5 total)
  • The topic ‘[NSFW] Missing db tables’ is closed to new replies.