Return to previous page

Urgent: Error Establishing a data connection | Error Establishing a data connection

This topic has 2 replies, 2 voices, and was last updated 2 weeks, 2 days ago ago by Jack Richardson

Mark

Participant

April 29, 2024 at 09:25

Good day, 8Theme Team

Please see email below for your reference and assistance.

In addition, see Jessica and Renee comments from Xneelo: Please note that this issue is separate from the shopping cart issue discussed, however, it is crucial this is resolved. The developers troubleshooting the shopping cart issue were unable to troubleshoot successfully due to the database connection error. Customers will also struggle to make purchases when the limit is reached.

Dear Chad,

Thank you for your email.

I created a new database called homeaekgbw_db_658 (sql53.jnb1.host-h.net) and made a copy of the current database. I was able to convert the tables to MyISAM and do the repair and optimize, however, there were two tables that could not be converted due to the following error:

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

MyISAM unfortunately does not support key lengths larger than 1000 bytes. Below are the details of the two tables on how they were created:

pt_wc_orders_meta:
CREATE TABLE pt_wc_orders_meta (
id bigint(20) unsigned NOT NULL AUTO_INCREMENT,
order_id bigint(20) unsigned DEFAULT NULL,
meta_key varchar(255) DEFAULT NULL,
meta_value text DEFAULT NULL,
PRIMARY KEY (id),
KEY meta_key_value (meta_key,meta_value(100)),
KEY order_id_meta_key_meta_value (order_id,meta_key,meta_value(100))
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci

pt_wc_orders
CREATE TABLE pt_wc_orders (
id bigint(20) unsigned NOT NULL,
status varchar(20) DEFAULT NULL,
currency varchar(10) DEFAULT NULL,
type varchar(20) DEFAULT NULL,
tax_amount decimal(26,8) DEFAULT NULL,
total_amount decimal(26,8) DEFAULT NULL,
customer_id bigint(20) unsigned DEFAULT NULL,
billing_email varchar(320) DEFAULT NULL,
date_created_gmt datetime DEFAULT NULL,
date_updated_gmt datetime DEFAULT NULL,
parent_order_id bigint(20) unsigned DEFAULT NULL,
payment_method varchar(100) DEFAULT NULL,
payment_method_title text DEFAULT NULL,
transaction_id varchar(100) DEFAULT NULL,
ip_address varchar(100) DEFAULT NULL,
user_agent text DEFAULT NULL,
customer_note text DEFAULT NULL,
PRIMARY KEY (id),
KEY status (status),
KEY date_created (date_created_gmt),
KEY customer_id_billing_email (customer_id,billing_email),
KEY billing_email (billing_email),
KEY type_status (type,status),
KEY parent_order_id (parent_order_id),
KEY date_updated (date_updated_gmt)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci

The above two tables would need to be investigated to see if they are needed.

The rest of the tables have gone through the repair and optimize and all completed with no issue and I have converted it back to the InnoDB engine.

Kind Regards,
Rene Smitsdorff
Senior Technical Customer Support Consultant

Files is visible for topic creator and
support staff only.

#393331 Copied Theme version: 9.3.7

1 Answer

Jack Richardson

Support staff

April 29, 2024 at 10:34

Dear @Mark,

Thank you for reaching out and for your understanding. We appreciate your engagement with our forum and your interest in resolving any issues you may encounter. However, it’s important to note that our primary focus is to provide support for our XStore Theme and associated plugins, as outlined in our support documentation (https://prnt.sc/Qxw4-Z5LhaOC).

While we strive to assist our users to the best of our ability, questions regarding server configuration often fall outside the scope of our expertise. We believe that directing such inquiries to your hosting provider, who specializes in server-related matters, would yield the most effective and accurate solutions. They possess the industry-specific knowledge and resources necessary to address your concerns promptly. You can find more information about the scope of our support in our documentation [here](https://xstore.helpscoutdocs.com/article/25-support).

Rest assured, we remain committed to assisting you with any inquiries directly related to our products. Should you have any further questions or require assistance within our domain of expertise, please don’t hesitate to reach out. We are here to help.

Thank you once again for your understanding and cooperation.

Best regards,
Jack Richardson

#393345 Copied
Tagged: best selling woocommerce themes, data connection error solution, fast woocommerce connection fix, reliable woocommerce error solutions, troubleshoot woocommerce connection error, urgent woocommerce fix
Viewing 2 results - 1 through 2 (of 2 total)