Missing database tables

  • Resolved jonaswinz

    (@jonaswinz)


    4 years, 5 months ago

    My dashboard tells me that there are some woocommerce database tables missing. I reinstalled woocommerce (also with WC_REMOVE_ALL_DATA) and I also tryed to repair the database. The repair failes with the error, that the tables are missing.

    
### WordPress Environment ###

WordPress address (URL): https://wupperle.de
Site address (URL): https://wupperle.de
WC Version: 4.5.2
REST API Version: ? 4.5.2
WC Blocks Version: ? 3.1.0
Action Scheduler Version: ? 3.1.6
WC Admin Version: ? 1.5.0
Log Directory Writable: ?
WP Version: 5.5.1
WP Multisite: –
WP Memory Limit: 256 MB
WP Debug Mode: –
WP Cron: ?
Language: de_DE
External object cache: –

### Server Environment ###

Server Info: Apache/2.4.38 (Debian)
PHP Version: 7.4.8
PHP Post Max Size: 64 MB
PHP Time Limit: 180
PHP Max Input Vars: 3000
cURL Version: 7.64.0
OpenSSL/1.1.1d

SUHOSIN Installed: –
MySQL Version: 5.7.31
Max Upload Size: 64 MB
Default Timezone is UTC: ?
fsockopen/cURL: ?
SoapClient: ? Dein Server verfügt nicht über eine lauff?hige Version der SoapClient Klasse - einige Zahlungsschnittstellen
welche SOAP nutzen
funktionieren unter Umst?nden nicht korrekt.

DOMDocument: ?
GZip: ?
Multibyte String: ?
Remote Post: ?
Remote Get: ?

### Database ###

WC Database Version: 4.5.2
WC Database Prefix: wp_
Datenbank-Gesamtgr??e: 14.32MB
Datenbank-Datengr??e: 12.78MB
Datenbank-Indexgr??e: 1.54MB
wp_woocommerce_sessions: ? Tabelle ist nicht vorhanden
wp_woocommerce_api_keys: ? Tabelle ist nicht vorhanden
wp_woocommerce_attribute_taxonomies: ? Tabelle ist nicht vorhanden
wp_woocommerce_downloadable_product_permissions: ? Tabelle ist nicht vorhanden
wp_woocommerce_order_items: ? Tabelle ist nicht vorhanden
wp_woocommerce_order_itemmeta: ? Tabelle ist nicht vorhanden
wp_woocommerce_tax_rates: ? Tabelle ist nicht vorhanden
wp_woocommerce_tax_rate_locations: ? Tabelle ist nicht vorhanden
wp_woocommerce_shipping_zones: ? Tabelle ist nicht vorhanden
wp_woocommerce_shipping_zone_locations: ? Tabelle ist nicht vorhanden
wp_woocommerce_shipping_zone_methods: ? Tabelle ist nicht vorhanden
wp_woocommerce_payment_tokens: ? Tabelle ist nicht vorhanden
wp_woocommerce_payment_tokenmeta: ? Tabelle ist nicht vorhanden
wp_woocommerce_log: ? Tabelle ist nicht vorhanden
wp_actionscheduler_actions: Daten: 0.05MB + Index: 0.11MB + Engine InnoDB
wp_actionscheduler_claims: Daten: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_actionscheduler_groups: Daten: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_actionscheduler_logs: Daten: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_commentmeta: Daten: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_comments: Daten: 0.02MB + Index: 0.09MB + Engine InnoDB
wp_links: Daten: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_options: Daten: 2.39MB + Index: 0.16MB + Engine InnoDB
wp_postmeta: Daten: 2.52MB + Index: 0.42MB + Engine InnoDB
wp_posts: Daten: 7.52MB + Index: 0.36MB + Engine InnoDB
wp_stock_log: Daten: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_termmeta: Daten: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_terms: Daten: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_term_relationships: Daten: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_term_taxonomy: Daten: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_usermeta: Daten: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_users: Daten: 0.02MB + Index: 0.05MB + Engine InnoDB
wp_wc_product_meta_lookup: Daten: 0.02MB + Index: 0.09MB + Engine InnoDB
wp_wc_reserved_stock: Daten: 0.02MB + Index: 0.00MB + Engine InnoDB

### Post Type Counts ###

attachment: 496
custom_css: 1
customize_changeset: 11
et_body_layout: 2
et_footer_layout: 1
et_header_layout: 1
et_pb_layout: 21
et_template: 4
et_theme_builder: 1
kurse: 26
nav_menu_item: 45
page: 78
product: 10
product_variation: 27
revision: 788
termin: 67

### Security ###

Secure connection (HTTPS): ?
Hide errors from visitors: ?

### Active Plugins (9) ###

GDPR Cookie Consent: von WebToffee – 1.9.1
Page scroll to id: von malihu – 1.6.7
Velvet Blues Update URLs: von VelvetBlues.com – 3.2.9
W3 Total Cache: von BoldGrid – 0.14.2
White Label CMS: von www.videousermanuals.com – 2.2
Germanized für WooCommerce: von vendidero – 3.2.0
WooCommerce: von Automattic – 4.5.2
WPFront Scroll Top: von Syam Mohan – 2.0.2
Wupperle Calendar: von Jonas Winzer – 1.0.0

### Inactive Plugins (5) ###

Advanced Database Cleaner: von Younes JFR. – 3.0.0
Custom Post Type Cleanup: von keesiemeijer – 1.3.0
Max Mega Menu: von megamenu.com – 2.8
WooCommerce Stock Manager: von StoreApps – 2.4.0 – Die installierte Version wurde nicht mit der aktiven WooCommerce-Version 4.5.2 getestet
Woo Store Vacation: von MyPreview – 1.3.9 – Die installierte Version wurde nicht mit der aktiven WooCommerce-Version 4.5.2 getestet

### Dropin Plugins (1) ###

advanced-cache.php: advanced-cache.php

### 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)
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: –

### WC Pages ###

Shop-Basis: #2998 - /shop/
Warenkorb: #2911 - /warenkorb/
Kasse: #2912 - /kasse/
Mein Konto: #2906 - /mein-konto/
Allgemeine Gesch?ftsbedingungen: #26 - /agb/

### Theme ###

Name: Divi
Version: 4.4.6
Author URL: https://www.elegantthemes.com
Child Theme: ? – Wenn du WooCommerce mit einem Theme
das du nicht selbst entwickelt hast
an eigene Bedürfnisse anpasst
dann empfehlen wir die Verwendung eines Child-Themes. Siehe Wie du ein Child-Theme erstellst (engl.)

WooCommerce Support: ?

### Templates ###

Overrides: –

### Action Scheduler ###

Abgeschlossen: 53
Oldest: 2020-09-16 12:26:12 +0200
Newest: 2020-09-16 13:27:32 +0200
Viewing 5 replies - 1 through 5 (of 5 total)
  • Plugin Support fevered – a11n

    (@fevered)

    Hey there!

    Did the message you see mention which tables are missing?

    Thread Starter jonaswinz

    (@jonaswinz)

    This is the message:

    Datenbanktabellen fehlen

    Eine oder mehrere Tabellen, die für WooCommerce erforderlich sind, fehlen, sodass manche Features eventuell nicht wie erwartet funktionieren werden. Fehlende Tabellen: wp_woocommerce_sessions, wp_woocommerce_api_keys, wp_woocommerce_attribute_taxonomies, wp_woocommerce_downloadable_product_permissions, wp_woocommerce_order_items, wp_woocommerce_order_itemmeta, wp_woocommerce_tax_rates, wp_woocommerce_tax_rate_locations, wp_woocommerce_shipping_zones, wp_woocommerce_shipping_zone_locations, wp_woocommerce_shipping_zone_methods, wp_woocommerce_payment_tokens, wp_woocommerce_payment_tokenmeta, wp_woocommerce_log, wp_wc_webhooks, wp_wc_download_log, wp_wc_tax_rate_classes.

    If I enable debug mode there are also some php errors:

    Warning: Declaration of ET_Theme_Builder_Woocommerce_Product_Variable_Placeholder::get_available_variations() should be compatible with WC_Product_Variable::get_available_variations($return = ‘array’) in /var/www/html/wp-content/themes/Divi/includes/builder/frontend-builder/theme-builder/WoocommerceProductVariablePlaceholder.php on line 199 Notice: Object of class WP_Post could not be converted to int in /var/www/html/wp-includes/post.php on line 2379
    WordPress-Datenbank-Fehler: [Table ‘wordpress.wp_wc_admin_notes’ doesn’t exist]
    SELECT * FROM wp_wc_admin_notes WHERE 1=1 AND type IN (‘survey’) AND status IN (‘actioned’) AND is_deleted = 0 ORDER BY date_created DESC LIMIT 0, 10

    WordPress-Datenbank-Fehler: [Table ‘wordpress.wp_wc_admin_notes’ doesn’t exist]
    SELECT note_id FROM wp_wc_admin_notes WHERE name = ‘wc-admin-wc-helper-connection’ ORDER BY note_id ASC

    WordPress-Datenbank-Fehler: [Table ‘wordpress.wp_wc_admin_notes’ doesn’t exist]
    SELECT note_id FROM wp_wc_admin_notes WHERE name = ‘wc-admin-wc-helper-connection’ ORDER BY note_id ASC

    WordPress-Datenbank-Fehler: [Table ‘wordpress.wp_wc_admin_notes’ doesn’t exist]
    SELECT note_id FROM wp_wc_admin_notes WHERE name = ‘wc-admin-wc-helper-subscription’ ORDER BY note_id ASC

    WordPress-Datenbank-Fehler: [Table ‘wordpress.wp_wc_admin_notes’ doesn’t exist]
    SHOW FULL COLUMNS FROM wp_wc_admin_notes

    WordPress-Datenbank-Fehler: [Table ‘wordpress.wp_wc_admin_note_actions’ doesn’t exist]
    DELETE FROM wp_wc_admin_note_actions WHERE note_id = 0

    WordPress-Datenbank-Fehler: [Table ‘wordpress.wp_wc_admin_note_actions’ doesn’t exist]
    SHOW FULL COLUMNS FROM wp_wc_admin_note_actions

    WordPress-Datenbank-Fehler: [Table ‘wordpress.wp_wc_admin_note_actions’ doesn’t exist]
    SELECT action_id, name, label, query, status, is_primary, actioned_text FROM wp_wc_admin_note_actions WHERE note_id = 0

    WordPress-Datenbank-Fehler: [Table ‘wordpress.wp_wc_admin_notes’ doesn’t exist]
    SELECT * FROM wp_wc_admin_notes WHERE 1=1 AND name IN (‘wc-admin-coupon-page-moved’) AND is_deleted = 1 ORDER BY date_created DESC LIMIT 0, 10

    WordPress-Datenbank-Fehler: [Table ‘wordpress.wp_wc_admin_notes’ doesn’t exist]
    SELECT * FROM wp_wc_admin_notes WHERE 1=1 AND status IN (‘unactioned’) AND name IN (‘wc-admin-coupon-page-moved’) AND is_deleted = 0 ORDER BY date_created DESC LIMIT 0, 10

    WordPress-Datenbank-Fehler: [Table ‘wordpress.wp_wc_admin_notes’ doesn’t exist]
    SELECT note_id FROM wp_wc_admin_notes WHERE name = ‘wc-admin-onboarding-profiler-reminder’ ORDER BY note_id ASC

    WordPress-Datenbank-Fehler: [Table ‘wordpress.wp_wc_admin_notes’ doesn’t exist]
    SHOW FULL COLUMNS FROM wp_wc_admin_notes

    WordPress-Datenbank-Fehler: [Table ‘wordpress.wp_wc_admin_note_actions’ doesn’t exist]
    DELETE FROM wp_wc_admin_note_actions WHERE note_id = 0

    WordPress-Datenbank-Fehler: [Table ‘wordpress.wp_wc_admin_note_actions’ doesn’t exist]
    SHOW FULL COLUMNS FROM wp_wc_admin_note_actions

    WordPress-Datenbank-Fehler: [Table ‘wordpress.wp_wc_admin_note_actions’ doesn’t exist]
    SHOW FULL COLUMNS FROM wp_wc_admin_note_actions

    WordPress-Datenbank-Fehler: [Table ‘wordpress.wp_wc_admin_note_actions’ doesn’t exist]
    SELECT action_id, name, label, query, status, is_primary, actioned_text FROM wp_wc_admin_note_actions WHERE note_id = 0

    WordPress-Datenbank-Fehler: [Table ‘wordpress.wp_wc_admin_notes’ doesn’t exist]
    SELECT note_id FROM wp_wc_admin_notes WHERE name = ‘wc-update-db-reminder’ ORDER BY note_id ASC

    WordPress-Datenbank-Fehler: [Table ‘wordpress.wp_wc_admin_notes’ doesn’t exist]
    SELECT note_id FROM wp_wc_admin_notes WHERE name = ‘wc-gzd-admin-theme-supported-notice’ ORDER BY note_id ASC

    WordPress-Datenbank-Fehler: [Table ‘wordpress.wp_wc_admin_notes’ doesn’t exist]
    SELECT note_id FROM wp_wc_admin_notes WHERE name = ‘wc-gzd-admin-update-notice’ ORDER BY note_id ASC

    WordPress-Datenbank-Fehler: [Table ‘wordpress.wp_wc_admin_notes’ doesn’t exist]
    SELECT note_id FROM wp_wc_admin_notes WHERE name = ‘wc-gzd-admin-review-notice’ ORDER BY note_id ASC

    WordPress-Datenbank-Fehler: [Table ‘wordpress.wp_wc_admin_notes’ doesn’t exist]
    SELECT note_id FROM wp_wc_admin_notes WHERE name = ‘wc-gzd-admin-review-notice’ ORDER BY note_id ASC

    WordPress-Datenbank-Fehler: [Table ‘wordpress.wp_wc_admin_notes’ doesn’t exist]
    SELECT note_id FROM wp_wc_admin_notes WHERE name = ‘wc-gzd-admin-template-outdated-notice’ ORDER BY note_id ASC

    WordPress-Datenbank-Fehler: [Table ‘wordpress.wp_wc_admin_notes’ doesn’t exist]
    SELECT note_id FROM wp_wc_admin_notes WHERE name = ‘wc-gzd-admin-template-outdated-notice’ ORDER BY note_id ASC

    WordPress-Datenbank-Fehler: [Table ‘wordpress.wp_wc_admin_notes’ doesn’t exist]
    SELECT note_id FROM wp_wc_admin_notes WHERE name = ‘wc-gzd-admin-pro-notice’ ORDER BY note_id ASC

    WordPress-Datenbank-Fehler: [Table ‘wordpress.wp_wc_admin_notes’ doesn’t exist]
    SELECT note_id FROM wp_wc_admin_notes WHERE name = ‘wc-gzd-admin-pro-notice’ ORDER BY note_id ASC

    WordPress-Datenbank-Fehler: [Table ‘wordpress.wp_wc_admin_notes’ doesn’t exist]
    SELECT note_id FROM wp_wc_admin_notes WHERE name = ‘wc-gzd-admin-dhl-importer-notice’ ORDER BY note_id ASC

    WordPress-Datenbank-Fehler: [Table ‘wordpress.wp_woocommerce_gzd_shipments’ doesn’t exist]
    SELECT COUNT( * ) FROM wp_woocommerce_gzd_shipments WHERE shipment_status = ‘gzd-requested’ and shipment_type = ‘return’

    Plugin Support fevered – a11n

    (@fevered)

    Thanks for all those details!

    What I’d suggest trying first would be to switch to a default theme, and disable all plugins except for WooCommerce – after that, try and update the database and see if the tables are created

    If they still aren’t created, I would check your database permissions to make sure that is not an issue

    Thread Starter jonaswinz

    (@jonaswinz)

    Ok, I fixed the issue: I logged in to PHPMyAdmin and tried to create one of the missing databases by myself… This error occurred: https://stackoverflow.com/questions/15694168/error-tablespace-for-table-xxx-exists-please-discard-the-tablespace-before-imp

    My solution: exporting the whole database, deleting it, and reimporting

    Plugin Support fevered – a11n

    (@fevered)

    Glad to hear you were able to resolve it – thanks for letting us know what the fix was!

    I’ll mark this thread as resolved now. If you have any further questions, I recommend creating a new thread.

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

Tags