WordPress database error Got a packet bigger than 'max_allowed_packet' bytes

This topic has 6 replies, 2 voices, and was last updated 6 years, 3 months ago by Artem Temos.

Viewing 7 posts - 1 through 7 (of 7 total)

Author

Posts
January 21, 2019 at 11:52 am #103145

basher
Participant

I get This from error.log File.
hosted my site to cpanel and i don’t have root access to change max_allowed_packet value.

how can i resolved this.

P.S: the log file size after 7 days is 3GB.

Attachments:
You must be logged in to view attached files.

January 21, 2019 at 12:33 pm #103163

Artem Temos
Keymaster

Hello,

Thank you for choosing our theme.

Could you please check how it works with some default WordPress theme like twentysixteen to understand is it our theme issue or not?

Regards

January 23, 2019 at 8:22 am #103567

basher
Participant

Hello,
Thanks For your response.

I changed the theme to default theme like “Twenty Nineteen” and “Twenty Seventeen” then no error_log file generate but when i changed to Woodmart theme after some time it started write error_log file. error_log file size with in 11/12 hours is 2.82GB. Can you please look in to it.

January 23, 2019 at 8:27 am #103568

Artem Temos
Keymaster

Hello,

Could you please disable all plugins that are not related to our theme and provide us your admin access so we can check it? Also, we need access to the log file to be able to check it also.

Thank you in advance

January 23, 2019 at 9:00 am #103574

basher
Participant

Hello,

Logfile Contains like this

[23-Jan-2019 08:14:16 UTC] WordPress database error Got a packet bigger than ‘max_allowed_packet’ bytes for query UPDATE wpb3_options SET option_value = ‘a:3505:{i:0;b:0;s:32:\”99c0f62880d7d11c9d3f745b9b968387\”;a:0:{}s:32:\”0458568e40922decb4d6f584f629b119\”;a:7:{i:120;i:1;i:122;i:1;i:123;i:1;i:130;i:1;i:134;i:1 ********************************************************************************
WHERE option_name = ‘_transient_wc_layered_nav_counts_pa_color’ made by require(‘wp-blog-header.php’), require_once(‘wp-includes/template-loader.php’), include(‘/plugins/woocommerce/templates/taxonomy-product_cat.php’), wc_get_template, include(‘/themes/woodmart/woocommerce/archive-product.php’), do_action(‘woocommerce_sidebar’), WP_Hook->do_action, WP_Hook->apply_filters, woocommerce_get_sidebar, wc_get_template, include(‘/plugins/woocommerce/templates/global/sidebar.php’), get_sidebar, locate_template, load_template, require_once(‘/themes/woodmart/sidebar.php’), dynamic_sidebar, WP_Widget->display_callback, WOODMART_Widget_Layered_Nav->widget, WOODMART_Widget_Layered_Nav->layered_nav_list, WOODMART_Widget_Layered_Nav->get_filtered_term_product_counts, set_transient, update_option
[23-Jan-2019 08:14:16 UTC] PHP Warning: Error while sending QUERY packet. PID=2440 in /home/mydesignbd/public_html/wp-includes/wp-db.php on line 1924

January 23, 2019 at 9:31 am #103575

basher
Participant

i disabled all other plugin and still nothing happen.

January 23, 2019 at 10:19 am #103583

Artem Temos
Keymaster

Try to replace our WoodMart layered nav widgets with standard filters by attribute widgets that come with WooCommerce in Appearance -> Widgets. Then check the problem again.
Author

Posts