Support » Plugin: WooCommerce » WC 3.5 – Table does not exist

  • Resolved Sahar

    (@saharusa)


    Hi,

    After upgrading from v3.4.7 to 3.5.0 many tables shows is WC status as not exist (marked in red, 80% of WC tables)

    After rolling back to v3.4.7, all tables look ok on WC status.

    Any idea why?

    p.s. after updating to v3.5.0 attempt to execute admin.php?page=wc-settings&do_update_woocommerce=1 end with an error of linked expired. after the rolling back to v3.4.7, force update works just fine.

Viewing 4 replies - 1 through 4 (of 4 total)
  • Thread Starter Sahar

    (@saharusa)

    Here is the system report:

    
    ### WordPress Environment ###
    
    Home URL: https://www.mydomain.com
    Site URL: https://www.mydomain.com
    WC Version: 3.5.0
    Log Directory Writable: ✔
    WP Version: 4.9.8
    WP Multisite: –
    WP Memory Limit: 256 MB
    WP Debug Mode: –
    WP Cron: ✔
    Language: en_US
    External object cache: –
    
    ### Server Environment ###
    
    Server Info: nginx/1.14.0
    PHP Version: 7.2.6
    PHP Post Max Size: 128 MB
    PHP Time Limit: 300
    PHP Max Input Vars: 10000
    cURL Version: 7.29.0
    NSS/3.34
    
    SUHOSIN Installed: –
    MySQL Version: 5.5.5-10.2.18-MariaDB
    Max Upload Size: 64 MB
    Default Timezone is UTC: ✔
    fsockopen/cURL: ✔
    SoapClient: ✔
    DOMDocument: ✔
    GZip: ✔
    Multibyte String: ✔
    Remote Post: ✔
    Remote Get: ✔
    
    ### Database ###
    
    WC Database Version: 3.4.7
    WC Database Prefix: md_
    MaxMind GeoIP Database: ✔
    Total Database Size: 26.63MB
    Database Data Size: 22.47MB
    Database Index Size: 4.16MB
    sb_woocommerce_sessions: Data: 0.02MB + Index: 0.02MB
    sb_woocommerce_api_keys: Data: 0.02MB + Index: 0.03MB
    sb_woocommerce_attribute_taxonomies: Data: 0.02MB + Index: 0.02MB
    sb_woocommerce_downloadable_product_permissions: Data: 0.02MB + Index: 0.05MB
    sb_woocommerce_order_items: Data: 0.02MB + Index: 0.02MB
    sb_woocommerce_order_itemmeta: Data: 0.02MB + Index: 0.03MB
    sb_woocommerce_tax_rates: Data: 0.02MB + Index: 0.06MB
    sb_woocommerce_tax_rate_locations: Data: 0.02MB + Index: 0.03MB
    sb_woocommerce_shipping_zones: Data: 0.02MB + Index: 0.00MB
    sb_woocommerce_shipping_zone_locations: Data: 0.02MB + Index: 0.03MB
    sb_woocommerce_shipping_zone_methods: Data: 0.02MB + Index: 0.00MB
    sb_woocommerce_payment_tokens: Data: 0.02MB + Index: 0.02MB
    sb_woocommerce_payment_tokenmeta: Data: 0.02MB + Index: 0.03MB
    sb_woocommerce_log: Data: 0.02MB + Index: 0.02MB
    sb_commentmeta: Data: 0.02MB + Index: 0.03MB
    sb_comments: Data: 0.02MB + Index: 0.09MB
    sb_gf_draft_submissions: Data: 0.02MB + Index: 0.02MB
    sb_gf_entry: Data: 0.02MB + Index: 0.03MB
    sb_gf_entry_meta: Data: 0.02MB + Index: 0.05MB
    sb_gf_entry_notes: Data: 0.02MB + Index: 0.03MB
    sb_gf_form: Data: 0.02MB + Index: 0.00MB
    sb_gf_form_meta: Data: 0.02MB + Index: 0.00MB
    sb_gf_form_view: Data: 0.02MB + Index: 0.03MB
    sb_itsec_distributed_storage: Data: 0.02MB + Index: 0.02MB
    sb_itsec_fingerprints: Data: 0.02MB + Index: 0.03MB
    sb_itsec_geolocation_cache: Data: 0.02MB + Index: 0.03MB
    sb_itsec_lockouts: Data: 0.02MB + Index: 0.08MB
    sb_itsec_log: Data: 0.11MB + Index: 0.03MB
    sb_itsec_logs: Data: 1.02MB + Index: 0.13MB
    sb_itsec_temp: Data: 0.02MB + Index: 0.06MB
    sb_links: Data: 0.02MB + Index: 0.02MB
    sb_options: Data: 6.02MB + Index: 0.08MB
    sb_postmeta: Data: 1.05MB + Index: 0.03MB
    sb_posts: Data: 0.06MB + Index: 0.06MB
    sb_rg_form: Data: 0.02MB + Index: 0.00MB
    sb_rg_form_meta: Data: 0.02MB + Index: 0.00MB
    sb_rg_form_view: Data: 0.02MB + Index: 0.03MB
    sb_rg_incomplete_submissions: Data: 0.02MB + Index: 0.02MB
    sb_rg_lead: Data: 0.02MB + Index: 0.03MB
    sb_rg_lead_detail: Data: 0.02MB + Index: 0.06MB
    sb_rg_lead_detail_long: Data: 0.02MB + Index: 0.00MB
    sb_rg_lead_meta: Data: 0.02MB + Index: 0.05MB
    sb_rg_lead_notes: Data: 0.02MB + Index: 0.03MB
    sb_tab_event_log: Data: 0.02MB + Index: 0.05MB
    sb_tab_tests: Data: 0.02MB + Index: 0.02MB
    sb_tab_test_items: Data: 0.02MB + Index: 0.05MB
    sb_tcb_api_error_log: Data: 0.02MB + Index: 0.00MB
    sb_tcm_email_hash: Data: 0.02MB + Index: 0.00MB
    sb_tcm_logs: Data: 0.02MB + Index: 0.02MB
    sb_termmeta: Data: 0.02MB + Index: 0.03MB
    sb_terms: Data: 0.02MB + Index: 0.03MB
    sb_term_relationships: Data: 0.02MB + Index: 0.02MB
    sb_term_taxonomy: Data: 0.02MB + Index: 0.03MB
    sb_tge_answers: Data: 0.02MB + Index: 0.02MB
    sb_tge_questions: Data: 0.02MB + Index: 0.02MB
    sb_tho_event_log: Data: 0.02MB + Index: 0.00MB
    sb_tho_tests: Data: 0.02MB + Index: 0.00MB
    sb_tho_test_items: Data: 0.02MB + Index: 0.00MB
    sb_tqb_event_log: Data: 0.02MB + Index: 0.00MB
    sb_tqb_results: Data: 0.02MB + Index: 0.00MB
    sb_tqb_tests: Data: 0.02MB + Index: 0.00MB
    sb_tqb_tests_items: Data: 0.02MB + Index: 0.00MB
    sb_tqb_users: Data: 0.02MB + Index: 0.00MB
    sb_tqb_user_answers: Data: 0.02MB + Index: 0.00MB
    sb_tqb_variations: Data: 0.02MB + Index: 0.00MB
    sb_tve_leads_contacts: Data: 0.02MB + Index: 0.00MB
    sb_tve_leads_contact_download: Data: 0.02MB + Index: 0.00MB
    sb_tve_leads_event_log: Data: 0.02MB + Index: 0.03MB
    sb_tve_leads_form_variations: Data: 0.02MB + Index: 0.06MB
    sb_tve_leads_group_options: Data: 0.02MB + Index: 0.00MB
    sb_tve_leads_saved_group_options: Data: 0.02MB + Index: 0.00MB
    sb_tve_leads_split_test: Data: 0.02MB + Index: 0.00MB
    sb_tve_leads_split_test_items: Data: 0.02MB + Index: 0.00MB
    sb_tve_ult_designs: Data: 0.02MB + Index: 0.00MB
    sb_tve_ult_emails: Data: 0.02MB + Index: 0.00MB
    sb_tve_ult_events: Data: 0.02MB + Index: 0.00MB
    sb_tve_ult_event_log: Data: 0.02MB + Index: 0.00MB
    sb_tve_ult_settings_campaign: Data: 0.02MB + Index: 0.00MB
    sb_tve_ult_settings_templates: Data: 0.02MB + Index: 0.00MB
    sb_tvo_activity_log: Data: 0.02MB + Index: 0.00MB
    sb_usermeta: Data: 0.05MB + Index: 0.03MB
    sb_users: Data: 0.02MB + Index: 0.05MB
    sb_wcs_payment_retries: Data: 0.02MB + Index: 0.02MB
    sb_wc_download_log: Data: 0.02MB + Index: 0.03MB
    sb_wc_webhooks: Data: 0.02MB + Index: 0.02MB
    sb_woocommerce_bundled_itemmeta: Data: 0.02MB + Index: 0.03MB
    sb_woocommerce_bundled_items: Data: 0.02MB + Index: 0.03MB
    sb_yoast_seo_links: Data: 0.02MB + Index: 0.02MB
    sb_yoast_seo_meta: Data: 0.05MB + Index: 0.00MB
    
    ### Post Type Counts ###
    
    amn_exact-metrics: 1
    attachment: 17
    bulkpage: 1
    customize_changeset: 1
    nav_menu_item: 1
    page: 9
    post: 2
    product: 2
    revision: 14
    scheduled-action: 3
    shop_subscription: 1
    tcb_content_template: 1
    tcb_lightbox: 2
    tva_chapter: 1
    tva_course_type: 1
    tva_lesson: 12
    tva_module: 2
    
    ### Security ###
    
    Secure connection (HTTPS): ✔
    Hide errors from visitors: ✔
    
    ### Active Plugins (31) ###
    
    Gravity Forms: by rocketgenius – 2.3.6
    Admin Menu Editor Pro: by Janis Elsts – 2.7
    BackupBuddy: by iThemes – 8.3.1.1
    Disable Comments: by Samir Shah – 1.8.0
    Health Check & Troubleshooting: by The WordPress.org community – 1.2.1
    iThemes Security Pro: by iThemes – 5.5.3
    Really Simple SSL: by Rogier Lankhorst
    Mark Wolters – 3.1.1
    Thrive Optimize: by Thrive Themes – 1.1.51
    Thrive Apprentice: by <a href="https://thrivethemes.com">Thrive Themes</a> – 2.0.62
    Thrive Clever Widgets: by <a href="https://thrivethemes.com">Thrive Themes</a> – 1.35
    Thrive Comments: by <a href="https://thrivethemes.com">Thrive Themes</a> – 1.1.11
    Thrive Headline Optimizer: by <a href="https://thrivethemes.com">Thrive Themes</a> – 1.1.18
    Thrive Leads: by <a href="https://thrivethemes.com">Thrive Themes</a> – 2.0.57
    Thrive Ovation: by <a href="https://thrivethemes.com">Thrive Themes</a> – 2.0.20
    Thrive Product Manager: by Thrive Themes – 1.0.0
    Thrive Quiz Builder: by <a href="https://thrivethemes.com">Thrive Themes</a> – 2.0.57
    Thrive Ultimatum: by <a href="https://thrivethemes.com">Thrive Themes</a> – 2.0.59
    Thrive Architect: by <a href="http://www.thrivethemes.com">Thrive Themes</a> – 2.1.0
    User Role Editor: by Vladimir Garagulya – 4.46
    WooCommerce Composite Products: by SomewhereWarm – 3.14.2
    WooCommerce Email Customizer: by cxThemes – 3.21 – Not tested with the active version of WooCommerce
    WooCommerce PayPal Checkout Gateway: by WooCommerce – 1.6.4 – Not tested with the active version of WooCommerce
    WooCommerce Stripe Gateway: by WooCommerce – 4.1.12
    WooCommerce Mix and Match: by Kathy Darling – 1.3.3 – Not tested with the active version of WooCommerce
    WooCommerce Product Bundles: by SomewhereWarm – 5.8.0
    WooCommerce Subscriptions: by Prospress Inc. – 2.4.1
    WooCommerce: by Automattic – 3.5.0
    Yoast SEO Premium: by Team Yoast – 9.0.2
    WP Mail SMTP: by WPForms – 1.3.3
    WP Rocket: by WP Media – 3.2-beta1
    WordPress Toolbar Editor: by Janis Elsts – 1.2.2
    
    ### Settings ###
    
    API Enabled: –
    Force SSL: ✔
    Currency: GBP (£)
    Currency Position: left
    Thousand Separator: ,
    Decimal Separator: .
    Number of Decimals: 2
    Taxonomies: Product Types: bundle (bundle)
    composite (composite)
    external (external)
    grouped (grouped)
    mix and match (mix-and-match)
    simple (simple)
    subscription (subscription)
    variable (variable)
    variable subscription (variable-subscription)
    
    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)
    
    ### WC Pages ###
    
    Shop base: #692 - /shop/
    Cart: #693 - /cart/
    Checkout: #694 - /checkout/
    My account: #695 - /my-account/
    Terms and conditions: ❌ Page not set
    
    ### Theme ###
    
    Name: Astra
    Version: 1.5.4
    Author URL: https://wpastra.com/about/
    Child Theme: ❌ – If you are modifying WooCommerce on a parent theme that you did not build personally we recommend using a child theme. See: How to create a child theme
    WooCommerce Support: ✔
    
    ### Templates ###
    
    Overrides: –
    
    ### Subscriptions ###
    
    WCS_DEBUG: ✔ No
    Subscriptions Mode: ✔ Live
    Subscriptions Live URL: https://www.mydomain.com
    Subscription Statuses: auto-draft: 1
    WooCommerce Account Connected: ❌ No
    Custom Retry Rules: ✔ No
    Custom Retry Rule Class: ✔ No
    Custom Raw Retry Rule: ✔ No
    Custom Retry Rule: ✔ No
    Retries Migration Status: ✔ Completed
    Report Cache Enabled: ✔ Yes
    Cache Update Failures: ✔ 0 failure
    
    ### Store Setup ###
    
    Country / State: United Kingdom (UK)
    
    ### Subscriptions by Payment Gateway ###
    
    Stripe: wc-active: 3
    wc-cancelled: 2
    wc-on-hold: 2
    wc-pending: 1
    
    ### Payment Gateway Support ###
    
    Stripe: products
    refunds
    tokenization
    add_payment_method
    subscriptions
    subscription_cancellation
    subscription_suspension
    subscription_reactivation
    subscription_amount_changes
    subscription_date_changes
    subscription_payment_method_change
    subscription_payment_method_change_customer
    subscription_payment_method_change_admin
    multiple_subscriptions
    pre-orders
    
    ### Mix and Match Products ###
    
    Template Overrides: –
    
    ### Composite Products ###
    
    Database Version: 3.14.2
    Template Overrides: –
    
    ### Product Bundles ###
    
    Database Version: 5.8.0
    Template Overrides: –
    
    Plugin Support Yuki K. a11n

    (@yukikatayama)

    Automattic Happiness Engineer

    Hi there,

    This sounds to be the same as this bug issue that will be fixed in 3.5.1: https://github.com/woocommerce/woocommerce/issues/21657. The tables should be there and working, and seems to only ?aff=10486&cid=1131038ect the system status report.

    Cheers,
    Yuki

    Thread Starter Sahar

    (@saharusa)

    Hi Yuki,

    Thanks!

    I can confirm that PR#21706 fixed the first part of the issue I described. All tables listed just fine.

    https://github.com/woocommerce/woocommerce/pull/21706

    The force update through: admin.php?page=wc-settings&do_update_woocommerce=1 ends with 403 error: “The link you followed has expired.” and the WooCommerce database version still show 3.4.5.

    When I roll back to WC v3.4.7, the force update works… I still didn’t find why…

    Hi all

    in my case, our staging site asked us to migrate the database to version 3.5, but on our production site, there is no option to upgrade the database after updating woocommerce to 3.5. so we got 3.5 with database version 3.4.7.

    If I try to force the update (/wp-admin/admin.php?page=wc-settings&do_update_woocommerce=1), it shows a “The link you followed has expired”.
    Can this be related ?

Viewing 4 replies - 1 through 4 (of 4 total)
  • The topic ‘WC 3.5 – Table does not exist’ is closed to new replies.