Title: HPOS Problem
Last modified: August 11, 2023

---

# HPOS Problem

 *  Resolved [moultrex](https://wordpress.org/support/users/moultrex/)
 * (@moultrex)
 * [2 years, 9 months ago](https://wordpress.org/support/topic/hpos-problem/)
 * Hello. Latest Woocommerce version does not work correctly on some shared hosting
   environments that you can not change database configuration.
 * It is the same problem as mentioned here
 * [https://wordpress.org/support/topic/issues-with-hpos/](https://wordpress.org/support/topic/issues-with-hpos/)
 * Your workaround is to change some database values in the config file but you 
   did not took into considateration many hosting providers especially shared hosting
   ones, do not let you change that.
 * Please fix it or make a workaround to this.
 *     ```wp-block-code
       CREATE TABLE wp80_wc_orders (
       	id bigint(20) unsigned,
       	status varchar(20) null,
       	currency varchar(10) null,
       	type varchar(20) null,
       	tax_amount decimal(26,8) null,
       	total_amount decimal(26,8) null,
       	customer_id bigint(20) unsigned null,
       	billing_email varchar(320) null,
       	date_created_gmt datetime null,
       	date_updated_gmt datetime null,
       	parent_order_id bigint(20) unsigned null,
       	payment_method varchar(100) null,
       	payment_method_title text null,
       	transaction_id varchar(100) null,
       	ip_address varchar(100) null,
       	user_agent text null,
       	customer_note text 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)
       ) DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci made by activate_plugin, do_action('activate_woocommerce/woocommerce.php'), WP_Hook->do_action, WP_Hook->apply_filters, WC_Install::install, WC_Install::create_options, add_option, do_action('added_option'), WP_Hook->do_action, WP_Hook->apply_filters, Automattic\WooCommerce\Internal\Features\FeaturesController->__call, call_user_func_array, Automattic\WooCommerce\Internal\Features\FeaturesController->process_added_option, Automattic\WooCommerce\Internal\Features\FeaturesController->process_updated_option, do_action('woocommerce_feature_enabled_changed'), WP_Hook->do_action, WP_Hook->apply_filters, Automattic\WooCommerce\Internal\DataStores\Orders\CustomOrdersTableController->__call, call_user_func_array, Automattic\WooCommerce\Internal\DataStores\Orders\CustomOrdersTableController->handle_data_sync_option_changed, Automattic\WooCommerce\Internal\DataStores\Orders\DataSynchronizer->create_database_tables, Automattic\WooCommerce\Internal\Utilities\DatabaseUtil->dbdelta, dbDelta, QM_DB->query
       [11-Aug-2023 12:35:54 UTC] WordPress database error Specified key was too long; max key length is 1000 bytes for query
       ```
   
 *     ```wp-block-code
       CREATE TABLE wp80_wc_orders_meta (
       	id bigint(20) unsigned auto_increment primary key,
       	order_id bigint(20) unsigned null,
       	meta_key varchar(255),
       	meta_value text null,
       	KEY meta_key_value (meta_key, meta_value(100)),
       	KEY order_id_meta_key_meta_value (order_id, meta_key, meta_value(100))
       ) DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci made by activate_plugin, do_action('activate_woocommerce/woocommerce.php'), WP_Hook->do_action, WP_Hook->apply_filters, WC_Install::install, WC_Install::create_options, add_option, do_action('added_option'), WP_Hook->do_action, WP_Hook->apply_filters, Automattic\WooCommerce\Internal\Features\FeaturesController->__call, call_user_func_array, Automattic\WooCommerce\Internal\Features\FeaturesController->process_added_option, Automattic\WooCommerce\Internal\Features\FeaturesController->process_updated_option, do_action('woocommerce_feature_enabled_changed'), WP_Hook->do_action, WP_Hook->apply_filters, Automattic\WooCommerce\Internal\DataStores\Orders\CustomOrdersTableController->__call, call_user_func_array, Automattic\WooCommerce\Internal\DataStores\Orders\CustomOrdersTableController->handle_data_sync_option_changed, Automattic\WooCommerce\Internal\DataStores\Orders\DataSynchronizer->create_database_tables, Automattic\WooCommerce\Internal\Utilities\DatabaseUtil->dbdelta, dbDelta, QM_DB->query
       ```
   

Viewing 1 replies (of 1 total)

 *  [anastas10s](https://wordpress.org/support/users/anastas10s/)
 * (@anastas10s)
 * [2 years, 8 months ago](https://wordpress.org/support/topic/hpos-problem/#post-16976489)
 * Hi there [@moultrex](https://wordpress.org/support/users/moultrex/) 👋
 * Thank you for contacting Woo support, and for your patience! We are experiencing
   an unusually high volume of support requests at the moment, and that has affected
   our response times.
 * > Latest Woocommerce version does not work correctly on some shared hosting environments
   > that you can not change database configuration.
 * From what I gather, you have identified a limitation with what some shared hosting
   environments allow, with regard to SQL code being too large.
 * As I understand, you went ahead with commenting about this [on GitHub, over here](https://github.com/woocommerce/woocommerce/issues/34849#issuecomment-1675134602).
 * My understanding is that it has been addressed with [#39051](https://github.com/woocommerce/woocommerce/issues/39051)
   and [#39250](https://github.com/woocommerce/woocommerce/pull/39250). Could you
   try with the latest version of [WooCommerce (version 8.0.2)](https://downloads.wordpress.org/plugin/woocommerce.8.0.2.zip)
   and see how it goes, please?
 * I hope this is helpful! Please let us know if you have any further questions 
   or concerns.

Viewing 1 replies (of 1 total)

The topic ‘HPOS Problem’ is closed to new replies.

 * ![](https://ps.w.org/woocommerce/assets/icon.svg?rev=3234504)
 * [WooCommerce](https://wordpress.org/plugins/woocommerce/)
 * [Frequently Asked Questions](https://wordpress.org/plugins/woocommerce/#faq)
 * [Support Threads](https://wordpress.org/support/plugin/woocommerce/)
 * [Active Topics](https://wordpress.org/support/plugin/woocommerce/active/)
 * [Unresolved Topics](https://wordpress.org/support/plugin/woocommerce/unresolved/)
 * [Reviews](https://wordpress.org/support/plugin/woocommerce/reviews/)

 * 1 reply
 * 2 participants
 * Last reply from: [anastas10s](https://wordpress.org/support/users/anastas10s/)
 * Last activity: [2 years, 8 months ago](https://wordpress.org/support/topic/hpos-problem/#post-16976489)
 * Status: resolved