Missing table after updating to WooCommerce 6.5

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).

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: https://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.

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.

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

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.

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

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

https://ibb.co/XLyp361

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 2 years, 6 months 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.