WC 3.5 – Table does not exist

  • Resolved Sahar

    (@saharusa)


    6 years, 1 month ago

    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 www.ads-software.com 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="https://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.