Support » Plugin: WooCommerce » Missing table after updating to WooCommerce 6.5

  • Resolved hbee

    (@heatherbodlak)


    I updated WooCommerce to 6.5 and am seeing the following message:

    Missing tables: wp_wc_product_download_directories

    I uninstalled and re-installed the plugin, but that message continues to appear.

    What can i do to correct this?? Is that table necessary? what happens if I ignore the message?

Viewing 15 replies - 1 through 15 (of 21 total)
  • Hello,

    As a first step, can you please share a copy of your site’s System Status? You can find it via WooCommerce > Status. Select “Get system report” and then “Copy for support”.  Once you’ve done that, paste it here in your response.

    Please also share a copy of the fatal error log found under WooCommerce > System Status > Logs (if available).

    Thread Starter hbee

    (@heatherbodlak)

    hi!
    step 1 — site’s System Status:

    
    ### WordPress Environment ###
    
    WordPress address (URL): https://herfraga.com
    Site address (URL): https://herfraga.com
    WC Version: 6.5.0
    REST API Version: ✔ 6.5.0
    WC Blocks Version: ✔ 7.4.3
    Action Scheduler Version: ✔ 3.4.0
    Log Directory Writable: ✔
    WP Version: 5.9.3
    WP Multisite: –
    WP Memory Limit: 256 MB
    WP Debug Mode: –
    WP Cron: ✔
    Language: es_ES
    External object cache: –
    
    ### Server Environment ###
    
    Server Info: Apache
    PHP Version: 7.4.29
    PHP Post Max Size: 20 MB
    PHP Time Limit: 30
    PHP Max Input Vars: 1000
    cURL Version: 7.52.1
    OpenSSL/1.0.2u
    
    SUHOSIN Installed: –
    MySQL Version: 5.5.5-10.1.48-MariaDB-0+deb9u2
    Max Upload Size: 20 MB
    Default Timezone is UTC: ✔
    fsockopen/cURL: ✔
    SoapClient: ✔
    DOMDocument: ✔
    GZip: ✔
    Multibyte String: ✔
    Remote Post: ✔
    Remote Get: ✔
    
    ### Database ###
    
    WC Database Version: 6.5.0
    WC Database Prefix: wp_
    Tamaño total de la base de datos: 17.42MB
    Tamaño de los datos de la base de datos: 15.29MB
    Tamaño del índice de la base de datos: 2.13MB
    wp_woocommerce_sessions: Datos: 0.02MB + Índice: 0.02MB + Motor InnoDB
    wp_woocommerce_api_keys: Datos: 0.02MB + Índice: 0.03MB + Motor InnoDB
    wp_woocommerce_attribute_taxonomies: Datos: 0.02MB + Índice: 0.02MB + Motor InnoDB
    wp_woocommerce_downloadable_product_permissions: Datos: 0.02MB + Índice: 0.06MB + Motor InnoDB
    wp_woocommerce_order_items: Datos: 0.02MB + Índice: 0.02MB + Motor InnoDB
    wp_woocommerce_order_itemmeta: Datos: 0.02MB + Índice: 0.03MB + Motor InnoDB
    wp_woocommerce_tax_rates: Datos: 0.02MB + Índice: 0.06MB + Motor InnoDB
    wp_woocommerce_tax_rate_locations: Datos: 0.02MB + Índice: 0.03MB + Motor InnoDB
    wp_woocommerce_shipping_zones: Datos: 0.02MB + Índice: 0.00MB + Motor InnoDB
    wp_woocommerce_shipping_zone_locations: Datos: 0.02MB + Índice: 0.03MB + Motor InnoDB
    wp_woocommerce_shipping_zone_methods: Datos: 0.02MB + Índice: 0.00MB + Motor InnoDB
    wp_woocommerce_payment_tokens: Datos: 0.02MB + Índice: 0.02MB + Motor InnoDB
    wp_woocommerce_payment_tokenmeta: Datos: 0.02MB + Índice: 0.03MB + Motor InnoDB
    wp_woocommerce_log: Datos: 0.02MB + Índice: 0.02MB + Motor InnoDB
    wp_actionscheduler_actions: Datos: 0.02MB + Índice: 0.13MB + Motor InnoDB
    wp_actionscheduler_claims: Datos: 0.02MB + Índice: 0.02MB + Motor InnoDB
    wp_actionscheduler_groups: Datos: 0.02MB + Índice: 0.02MB + Motor InnoDB
    wp_actionscheduler_logs: Datos: 0.02MB + Índice: 0.03MB + Motor InnoDB
    wp_commentmeta: Datos: 0.02MB + Índice: 0.03MB + Motor InnoDB
    wp_comments: Datos: 0.02MB + Índice: 0.09MB + Motor InnoDB
    wp_e_events: Datos: 0.02MB + Índice: 0.02MB + Motor InnoDB
    wp_ff_scheduled_actions: Datos: 0.02MB + Índice: 0.00MB + Motor InnoDB
    wp_fluentform_entry_details: Datos: 0.02MB + Índice: 0.00MB + Motor InnoDB
    wp_fluentform_forms: Datos: 0.02MB + Índice: 0.00MB + Motor InnoDB
    wp_fluentform_form_analytics: Datos: 0.02MB + Índice: 0.00MB + Motor InnoDB
    wp_fluentform_form_meta: Datos: 0.02MB + Índice: 0.00MB + Motor InnoDB
    wp_fluentform_logs: Datos: 0.02MB + Índice: 0.00MB + Motor InnoDB
    wp_fluentform_submissions: Datos: 0.02MB + Índice: 0.00MB + Motor InnoDB
    wp_fluentform_submission_meta: Datos: 0.02MB + Índice: 0.00MB + Motor InnoDB
    wp_links: Datos: 0.02MB + Índice: 0.02MB + Motor InnoDB
    wp_options: Datos: 3.05MB + Índice: 0.08MB + Motor InnoDB
    wp_postmeta: Datos: 7.52MB + Índice: 0.42MB + Motor InnoDB
    wp_posts: Datos: 3.52MB + Índice: 0.13MB + Motor InnoDB
    wp_sbi_instagram_feeds_posts: Datos: 0.02MB + Índice: 0.03MB + Motor InnoDB
    wp_sbi_instagram_feed_locator: Datos: 0.02MB + Índice: 0.03MB + Motor InnoDB
    wp_sbi_instagram_posts: Datos: 0.02MB + Índice: 0.00MB + Motor InnoDB
    wp_termmeta: Datos: 0.02MB + Índice: 0.03MB + Motor InnoDB
    wp_terms: Datos: 0.02MB + Índice: 0.03MB + Motor InnoDB
    wp_term_relationships: Datos: 0.02MB + Índice: 0.02MB + Motor InnoDB
    wp_term_taxonomy: Datos: 0.02MB + Índice: 0.03MB + Motor InnoDB
    wp_tm_taskmeta: Datos: 0.02MB + Índice: 0.03MB + Motor InnoDB
    wp_tm_tasks: Datos: 0.02MB + Índice: 0.02MB + Motor InnoDB
    wp_usermeta: Datos: 0.02MB + Índice: 0.03MB + Motor InnoDB
    wp_users: Datos: 0.02MB + Índice: 0.05MB + Motor InnoDB
    wp_wc_admin_notes: Datos: 0.06MB + Índice: 0.00MB + Motor InnoDB
    wp_wc_admin_note_actions: Datos: 0.02MB + Índice: 0.02MB + Motor InnoDB
    wp_wc_category_lookup: Datos: 0.02MB + Índice: 0.00MB + Motor InnoDB
    wp_wc_customer_lookup: Datos: 0.02MB + Índice: 0.03MB + Motor InnoDB
    wp_wc_download_log: Datos: 0.02MB + Índice: 0.03MB + Motor InnoDB
    wp_wc_order_coupon_lookup: Datos: 0.02MB + Índice: 0.03MB + Motor InnoDB
    wp_wc_order_product_lookup: Datos: 0.02MB + Índice: 0.06MB + Motor InnoDB
    wp_wc_order_stats: Datos: 0.02MB + Índice: 0.05MB + Motor InnoDB
    wp_wc_order_tax_lookup: Datos: 0.02MB + Índice: 0.03MB + Motor InnoDB
    wp_wc_product_attributes_lookup: Datos: 0.02MB + Índice: 0.02MB + Motor InnoDB
    wp_wc_product_meta_lookup: Datos: 0.02MB + Índice: 0.09MB + Motor InnoDB
    wp_wc_rate_limits: Datos: 0.02MB + Índice: 0.02MB + Motor InnoDB
    wp_wc_reserved_stock: Datos: 0.02MB + Índice: 0.00MB + Motor InnoDB
    wp_wc_tax_rate_classes: Datos: 0.02MB + Índice: 0.02MB + Motor InnoDB
    wp_wc_webhooks: Datos: 0.02MB + Índice: 0.02MB + Motor InnoDB
    wp_yith_wcwl: Datos: 0.02MB + Índice: 0.02MB + Motor InnoDB
    wp_yith_wcwl_lists: Datos: 0.02MB + Índice: 0.03MB + Motor InnoDB
    
    ### Post Type Counts ###
    
    attachment: 170
    custom_css: 1
    customize_changeset: 33
    elementor_library: 15
    nav_menu_item: 20
    page: 76
    polylang_mo: 1
    post: 13
    product: 11
    revision: 192
    rtrs: 3
    techkit_case: 12
    techkit_event: 1
    techkit_service: 10
    techkit_team: 10
    techkit_testim: 7
    wp_global_styles: 1
    
    ### Security ###
    
    Secure connection (HTTPS): ✔
    Hide errors from visitors: ✔
    
    ### Active Plugins (14) ###
    
    Breadcrumb NavXT: por John Havlik | Traducción: Karin Sequén – 7.0.2
    CMP - Coming Soon & Maintenance Plugin: por NiteoThemes – 4.1.1
    Elementor: por Elementor.com – 3.6.5
    Fluent Forms: por Formulario de contacto - WPManageNinja LLC – 4.3.5
    Loco Translate: por Tim Whitlock – 2.6.1
    Really Simple SSL: por Really Simple Plugins – 5.3.2
    RT Demo Importer: por RadiusTheme – 4.3
    RT Framework: por RadiusTheme – 2.4
    Techkit Core: por RadiusTheme – 1.2
    Username Changer: por Widgit Team – 3.2.2
    Proxy Cache Purge: por Mika Epstein – 5.1.2
    WooCommerce: por Automattic – 6.5.0
    WordPress Optimizado: por  – 1.0.3
    WP Rollback: por GiveWP.com – 1.7.1
    
    ### Inactive Plugins (7) ###
    
    Antispam Bee: por pluginkollektiv – 2.11.0
    Autoptimize: por Frank Goossens (futtta) – 3.0.4
    Limit Login Attempts Reloaded: por Limit Login Attempts Reloaded – 2.25.1
    Polylang: por WP SYNTEX – 3.2.2
    Polylang Connect for Elementor: por Creame – 2.0.8
    Review Schema: por RadiusTheme – 1.1.13
    Review Schema Pro: por RadiusTheme – 1.0.2
    
    ### 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: –
    
    ### WC Pages ###
    
    Base de la tienda: #6975 - /shop/
    Carrito: #6976 - /cart/
    Finalizar compra: #6977 - /checkout/
    Mi cuenta: #6978 - /my-account/
    Términos y condiciones: ❌ Página sin definir
    
    ### Theme ###
    
    Name: Techkit
    Version: 1.4
    Author URL: http://radiustheme.com
    Child Theme: ❌ – Si estás modificando WooCommerce en un tema padre que no has creado personalmente
    te recomendamos utilizar un tema hijo. Ver: Cómo crear un tema hijo
    
    WooCommerce Support: ✔
    
    ### Templates ###
    
    Overrides: techkit/woocommerce/archive-product.php
    techkit/woocommerce/checkout/form-checkout.php
    techkit/woocommerce/content-product.php
    techkit/woocommerce/content-single-product.php
    techkit/woocommerce/global/quantity-input.php
    techkit/woocommerce/single-product/title.php
    techkit/woocommerce/single-product.php
    
    ### Action Scheduler ###
    
    Completo: 41
    Oldest: 2022-05-04 11:06:46 +0000
    Newest: 2022-05-11 14:15:24 +0000
    
    ### Status report information ###
    
    Generated at: 2022-05-11 14:28:34 +00:00
    

    Error Log: (it’s in spanish)

    2022-05-11T13:15:18+00:00 WARNING No se han podido sincronizar los directorios de descarga tras la actualización a la versión 6.4.0.

    —-> translated:
    WARNING Failed to sync download directories after upgrade to version 6.4.0.

    Plugin Support Mirko P.

    (@rainfallnixfig)

    Hi there,

    Thank you for sending over your system status.

    It looks like the table wc_product_download_directories was not created with your recent WC database update. Can you temporarily switch your theme to Storefront, disable all plugins except WooCommerce and retry a database update from:

    WooCommerce → Status → Tools → Update database


    Full Size: https://snipboard.io/i8eTUn.jpg

    You can then also Verify base database tables (option below update database) to verify if all base database tables are present.

    If this doesn’t work, I’d suggest asking your host if they can assist in creating the table for you in the database.

    Let us know how it goes.

    Thread Starter hbee

    (@heatherbodlak)

    I tried all of that — no luck.
    I will contact my hosting provider…

    Plugin Support Mirko P.

    (@rainfallnixfig)

    Sounds good! Hopefully, they can add the table and fix it for you.

    If you have any other questions please feel free to open a new topic.

    Best.

    Thread Starter hbee

    (@heatherbodlak)

    What data, how many columns, does that table have to contain??

    Thread Starter hbee

    (@heatherbodlak)

    What should I put in these fields to create the table?

    https://ibb.co/XLyp361

    Thread Starter hbee

    (@heatherbodlak)

    They tell me they can add the table, but need more information to do so.

    https://ibb.co/XLyp361

    I’m having the same issue, this is the error

    
    [11-May-2022 14:57:07 UTC] WordPress database error Index column size too large. The maximum column size is 767 bytes. for query 
    CREATE TABLE wp_wc_product_download_directories (
    	url_id BIGINT UNSIGNED NOT NULL auto_increment,
    	url varchar(256) NOT NULL,
    	enabled TINYINT(1) NOT NULL DEFAULT 0,
    	PRIMARY KEY (url_id),
    	KEY <code>url</code> (<code>url</code>)
    ) DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci made by do_action('woocommerce_page_wc-status'), WP_Hook->do_action, WP_Hook->apply_filters, WC_Admin_Menus->status_page, WC_Admin_Status::output, include_once('/plugins/woocommerce/includes/admin/views/html-admin-page-status.php'), WC_Admin_Status::status_tools, WC_REST_System_Status_Tools_V2_Controller->execute_tool, WC_Install::verify_base_tables, WC_Install::create_tables, dbDelta
    

    Where it says

    KEY <code>url</code> (<code>url</code>)
    caused by back ticks in the error message

    When I try to create it manually, I get this error, only on one website:

    #1709 – Index column size too large. The maximum column size is 767 bytes.

    I’m guessing this is an MySQL configuration issue.

    Anyone at @woocommerce has an idea on how to fix it?

    INODB Table indexes on varchar are limited to 767 bytes. urf8mb uses 4 bytes for each character. This means the the max size for a varchar column that is indexed is 191 characters.

    • This reply was modified 6 months, 2 weeks ago by John Huebner.

    I think @woocommerce needs to rethink this field size then.

    With MyISAM the table was created but I got this warning:

    Warning: #1071 Specified key was too long; max key length is 1000 bytes

    This error is generated because of a update to MariaDB. It used to let these things pass but that basically makes the index useless. Now it checks and causes an error.

    Or it could be the error is because the column is used as the unique key that it issues an error instead of a warning. meta_key in the _postmeta table is still 255 characters even though this makes the index on that column relatively useless, but that column is not used for as a unique key. It took years to get the issues resolved for option_name in the _options table.

Viewing 15 replies - 1 through 15 (of 21 total)
  • The topic ‘Missing table after updating to WooCommerce 6.5’ is closed to new replies.