WordPress database error Specified key was too long

Resolved wpodeskstar
(@wpodeskstar)

6 years, 1 month ago

wp-admin/error.log is reporting the following error: Any help would be appreciated.

[31-Mar-2020 19:05:01 UTC] WordPress database error Specified key was too long; max key length is 767 bytes for query
CREATE TABLE IF NOT EXISTS wp_woocommerce_square_customers (
square_id varchar(200) NOT NULL,
email_address varchar(200) NOT NULL,
user_id BIGINT UNSIGNED NOT NULL,
PRIMARY KEY (square_id)
) DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci made by require_once(‘wp-admin/admin.php’), require_once(‘wp-load.php’), require_once(‘wp-config.php’), require_once(‘wp-settings.php’), do_action(‘wp_loaded’), WP_Hook->do_action, WP_Hook->apply_filters, SkyVerge\WooCommerce\PluginFramework\v5_4_0\Plugin\Lifecycle->init, WooCommerce\Square\Lifecycle->install, WooCommerce\Square\Gateway\Customer_Helper::create_table, dbDelta
[31-Mar-2020 19:06:43 UTC] WordPress database error Table ‘boxzero_wpbetterness.wp_woocommerce_square_customers’ doesn’t exist for query INSERT INTO wp_woocommerce_square_customers (square_id, email_address) VALUES (‘GNHDW0MSG57MWWM2JAH6PTJSNM’, ”), (‘5173CBSCW53CEPQB6GTWGJ77V4’, ”) ON DUPLICATE KEY UPDATE email_address = VALUES(email_address) made by do_action(‘wp_ajax_as_async_request_queue_runner’), WP_Hook->do_action, WP_Hook->apply_filters, WP_Async_Request->maybe_handle, ActionScheduler_AsyncRequest_QueueRunner->handle, do_action(‘action_scheduler_run_queue’), WP_Hook->do_action, WP_Hook->apply_filters, ActionScheduler_QueueRunner->run, ActionScheduler_QueueRunner->do_batch, ActionScheduler_Abstract_QueueRunner->process_action, ActionScheduler_Action->execute, do_action_ref_array(‘wc_square_index_customers’), WP_Hook->do_action, WP_Hook->apply_filters, WooCommerce\Square\Handlers\Connection->index_customers, WooCommerce\Square\Gateway\Customer_Helper::add_customers
[01-Apr-2020 18:34:28 UTC] PHP Warning: call_user_func_array() expects parameter 1 to be a valid callback, function ‘_return_true’ not found or invalid function name in /”mysiteinfo”/wp-includes/class-wp-hook.php on line 288

The page I need help with: [log in to see the link]

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

Plugin Support

(@aashik)

Hi there!

For further investigation on this, could 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.

Thank you for working with us on this.

Thread Starter

wpodeskstar

(@wpodeskstar)

6 years, 1 month ago


### WordPress Environment ###

WordPress address (URL): https://betterness.com
Site address (URL): https://betterness.com
WC Version: 4.0.1
REST API Version: ✔ 1.0.7
WC Blocks Version: ✔ 2.5.14
Action Scheduler Version: ✔ 3.1.4
WC Admin Version: ✔ 1.0.3
Log Directory Writable: ✔
WP Version: ❌ 5.3.2 - There is a newer version of WordPress available (5.4)
WP Multisite: –
WP Memory Limit: 256 MB
WP Debug Mode: –
WP Cron: ✔
Language: en_US
External object cache: –

### Server Environment ###

Server Info: Apache
PHP Version: 7.2.29
PHP Post Max Size: 1,000 MB
PHP Time Limit: 300
PHP Max Input Vars: 1000
cURL Version: 7.68.0
OpenSSL/1.1.1d

SUHOSIN Installed: –
MySQL Version: 5.5.5-10.1.44-MariaDB
Max Upload Size: 1,000 MB
Default Timezone is UTC: ✔
fsockopen/cURL: ✔
SoapClient: ✔
DOMDocument: ✔
GZip: ✔
Multibyte String: ✔
Remote Post: ✔
Remote Get: ✔

### Database ###

WC Database Version: 4.0.1
WC Database Prefix: wp_
Total Database Size: 7.03MB
Database Data Size: 5.47MB
Database Index Size: 1.56MB
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.02MB + Index: 0.11MB + 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.02MB + Index: 0.03MB + Engine InnoDB
wp_blc_filters: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_blc_instances: Data: 0.05MB + Index: 0.05MB + Engine InnoDB
wp_blc_links: Data: 0.19MB + Index: 0.06MB + Engine InnoDB
wp_blc_synch: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_commentmeta: Data: 0.08MB + Index: 0.03MB + Engine InnoDB
wp_comments: Data: 0.14MB + Index: 0.09MB + Engine InnoDB
wp_links: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_mgmlp_folders: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_options: Data: 2.44MB + Index: 0.06MB + Engine InnoDB
wp_postmeta: Data: 0.20MB + Index: 0.03MB + Engine InnoDB
wp_posts: Data: 1.39MB + Index: 0.06MB + Engine InnoDB
wp_shipment_batch_process: Data: 0.02MB + Index: 0.00MB + 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.02MB + Index: 0.02MB + Engine InnoDB
wp_term_taxonomy: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_usermeta: Data: 0.05MB + Index: 0.03MB + Engine InnoDB
wp_users: Data: 0.02MB + Index: 0.05MB + Engine InnoDB
wp_wc_admin_notes: Data: 0.02MB + 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_tax_rate_classes: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_wc_webhooks: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_woo_shippment_provider: Data: 0.06MB + Index: 0.00MB + Engine InnoDB
wp_yoast_seo_links: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_yoast_seo_meta: Data: 0.05MB + Index: 0.00MB + Engine InnoDB

### Post Type Counts ###

attachment: 65
customize_changeset: 3
mgmlp_media_folder: 14
nav_menu_item: 3
page: 12
popup: 2
popup_theme: 6
post: 14
product: 2
revision: 73
shop_order: 1
tablepress_table: 2
wpforms: 1

### Security ###

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

### Active Plugins (29) ###

Akismet Anti-Spam: by Automattic – 4.1.3
Automatic Copyright Year: by WPSOS – 1.1
Broken Link Checker: by ManageWP – 1.11.11
Classic Editor: by WordPress Contributors – 1.5
WooCommerce Continue Shopping: by HappyKite – 1.4.2
Forget About Shortcode Buttons: by Designs & Code – 2.1.2
GTranslate: by Translate AI Multilingual Solutions – 2.8.54
HeatMap AdAptive Pro Plugin: by Stuart Wider – 1.1.3
Limit Login Attempts Reloaded: by WPChef – 2.10.0
Menu Icons: by ThemeIsle – 0.12.2
Open External Links in a New Window: by WebFactory Ltd – 1.4
Popup Maker: by Popup Maker – 1.9.1
Postmen Woocommerce Shipping: by <a href="https://www.postmen.com/">Postmen</a> – 1.2.3 – Not tested with the active version of WooCommerce
Really Simple SSL: by Rogier Lankhorst
Mark Wolters – 3.3

Rearrange Woocommerce Products: by Aslam Doctor – 2.2.0 – Not tested with the active version of WooCommerce
Revision Control: by Dion Hulse – 2.3.2
WooCommerce Shipping Label (BASIC): by WebToffee – 2.3.3 – Not tested with the active version of WooCommerce
Supreme Google Webfonts: by Josh Lobe
igmoweb – 2.0.1

TablePress Extension: Automatic URL conversion: by Tobias Bäthge – 1.3
TablePress: by Tobias Bäthge – 1.10
TinyMCE Advanced: by Andrew Ozz – 5.3.0
TinyMCE Spellcheck: by Matthew Muro – 1.3
Video.js - HTML5 Video Player for WordPress: by <a href="http://www.nosecreekweb.ca">Dustin Lammiman</a>
<a href="http://steveheffernan.com">Steve Heffernan</a> – 4.5.0

Widget Options: by Widget Options Team – 3.7.4
Advanced Shipment Tracking for WooCommerce: by zorem – 2.9.0
WooCommerce Square: by WooCommerce – 2.1.1
WooCommerce: by Automattic – 4.0.1
Yoast SEO: by Team Yoast – 13.3
WPForms Lite: by WPForms – 1.5.8.2

### Inactive Plugins (7) ###

Advanced TinyMCE Configuration: by Andrew Ozz – 1.5
HeatMap AdAptive Post Nav Top: by Stuart Wider – 1.0.0
Media Library Folders for WordPress: by Max Foundry – 5.1.9
Media Library Folders for WordPress Reset: by Max Foundry – 5.1.9
Pure Chat: by Pure Chat
Inc. – 2.21

WooCommerce PayPal Checkout Gateway: by WooCommerce – 1.6.20 – Not tested with the active version of WooCommerce
WooCommerce Services: by Automattic – 1.22.5 – 1.23.0 is available

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

### WC Pages ###

Shop base: #411 - /shop/
Cart: #412 - /cart/
Checkout: #413 - /checkout/
My account: #414 - /my-account/
Terms and conditions: ❌ Page not set

### Theme ###

Name: HeatMap AdAptive
Version: 1.5.3
Author URL: http://heatmaptheme.com
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: ❌ Not declared

### Templates ###

Overrides: –

### Square ###

Environment: Production
Tokenization Enabled: –
Debug Mode: Off

### Action Scheduler ###

Complete: 41
Oldest: 2020-03-31 18:09:11 +0000
Newest: 2020-04-09 18:28:52 +0000

Pending: 1
Oldest: 2020-04-14 19:09:02 +0000
Newest: 2020-04-14 19:09:02 +0000

Plugin Support

Aashik P – a11n

(@aashik)

6 years, 1 month ago

Hello @wpodeskstar

Thank you for getting back to us with the System Status Report.

I did some further digging to find that it is likely caused by an existing bug in the extension that can be replicated on servers where default database collation is utf8mb4.

For confirmation on that, please follow the steps below:

1. Reach out to your WebHost to confirm that they have the complete, working backup of your store (including Database).
2. Request them to run the following SQL query on your store database:

CREATE TABLE IF NOT EXISTS wp_woocommerce_square_customers (
square_id varchar(190) NOT NULL,
email_address varchar(200) NOT NULL,
user_id BIGINT UNSIGNED NOT NULL,
PRIMARY KEY (square_id))

3. Attempt to make a test order using Square to see if the behavior can still be replicated.

—

Please do note that these instructions are developer level. If you’re not comfortable working with databases, and your WebHost cannot help you with the above, please hire a dev and request them to follow the instructions here.

—

Thank you for working with us on this.

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

The topic ‘WordPress database error Specified key was too long’ is closed to new replies.