Database tables missing

  • Resolved jameskat

    (@jameskat)


    3 years, 9 months ago

    Hello
    in wp Dashboard I get a message from WooCommerce Database tables missing.

    “One or more tables required for WooCommerce to function are missing, some features may not work as expected. Missing tables: wp_wc_rate_limits, wp_wc_product_attributes_lookup, wp_wc_product_download_directories.”

    I have tray to Verify base database tables from Tools but nothing also i have tray the update the WooCommerce to version 6.5.1 but nothing.

    Do you know someone how to fix this problem ?

    Thanks for your time.

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

    (@jameskat)

    3 years, 9 months ago

    This is my system report.

    
### WordPress Environment ###

WordPress address (URL): http://saborobotics.com
Site address (URL): http://saborobotics.com
WC Version: 6.5.1
REST API Version: ✔ 6.5.1
WC Blocks Version: ✔ 7.4.3
Action Scheduler Version: ✔ 3.4.0
Log Directory Writable: ✔
WP Version: 6.0
WP Multisite: –
WP Memory Limit: 256 MB
WP Debug Mode: –
WP Cron: ✔
Language: el
External object cache: –

### Server Environment ###

Server Info: Apache/2.4.39 (Unix) OpenSSL/1.0.1e-fips
PHP Version: 7.2.16
PHP Post Max Size: 8 MB
PHP Time Limit: 30
PHP Max Input Vars: 1000
cURL Version: 7.19.7
NSS/3.44

SUHOSIN Installed: –
MySQL Version: ❌ 5.5.59 - We recommend a minimum MySQL version of 5.6. See: WordPress requirements
Max Upload Size: 2 MB
Default Timezone is UTC: ✔
fsockopen/cURL: ✔
SoapClient: ✔
DOMDocument: ✔
GZip: ✔
Multibyte String: ✔
Remote Post: ✔
Remote Get: ✔

### Database ###

WC Database Version: 6.5.1
WC Database Prefix: wp_
Total Database Size: 24.34MB
Database Data Size: 21.99MB
Database Index Size: 2.35MB
wp_woocommerce_sessions: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_woocommerce_api_keys: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_woocommerce_attribute_taxonomies: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_woocommerce_downloadable_product_permissions: Data: 0.02MB + Index: 0.06MB + Engine InnoDB
wp_woocommerce_order_items: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_woocommerce_order_itemmeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_woocommerce_tax_rates: Data: 0.02MB + Index: 0.06MB + Engine InnoDB
wp_woocommerce_tax_rate_locations: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_woocommerce_shipping_zones: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_woocommerce_shipping_zone_locations: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_woocommerce_shipping_zone_methods: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_woocommerce_payment_tokens: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_woocommerce_payment_tokenmeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_woocommerce_log: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_actionscheduler_actions: Data: 0.13MB + Index: 0.19MB + Engine InnoDB
wp_actionscheduler_claims: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_actionscheduler_groups: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_actionscheduler_logs: Data: 0.14MB + Index: 0.09MB + Engine InnoDB
wp_alphabank_transactions: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_commentmeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_comments: Data: 0.02MB + Index: 0.09MB + Engine InnoDB
wp_links: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_options: Data: 4.08MB + Index: 0.06MB + Engine InnoDB
wp_postmeta: Data: 12.31MB + Index: 0.66MB + Engine InnoDB
wp_posts: Data: 4.48MB + Index: 0.23MB + Engine InnoDB
wp_termmeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_terms: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_term_relationships: Data: 0.05MB + Index: 0.02MB + Engine InnoDB
wp_term_taxonomy: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_usermeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_users: Data: 0.02MB + Index: 0.05MB + Engine InnoDB
wp_wc_admin_notes: Data: 0.06MB + Index: 0.00MB + Engine InnoDB
wp_wc_admin_note_actions: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_wc_category_lookup: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_wc_customer_lookup: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_wc_download_log: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_wc_order_coupon_lookup: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_wc_order_product_lookup: Data: 0.02MB + Index: 0.06MB + Engine InnoDB
wp_wc_order_stats: Data: 0.02MB + Index: 0.05MB + Engine InnoDB
wp_wc_order_tax_lookup: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_wc_product_meta_lookup: Data: 0.02MB + Index: 0.09MB + Engine InnoDB
wp_wc_reserved_stock: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_wc_tax_rate_classes: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_wc_webhooks: Data: 0.02MB + Index: 0.02MB + Engine InnoDB

### Post Type Counts ###

apps: 2
attachment: 56
custom_css: 1
customize_changeset: 22
elementor_library: 30
job: 6
mc4wp-form: 1
nav_menu_item: 45
oembed_cache: 1
page: 61
polylang_mo: 2
post: 16
product: 19
revision: 792
shop_order: 12
team: 5
testimonial: 5
webinars: 8
wpcf7_contact_form: 9
wptb-tables: 1

### Security ###

Secure connection (HTTPS): ❌
					Your store is not using HTTPS. Learn more about HTTPS and SSL Certificates.
Hide errors from visitors: ✔

### Active Plugins (20) ###

Polylang: by WP SYNTEX – 3.2.3
Contact Form 7: by Takayuki Miyoshi – 5.5.6.1
Codestar Framework: by Codestar – 1.0.1
Duplicate Page: by mndpsingh287 – 4.4.8
Elementor: by Elementor.com – 3.6.5
PayPal Express Checkout Payment Gateway for WooCommerce ( Basic ): by WebToffee – 1.7.1
GDPR: by Trew Knowledge – 2.1.2
Get a Quote Button for WooCommerce: by wpbean – 1.2.4
MC4WP: Mailchimp for WordPress: by ibericode – 4.8.7
One Click Demo Import: by OCDI – 3.1.1
Polylang for WooCommerce: by WP SYNTEX – 1.6.3
Restore Classic Widgets: by Bill Minozzi – 1.5
SaaSpot Core: by VictorThemes – 1.9
Web Expert Eurobank WooCommerce Payment Gateway: by Web Expert – 1.0.36
WooCommerce Easy Duplicate Product: by WPGem.com – 0.2.0.2
Product And Custom Post type Dropdown CF7: by  – 1.0
WooCommerce: by Automattic – 6.5.1
WP-PageNavi: by Lester 'GaMerZ' Chan – 2.94.0
WP Table Builder: by WP Table Builder – 1.3.17
Related Products for WooCommerce: by WebToffee – 1.4.3

### Inactive Plugins (10) ###

Akismet Anti-Spam: by Automattic – 4.2.4
All-in-One WP Migration: by ServMask – 7.59
All in One SEO: by All in One SEO Team – 4.2.0
AMP: by AMP Project Contributors – 2.2.4
Google Analytics for WordPress by MonsterInsights: by MonsterInsights – 8.5.3
Hello Dolly: by Matt Mullenweg – 1.7.2
Jetpack: by Automattic – 10.2.1
TaxoPress: by TaxoPress – 3.6.1
WooCommerce Payments: by Automattic – 4.1.0 (update to version 4.2.1 is available)
WP Mail SMTP: by WPForms – 3.4.0

### Settings ###

API Enabled: –
Force SSL: –
Currency: EUR (€)
Currency Position: right_space
Thousand Separator: ,
Decimal Separator: .
Number of Decimals: 2
Taxonomies: Product Types: external (external)
grouped (grouped)
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)

Connected to WooCommerce.com: –
Enforce Approved Product Download Directories: –

### WC Pages ###

Shop base: #3350 - /shop/
Cart: #3351 - /cart/
Checkout: #3352 - /checkout/
My account: #3353 - /my-account/
Terms and conditions: ❌ Page not set

### Theme ###

Name: SaaSpot Child
Version: 1.0
Author URL: http://themeforest.net/user/VictorThemes/portfolio
Child Theme: ✔
Parent Theme Name: SaaSpot
Parent Theme Version: 1.8.7
Parent Theme Author URL: http://themeforest.net/user/victorthemes/portfolio
WooCommerce Support: ✔

### Templates ###

Archive Template: Your theme has a woocommerce.php file
you will not be able to override the woocommerce/archive-product.php custom template since woocommerce.php has priority over archive-product.php. This is intended to prevent display issues.

Overrides: –

### WC Pages Translations ###

Shop base: ✔
Cart: ✔
Checkout: ✔
My account: ✔

### Action Scheduler ###

Complete: 344
Oldest: 2022-05-26 10:52:47 +0000
Newest: 2022-06-14 13:41:56 +0000

Failed: 3
Oldest: 2022-06-10 06:31:16 +0000
Newest: 2022-06-10 06:31:17 +0000

### Status report information ###

Generated at: 2022-06-14 14:32:33 +00:00

    Thanks for your time

    Roxy

    (@roxannestoltz)

    3 years, 9 months ago

    Hi @jameskat ,

    Thanks for reaching out!

    I understand that you have missing database tables and that you have already tried to verify the database but the issue persists.

    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!

    Mirko P.

    (@rainfallnixfig)

    3 years, 9 months ago

    Hi @jameskat,

    If updating the database as suggested by @roxannestoltz doesn’t help create those missing tables 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

    PHP Version: 7.2.16
MySQL Version: ❌ 5.5.59

    Please also note that your WordPress site doesn’t meet our minimum requirements, then many plugins (including possibly the core WooCommerce plugin) won’t function as expected. Read over the WooCommerce Server Recommendations below.

    https://woocommerce.com/document/server-requirements/

    Mirko P.

    (@rainfallnixfig)

    3 years, 9 months ago

    Hi there,

    We’ve not heard back from you in a while so I’ll go ahead and mark this thread as resolved. Hopefully, you were able to find a solution to this issue.

    If you have further questions, please feel free to open a new topic.

    Thanks.

Viewing 4 replies - 1 through 4 (of 4 total)

The topic ‘Database tables missing’ is closed to new replies.