Suddenly I have a huge consumption in the error_log 2gb and it increases every minute surely it is error lines sent by the server, Can you check what it would be? Thank you!,
Hello, this is the error that is sending me, to the error_log folder
[28-Feb-2023 17:29:53 UTC] WordPress database error COLLATION 'utf8_general_ci' is not valid for CHARACTER SET 'utf8mb4' for query CREATE TABLE wpie_braapf_term_taxonomy_hierarchical (
term_taxonomy_id bigint(20) NOT NULL,
term_id bigint(20) NOT NULL,
term_taxonomy_child_id bigint(20) NOT NULL,
term_child_id bigint(20) NOT NULL,
taxonomy varchar(32) NOT NULL,
INDEX term_taxonomy_id (term_taxonomy_id),
INDEX term_taxonomy_child_id (term_taxonomy_child_id),
INDEX child_parent_id (term_taxonomy_id, term_taxonomy_child_id),
UNIQUE uniqueid (term_taxonomy_id, term_id, term_taxonomy_child_id, term_child_id)
) DEFAULT CHARACTER SET utf8mb4 COLLATE utf8_general_ci made by do_action_ref_array('braapf_additional_table_cron'), WP_Hook->do_action, WP_Hook->apply_filters, BeRocket_aapf_variations_tables_addon->cron, BeRocket_aapf_variations_tables_addon->activate, BeRocket_aapf_variations_tables_addon->create_all_tables, BeRocket_aapf_variations_tables_addon->create_table_braapf_term_taxonomy_hierarchical, dbDelta
[28-Feb-2023 17:29:53 UTC] WordPress database error COLLATION 'utf8_general_ci' is not valid for CHARACTER SET 'utf8mb4' for query CREATE TABLE wpie_braapf_product_stock_status_parent (
post_id bigint(20) NOT NULL,
parent_id bigint(20) NOT NULL,
stock_status tinyint(2),
PRIMARY KEY (post_id),
INDEX stock_status (stock_status)
) DEFAULT CHARACTER SET utf8mb4 COLLATE utf8_general_ci made by do_action_ref_array('braapf_additional_table_cron'), WP_Hook->do_action, WP_Hook->apply_filters, BeRocket_aapf_variations_tables_addon->cron, BeRocket_aapf_variations_tables_addon->activate, BeRocket_aapf_variations_tables_addon->create_all_tables, BeRocket_aapf_variations_tables_addon->create_table_braapf_product_stock_status_parent, dbDelta
[28-Feb-2023 17:29:53 UTC] WordPress database error COLLATION 'utf8_general_ci' is not valid for CHARACTER SET 'utf8mb4' for query CREATE TABLE wpie_braapf_variable_attributes (
post_id bigint(20) NOT NULL,
attribute varchar(32) NOT NULL,
INDEX post_id (post_id),
INDEX attribute (attribute),
UNIQUE uniqueid (post_id, attribute)
) DEFAULT CHARACTER SET utf8mb4 COLLATE utf8_general_ci made by do_action_ref_array('braapf_additional_table_cron'), WP_Hook->do_action, WP_Hook->apply_filters, BeRocket_aapf_variations_tables_addon->cron, BeRocket_aapf_variations_tables_addon->activate, BeRocket_aapf_variations_tables_addon->create_all_tables, BeRocket_aapf_variations_tables_addon->create_table_braapf_variable_attributes, dbDelta
[28-Feb-2023 17:29:53 UTC] WordPress database error COLLATION 'utf8_general_ci' is not valid for CHARACTER SET 'utf8mb4' for query CREATE TABLE wpie_braapf_product_variation_attributes (
post_id bigint(20) NOT NULL,
parent_id bigint(20) NOT NULL,
meta_key varchar(32) NOT NULL,
meta_value_id bigint(20) NOT NULL,
stock_status tinyint(2),
INDEX post_id (post_id),
INDEX meta_key (meta_key),
INDEX meta_value_id (meta_value_id),
UNIQUE uniqueid (post_id, meta_key, meta_value_id)
) DEFAULT CHARACTER SET utf8mb4 COLLATE utf8_general_ci made by do_action_ref_array('braapf_additional_table_cron'), WP_Hook->do_action, WP_Hook->apply_filters, BeRocket_aapf_variations_tables_addon->cron, BeRocket_aapf_variations_tables_addon->activate, BeRocket_aapf_variations_tables_addon->create_all_tables, BeRocket_aapf_variations_tables_addon->create_table_braapf_product_variation_attributes, dbDelta
[28-Feb-2023 17:29:53 UTC] WordPress database error Table 'latamrif_wp266.wpie_braapf_product_stock_status_parent' doesn't exist for query INSERT IGNORE INTO wpie_braapf_product_stock_status_parent SELECT wpie_posts.ID as post_id, wpie_posts.post_parent as parent_id, IF(wpie_wc_product_meta_lookup.stock_status = 'instock', 1, 0) as stock_status FROM wpie_wc_product_meta_lookup
JOIN wpie_posts ON wpie_wc_product_meta_lookup.product_id = wpie_posts.ID
WHERE wpie_wc_product_meta_lookup.product_id >= 1747 AND wpie_wc_product_meta_lookup.product_id < 6747 made by do_action_ref_array('braapf_additional_table_cron'), WP_Hook->do_action, WP_Hook->apply_filters, BeRocket_aapf_variations_tables_addon->cron, BeRocket_aapf_variations_tables_addon->activate, BeRocket_aapf_variations_tables_addon->insert_table_braapf_product_stock_status_parent
Hello Alex, they told me the following; This error is returned here. I cannot help you in this case, since it is a procedure outside our scope of service, They told me to check with the developer and they marked me with the error where it is returned
Hello!, reviewing a bit the error lines are shown when you interact with the page, is it not a plugin? or on the shop page, since my store is seen without categories or the platform menu, can it be solved by reinstalling the theme?, but saving the colors of the page as they are with a backup and keeping the home theme, or also uploading a new MySQL database
UPDATE: looking for the error for the plugins I realized that the “Advanced AJAX Product Filters for WooCommerce” plugin is the one that sends the error lines, could it be because the filters and categories disappeared in my shop?
deactivate the plugin ” Advanced AJAX Product Filters for WooCommerce “, and it no longer sends errors to the error_log can you help me to repair that plugin?
