Do you have a staging site where I could perform a thorough check? As explained by our 2nd Tier Support, there isn't any database issue but an SQL query from a 3rd party plugin or a feature from the theme that is causing the issue.
1. staging is not relevant since, its not the same as our production its old
2. you didn't reply regarding this problem in our debug log
[15-Oct-2023 22:24:16 UTC] שגיאת מסד נתונים Unknown column 'wpml_translations.language_code' in 'IN/ALL/ANY subquery' לשאילתה SELECT SQL_CALC_FOUND_ROWS lsk_posts.ID FROM lsk_posts LEFT JOIN lsk_term_relationships ON (lsk_posts.ID = lsk_term_relationships.object_id) WHERE 1=1 AND lsk_posts.ID IN
3. also in our query monitor, their are 3 queries constantly working related to jobs, which weren't before friday, which imply DB error & something running in constant loop (aka looping)
A. SELECT jobs.rid, jobs.job_id as jobId, jobs.editor_job_id as ateJobId, jobs.automatic , translation_status.status, translation_status.review_status, jobs.ate_sync_count > 100 as isLongstanding
FROM lsk_icl_translate_job as jobs
INNER JOIN lsk_icl_translation_status translation_status
ON translation_status.rid = jobs.rid
INNER JOIN lsk_icl_translations translations
ON translation_status.translation_id = translations.translation_id
INNER JOIN lsk_icl_translations parent_translations
ON translations.trid = parent_translations.trid
AND parent_translations.source_language_code IS NULL
LEFT JOIN lsk_posts posts
ON parent_translations.element_id = posts.ID
WHERE jobs.job_id IN (
SELECT MAX(job_id)
FROM lsk_icl_translate_job
GROUP BY rid )
AND jobs.editor = 'ate'
AND ( translation_status.status IN (1,2,40)
OR 1=0 )
AND translations.language_code IN ('nl','en','de','he','ru')
AND ( posts.post_status IS NULL
OR posts.post_status <> 'trash' )
B. SELECT jobs.rid, jobs.job_id as jobId, jobs.editor_job_id as ateJobId, jobs.automatic , translation_status.status, translation_status.review_status, jobs.ate_sync_count > 100 as isLongstanding
FROM lsk_icl_translate_job as jobs
INNER JOIN lsk_icl_translation_status translation_status
ON translation_status.rid = jobs.rid
INNER JOIN lsk_icl_translations translations
ON translation_status.translation_id = translations.translation_id
INNER JOIN lsk_icl_translations parent_translations
ON translations.trid = parent_translations.trid
AND parent_translations.source_language_code IS NULL
LEFT JOIN lsk_posts posts
ON parent_translations.element_id = posts.ID
WHERE jobs.job_id IN (
SELECT MAX(job_id)
FROM lsk_icl_translate_job
GROUP BY rid )
AND jobs.editor = 'ate'
AND ( translation_status.status IN (30)
OR translation_status.review_status IN ( 'NEEDS_REVIEW','EDITING' ) )
AND translations.language_code IN ('nl','en','de','he','ru')
AND ( posts.post_status IS NULL
OR posts.post_status <> 'trash' )
C. SELECT wpml_translations.element_id, tax.term_id, tax.taxonomy
FROM lsk_icl_translations wpml_translations JOIN lsk_term_taxonomy tax
ON wpml_translations.element_id = tax.term_taxonomy_id
AND wpml_translations.element_type = CONCAT('tax_', tax.taxonomy) JOIN lsk_terms terms
ON terms.term_id = tax.term_id
WHERE tax.term_id != tax.term_taxonomy_id
4. we told you when we ran this we saw some momentary relief, but again the DB CPU started to spike due to the looping after sometime, and now keeps putting the site up and down
function wpmlsupp_1706_reset_wpml_capabilities() {
if ( function_exists( 'icl_enable_capabilities' ) ) {
icl_enable_capabilities();
}
}
add_action( 'shutdown', 'wpmlsupp_1706_reset_wpml_capabilities' );
I will relay your feedback to our 2nd Tier Support team for their further assessment.
Additionally, I strongly recommend performing a complete backup before proceeding with any updates to the WPML plugins to ensure data safety.
Regarding the issue you mentioned, where the site experiences intermittent outages, our 2nd Tier Support is eager to find a way to replicate it for a more thorough investigation. It would be immensely helpful if you could provide a detailed set of steps to replicate the issue. For instance, if you could specify the actions you take on a particular page that results in the site going down, it would greatly assist in diagnosing and addressing the problem effectively.
which clearly shows
A. missing fields - from the debug.log error
B. constant jobs running, while we have no jobs running right now - which leads to believe its looping around some faulty db column or field
C. you need to look at this paste from our mysql log - hidden link - which i wrote to you in earlier messages
which shows non stop queries while nothing is support to be active
D. last but not least, the query monitor shows wpml tasks that are not suppose to be there
Our Second Tier Support has thoroughly reviewed your feedback, and here is their assessment:
The errors you've highlighted are already being reported and will be addressed accordingly.
Regarding the specific error message:
[15-Oct-2023 22:24:16 UTC] שגיאת מסד נתונים Unknown column 'wpml_translations.language_code' in 'IN/ALL/ANY subquery' לשאילתה SELECT SQL_CALC_FOUND_ROWS lsk_posts.ID FROM lsk_posts LEFT JOIN lsk_term_relationships ON (lsk_posts.ID = lsk_term_relationships.object_id) WHERE 1=1 AND lsk_posts.ID IN
It's important to note that this query appears to be incorrect, and there doesn't seem to be a database problem as far as we can determine. Given that you are using a custom theme and numerous plugins, it's plausible that this query is custom and not originating from WPML itself.
To proceed with troubleshooting, we require additional information:
1. How frequently does this issue occur? As of now, it has been reported since October 15th.
2. Do you have any insights into the specific actions or circumstances that trigger this error?
Troubleshooting is challenging without further details, as an error message alone may not provide the complete context. For instance, an incorrect query could result in a database error, but it does not necessarily indicate a problem with the database itself. We have already verified the WPML table, and it does include the necessary column. If that column were missing, it would affect translations on the front-end consistently.
"[15-Oct-2023 22:24:16 UTC] שגיאת מסד נתונים Unknown column 'wpml_translations.language_code' in 'IN/ALL/ANY subquery' לשאילתה SELECT SQL_CALC_FOUND_ROWS lsk_posts.ID FROM lsk_posts LEFT JOIN lsk_term_relationships ON (lsk_posts.ID = lsk_term_relationships.object_id) WHERE 1=1 AND lsk_posts.ID IN"
A. SELECT jobs.rid, jobs.job_id as jobId, jobs.editor_job_id as ateJobId, jobs.automatic , translation_status.status, translation_status.review_status, jobs.ate_sync_count > 100 as isLongstanding
FROM lsk_icl_translate_job as jobs
INNER JOIN lsk_icl_translation_status translation_status
ON translation_status.rid = jobs.rid
INNER JOIN lsk_icl_translations translations
ON translation_status.translation_id = translations.translation_id
INNER JOIN lsk_icl_translations parent_translations
ON translations.trid = parent_translations.trid
AND parent_translations.source_language_code IS NULL
LEFT JOIN lsk_posts posts
ON parent_translations.element_id = posts.ID
WHERE jobs.job_id IN (
SELECT MAX(job_id)
FROM lsk_icl_translate_job
GROUP BY rid )
AND jobs.editor = 'ate'
AND ( translation_status.status IN (1,2,40)
OR 1=0 )
AND translations.language_code IN ('nl','en','de','he','ru')
AND ( posts.post_status IS NULL
OR posts.post_status <> 'trash' )
B. SELECT jobs.rid, jobs.job_id as jobId, jobs.editor_job_id as ateJobId, jobs.automatic , translation_status.status, translation_status.review_status, jobs.ate_sync_count > 100 as isLongstanding
FROM lsk_icl_translate_job as jobs
INNER JOIN lsk_icl_translation_status translation_status
ON translation_status.rid = jobs.rid
INNER JOIN lsk_icl_translations translations
ON translation_status.translation_id = translations.translation_id
INNER JOIN lsk_icl_translations parent_translations
ON translations.trid = parent_translations.trid
AND parent_translations.source_language_code IS NULL
LEFT JOIN lsk_posts posts
ON parent_translations.element_id = posts.ID
WHERE jobs.job_id IN (
SELECT MAX(job_id)
FROM lsk_icl_translate_job
GROUP BY rid )
AND jobs.editor = 'ate'
AND ( translation_status.status IN (30)
OR translation_status.review_status IN ( 'NEEDS_REVIEW','EDITING' ) )
AND translations.language_code IN ('nl','en','de','he','ru')
AND ( posts.post_status IS NULL
OR posts.post_status <> 'trash' )
C. SELECT wpml_translations.element_id, tax.term_id, tax.taxonomy
FROM lsk_icl_translations wpml_translations JOIN lsk_term_taxonomy tax
ON wpml_translations.element_id = tax.term_taxonomy_id
AND wpml_translations.element_type = CONCAT('tax_', tax.taxonomy) JOIN lsk_terms terms
ON terms.term_id = tax.term_id
WHERE tax.term_id != tax.term_taxonomy_id
to your question YES - i mentioned those queries several times
may i know how come a week passed, you know my DB is looping yet you didn't resolve my problem, although you know our business is not functioning since cpu goes up and down and killing the server and now the server for example is down for 3 hours
now our debug log is bloating, and our whole server collapse and goes up collapse and goes up
[20-Oct-2023 19:20:19 UTC] PHP Warning: mysqli_query(): (HY000/3): Error writing file '/tmp/MYfd=779' (OS errno 28 - No space left on device) in /home/kidenoad/domains/kideno.com/public_html/wp-includes/wp-db.php on line 2162
[20-Oct-2023 19:20:19 UTC] WordPress-Datenbank-Fehler Error writing file '/tmp/MYfd=779' (OS errno 28 - No space left on device) für Abfrage SELECT post_id, meta_key, meta_value FROM lsk_postmeta WHERE post_id IN (6268383,6268384,6268385,6268386,6268387,6268388,6268389,6268390,6268391,6268392,6268393,6268394,6268395,6268396,6268397,6268398,6268399,6268400,6268401,6268402,6268403,6268404,6268405,6268406,6268407,6268408,6268409,6268410,6268411,6268412,6268413,6268414,6268415) ORDER BY meta_id ASC von require('wp-blog-header.php'), require_once('wp-includes/template-loader.php'), include('/themes/kidz/woocommerce/single-product.php'), get_header, locate_template, load_template, require_once('/themes/kidz-child/header.php'), get_template_part, locate_template, load_template, require('/themes/kidz/inc/main-menu.php'), wp_nav_menu, wp_get_nav_menu_items, get_posts, WP_Query->query, WP_Query->get_posts, update_post_caches, update_postmeta_cache, update_meta_cache, QM_DB->query
[20-Oct-2023 19:20:19 UTC] PHP Warning: mysqli_query(): (HY000/3): Error writing file '/tmp/MYfd=779' (OS errno 28 - No space left on device) in /home/kidenoad/domains/kideno.com/public_html/wp-includes/wp-db.php on line 2162
[20-Oct-2023 19:20:19 UTC] WordPress-Datenbank-Fehler Error writing file '/tmp/MYfd=779' (OS errno 28 - No space left on device) für Abfrage SELECT p.ID FROM lsk_posts AS p INNER JOIN lsk_term_relationships AS tr ON p.ID = tr.object_id INNER JOIN lsk_term_taxonomy tt ON tr.term_taxonomy_id = tt.term_taxonomy_id JOIN lsk_icl_translations wpml_translations ON wpml_translations.element_id = p.ID AND wpml_translations.element_type = 'post_product' WHERE p.post_date < '2022-10-04 17:16:47' AND p.post_type = 'product' AND tt.taxonomy = 'product_cat' AND tt.term_id IN (151237,151525) AND p.post_status = 'publish' AND (language_code = 'de' OR 0 ) ORDER BY p.post_date DESC LIMIT 1 von require('wp-blog-header.php'), require_once('wp-includes/template-loader.php'), include('/themes/kidz/woocommerce/single-product.php'), wc_get_template_part, load_template, require('/themes/kidz-child/woocommerce/content-single-product.php'), previous_post_link, get_previous_post_link, get_adjacent_post_link, get_adjacent_post, QM_DB->query
[20-Oct-2023 19:20:20 UTC] WordPress database error Lock wait timeout exceeded; try restarting transaction for query UPDATE `lsk_options` SET `option_value` = '1697889001' WHERE `option_name` = 'alg_get_plugins_list_cron_time_schedule' made by require('wp-blog-header.php'), require_once('wp-load.php'), require_once('wp-config.php'), require_once('wp-settings.php'), do_action('init'), WP_Hook->do_action, WP_Hook->apply_filters, Alg_WPCodeFactory_Helper_Crons->schedule_get_plugins_list, update_option, QM_DB->query
[20-Oct-2023 19:20:20 UTC] WordPress-Datenbank-Fehler Lock wait timeout exceeded; try restarting transaction für Abfrage UPDATE `lsk_options` SET `option_value` = '1697889001' WHERE `option_name` = 'alg_get_themes_list_cron_time_schedule' von require('wp-blog-header.php'), require_once('wp-load.php'), require_once('wp-config.php'), require_once('wp-settings.php'), do_action('init'), WP_Hook->do_action, WP_Hook->apply_filters, Alg_WPCodeFactory_Helper_Crons->schedule_get_themes_list, update_option, QM_DB->query
[20-Oct-2023 19:20:20 UTC] WordPress database error Lock wait timeout exceeded; try restarting transaction for query UPDATE `lsk_options` SET `option_value` = '{\"version\":\"1697823115\",\"882cd24e125fd51b4a15f5e978320c88\":{\"price\":{\"1846335\":\"295.90\",\"1846364\":\"295.90\"},\"regular_price\":{\"1846335\":\"387.90\",\"1846364\":\"387.90\"},\"sale_price\":{\"1846335\":\"295.90\",\"1846364\":\"295.90\"}}}' WHERE `option_name` = '_transient_wc_var_prices_1846284' made by require('wp-blog-header.php'), require_once('wp-includes/template-loader.php'), include('/themes/kidz/woocommerce/single-product.php'), wc_get_template_part, load_template, require('/themes/kidz-child/woocommerce/content-single-product.php'), do_action('woocommerce_single_product_summary'), WP_Hook->do_action, WP_Hook->apply_filters, woocommerce_template_single_add_to_cart, do_action('woocommerce_variable_add_to_cart'), WP_Hook->do_action, WP_Hook->apply_filters, woocommerce_variable_add_to_cart, wc_get_template, include('/themes/kidz-child/woocommerce/single-product/add-to-cart/variable.php'), do_action('woocommerce_single_variation'), WP_Hook->do_action, WP_Hook->apply_filters, woocommerce_single_variation_add_to_cart_button, wc_get_template, include('/plugins/woocommerce/templates/single-product/add-to-cart/variation-add-to-cart-button.php'), do_action('woocommerce_after_add_to_cart_button'), WP_Hook->do_action, WP_Hook->apply_filters, PixelYourSite\EventsManager::setupWooSingleProductData, PixelYourSite\Facebook->generateEvents, PixelYourSite\Facebook->addParamsToEvent, PixelYourSite\Facebook->getWooAddToCartOnButtonClickEventParams, PixelYourSite\Facebook\Helpers\getWooSingleAddToCartParams, PixelYourSite\getWooProductValue, PixelYourSite\getWooProductPriceToDisplay, WC_Product_Variable->get_variation_prices, WC_Data_Store->__call, WC_Product_Variable_Data_Store_CPT->read_price_data, set_transient, update_option, QM_DB->query
[20-Oct-2023 19:20:20 UTC] WordPress databasefout Lock wait timeout exceeded; try restarting transaction bij query UPDATE `lsk_options` SET `option_value` = '1697889001' WHERE `option_name` = 'alg_get_themes_list_cron_time_schedule' gemaakt door require('wp-blog-header.php'), require_once('wp-load.php'), require_once('wp-config.php'), require_once('wp-settings.php'), do_action('init'), WP_Hook->do_action, WP_Hook->apply_filters, Alg_WPCodeFactory_Helper_Crons->schedule_get_themes_list, update_option, QM_DB->query
[20-Oct-2023 19:20:20 UTC] WordPress database error Lock wait timeout exceeded; try restarting transaction for query UPDATE `lsk_options` SET `option_value` = '1697889001' WHERE `option_name` = 'alg_get_themes_list_cron_time_schedule' made by require('wp-blog-header.php'), require_once('wp-load.php'), require_once('wp-config.php'), require_once('wp-settings.php'), do_action('init'), WP_Hook->do_action, WP_Hook->apply_filters, Alg_WPCodeFactory_Helper_Crons->schedule_get_themes_list, update_option, QM_DB->query
[20-Oct-2023 19:20:20 UTC] WordPress-Datenbank-Fehler Lock wait timeout exceeded; try restarting transaction für Abfrage UPDATE `lsk_options` SET `option_value` = '1697889001' WHERE `option_name` = 'alg_get_plugins_list_cron_time_schedule' von require('wp-blog-header.php'), require_once('wp-load.php'), require_once('wp-config.php'), require_once('wp-settings.php'), do_action('init'), WP_Hook->do_action, WP_Hook->apply_filters, Alg_WPCodeFactory_Helper_Crons->schedule_get_plugins_list, update_option, QM_DB->query
[20-Oct-2023 19:20:20 UTC] База данных WordPress возвратила ошибку Lock wait timeout exceeded; try restarting transaction в ответ на запрос UPDATE `lsk_options` SET `option_value` = 'a:4:{s:7:\"default\";a:1:{s:18:\"wcml-cache-plugins\";O:11:\"WPML_Notice\":24:{s:30:\"\0WPML_Notice\0display_callbacks\";a:0:{}s:15:\"\0WPML_Notice\0id\";s:18:\"wcml-cache-plugins\";s:17:\"\0WPML_Notice\0text\";s:322:\"<h2>WooCommerce Multilingual & Multicurrency detected an active cache plugin on your site.</h2><p>Caching may cause currency display issues for your customers if you are using the multicurrency feature.</p><p>To avoid this, set your cache plugin to not cache pages for visitors that have a cookie set in their browser.</p>\";s:27:\"\0WPML_Notice\0collapsed_text\";N;s:18:\"\0WPML_Notice\0group\";s:7:\"default\";s:35:\"\0WPML_Notice\0restricted_to_user_ids\";a:0:{}s:20:\"\0WPML_Notice\0actions\";a:0:{}s:28:\"\0WPML_Notice\0css_class_types\";a:1:{i:0;s:14:\"notice-warning\";}s:24:\"\0WPML_Notice\0css_classes\";a:0:{}s:24:\"\0WPML_Notice\0dismissible\";b:1;s:31:\"\0WPML_Notice\0exclude_from_pages\";a:0:{}s:21:\"\0WPML_Notice\0hideable\";b:0;s:24:\"\0WPML_Notice\0collapsable\";b:0;s:30:\"\0WPML_Notice\0restrict_to_pages\";a:0:{}s:38:\"\0WPML_Notice\0restrict_to_page_prefixes\";a:0:{}s:35:\"\0WPML_Notice\0restrict_to_screen_ids\";a:10:{i:0;s:9:\"dashboard\";i:1;s:26:\"woocommerce_page_wpml-wcml\";i:2;s:25:\"woocommerce_page_wc-admin\";i:3;s:27:\"woocommerce_page_wc-reports\";i:4;s:28:\"woocommerce_page_wc-settings\";i:5;s:26:\"woocommerce_page_wc-status\";i:6;s:26:\"woocommerce_page_wc-addons\";i:7;s:15:\"edit-shop_order\";i:8;s:16:\"edit-shop_coupon\";i:9;s:12:\"edit-product\";}s:34:\"\0WPML_Notice\0hide_if_notice_exists\";N;s:43:\"\0WPML_Notice\0dismissible_for_different_text\";b:1;s:31:\"\0WPML_Notice\0default_group_name\";s:7:\"default\";s:25:\"\0WPML_Notice\0capabilities\";a:0:{}s:26:\"\0WPML_Notice\0dismiss_reset\";b:0;s:18:\"\0WPML_Notice\0flash\";b:0;s:25:\"\0WPML_Notice\0nonce_action\";N;s:22:\"\0WPML_Notice\0text_only\";b:0;}}s:5:\"acfml\";a:1:{s:17:\"field-group-modes\";O:11:\"WPML_Notice\":24:{s:30:\"\0WPML_Notice\0display_callbacks\";a:0:{}s:15:\"\0WPML_Notice\0id\";s:17:\"field-group-modes\";s:17:\"\0WPML_Notice\0text\";s:579:\" <h2><i class=\"otgs-ico-wpml\"> הבה נתחיל לתרגם!</h2><p>ערוך כל 'קבוצת שדות' כדי לבחור אפשרות תרגום עבור השדות שבתוכה. אם לא תגדיר אפשרות תרגום, לא תוכל לתרגם את השדות.</p><p>קרא עוד אודות הצג כדי לתרגם שדות מותאמים של ACF</p>\";s:27:\"\0WPML_Notice\0collapsed_text\";N;s:18:\"\0WPML_Notice\0group\";s:5:\"acfml\";s:35:\"\0WPML_Notice\0restricted_to_user_ids\";a:0:{}s:20:\"\0WPML_Notice\0actions\";a:0:{}s:28:\"\0WPML_Notice\0css_class_types\";a:1:{i:0;s:12:\"acfml-notice\";}s:24:\"\0WPML_Notice\0css_classes\";a:0:{}s:24:\"\0WPML_Notice\0dismissible\";b:0;s:31:\"\0WPML_Notice\0exclude_from_pages\";a:0:{}s:21:\"\0WPML_Notice\0hideable\";b:1;s:24:\"\0WPML_Notice\0collapsable\";b:0;s:30:\"\0WPML_Notice\0restrict_to_pages\";a:0:{}s:38:\"\0WPML_Notice\0restrict_to_page_prefixes\";a:0:{}s:35:\"\0WPML_Notice\0restrict_to_screen_ids\";a:1:{i:0;s:20:\"edit-acf-field-group\";}s:34:\"\0WPML_Notice\0hide_if_notice_exists\";N;s:43:\"\0WPML_Notice\0dismissible_for_different_text\";b:1;s:31:\"\0WPML_Notice\0default_group_name\";s:7:\"default\";s:25:\"\0WPML_Notice\0capabilities\";a:0:{}s:26:\"\0WPML_Notice\0dismiss_reset\";b:0;s:18:\"\0WPML_Notice\0flash\";b:0;s:25:\"\0WPML_Notice\0nonce_action\";N;s:22:\"\0WPML_Notice\0text_only\";b:0;}}s:26:\"taxonomy-term-help-notices\";a:3:{s:11:\"product_cat\";O:11:\"WPML_Notice\":24:{s:30:\"\0WPML_Notice\0display_callbacks\";a:1:{i:0;a:2:{i:0;O:37:\"WPML_Taxonomy_Translation_Help_Notice\":2:{s:57:\"\0WPML_Taxonomy_Translation_Help_Notice\0wpml_admin_notices\";O:12:\"WPML_Notices\":6:{s:27:\"\0WPML_Notices\0notice_render\";O:18:\"WPML_Notice_Render\":3:{s:38:\"\0WPML_Notice_Render\0dismiss_html_added\";N;s:35:\"\0WPML_Notice_Render\0hide_html_added\";N;s:39:\"\0WPML_Notice_Render\0collapse_html_added\";N;}s:21:\"\0WPML_Notices\0notices\";a:4:{s:7:\"default\";a:1:{s:18:\"wcml-cache-plugins\";r:3;}s:5:\"acfml\";a:1:{s:17:\"field-group-modes\";O:11:\"WPML_Notice\":24:{s:30:\"\0WPML_Notice\0display_callbacks\";a:0:{}s:15:\"\0WPML_Notice\0id\";s:17:\"field-group-modes\";s:17:\"\0WPML_Notice\0text\";s:512:\" <h2><i class=\"otgs-ico-wpml\"> Let's Start Translating!</h2><p>Edit each Field Group to select a translation option for the fields inside it. If you don't set a translation option, you will not be able to translate your fields.</p><p>Read more about how to translate your ACF custom fields</p>\";s:27:\"\0WPML_Notice\0collapsed_text\";N;s:18:\"\0WPML_Notice\0group\";s:5:\"acfml\";s:35:\"\0WPML_Notice\0restricted_to_user_ids\";a:0:{}s:20:\"\0WPML_Notice\0actions\";a:0:{}s:28:\"\0WPML_Notice\0css_class_types\";a:1:{i:0;s:12:\"acfml-notice\";}s:24:\"\0WPML_Notice\0css_classes\";a:0:{}s:24:\"\0WPML_Notice\0dismissible\";b:0;s:31:\"\0WPML_Notice\0exclude_from_pages\";a:0:{}s:21:\"\0WPML_Notice\0hideable\";b:1;s:24:\"\0WPML_Notice\0collapsable\";b:0;s:30:\"\0WPML_Notice\0restrict_to_pages\";a:0:{}s:38:\"\0WPML_Notice\0restrict_to_page_prefixes\";a:0:{}s:35:\"\0WPML_Notice\0restrict_to_screen_ids\";a:1:{i:0;s:20:\"edit-acf-field-group\";}s:34:\"\0WPML_Notice\0hide_if_notice_exists\";N;s:43:\"\0WPML_Notice\0dismissible_for_different_text\";b:1;s:31:\"\0WPML_Notice\0default_group_name\";s:7:\"default\";s:25:\"\0WPML_Notice\0capabilities\";a:0:{}s:26:\"\0WPML_Notice\0dismiss_reset\";b:0;s:18:\"\0WPML_Notice\0flash\";b:0;s:25:\"\0WPML_Notice\0nonce_action\";N;s:22:\"\0WPML_Notice\0text_only\";b:0;}}s:26:\"taxonomy-term-help-notices\";N;s:18:\"WPML_User_Language\";a:1:{s:35:\"WPML_User_Languagehow_to_set_notice\";O:11:\"WPML_Notice\":24:{s:30:\"\0WPML_Notice\0display_callbacks\";a:0:{}s:15:\"\0WPML_Notice\0id\";s:35:\"WPML_User_Languagehow_to_set_notice\";s:17:\"\0WPML_Notice\0text\";s:346:\" <h2>Do you want the WordPress admin to be in a different language?</h2>\n <p>\n WPML lets each user choose the admin language, unrelated of the language in which visitors will see the front-end of the site. <br/>\n <br/>\n Go to your hidden link\">profile to choose your admin language. </p>\n \";s:27:\"\0WPML_Notice\0collapsed_text\";N;s:18:\"\0WPML_Notice\0group\";s:18:\"WPML_User_Language\";s:35:\"\0WPML_Notice\0restricted_to_user_ids\";a:1:{i:4;i:4;}s:20:\"\0WPML_Notice\0actions\";a:0:{}s:28:\"\0WPML_Notice\0css_class_types\";a:1:{i:0;s:4:\"info\";}s:24:\"\0WPML_Notice\0css_classes\";a:0:{}s:24:\"\0WPML_Notice\0dismissible\";b:1;s:31:\"\0WPML_Notice\0exclude_from_pages\";a:0:{}s:21:\"\0WPML_Notice\0hideable\";b:0;s:24:\"\0WPML_Notice\0collapsable\";b:0;s:30:\"\0WPML_Notice\0restrict_to_pages\";a:0:{}s:38:\"\0WPML_Notice\0restrict_to_page_prefixes\";a:0:{}s:35:\"\0WPML_Notice\0restrict_to_screen_ids\";a:0:{}s:34:\"\0WPML_Notice\0hide_if_notice_exists\";N;s:43:\"\0WPML_Notice\0dismissible_for_different_text\";b:1;s:31:\"\0WPML_Notice\0default_group_name\";s:7:\"default\";s:25:\"\0WPML_Notice\0capabilities\";a:1:{i:0;s:14:\"manage_options\";}s:26:\"\0WPML_Notice\0dismiss_reset\";b:0;s:18:\"\0WPML_Notice\0flash\";b:0;s:25:\"\0WPML_Notice\0nonce_action\";N;s:22:\"\0WPML_Notice\0text_only\";b:0;}}}s:31:\"\0WPML_Notices\0notices_to_remove\";a:1:{s:12:\"requirements\";a:0:{}}s:23:\"\0WPML_Notices\0dismissed\";a:4:{s:12:\"requirements\";a:2:{s:25:\"enable-translation-editor\";s:32:\"915ba635779bf9cafedb2989bba2b9f4\";s:20:\"missing-requirements\";s:32:\"818f5854735a2b1dfc1c4749794b1a8e\";}s:7:\"default\";a:1:{s:18:\"wcml-cache-plugins\";s:32:\"a0b2cbc83a942ec77bbc7548cadded1d\";}s:18:\"wcml-admin-notices\";a:1:{s:9:\"wcml-rate\";s:32:\"545e2aa05f2e3e4c910b23b5296f6221\";}s:26:\"taxonomy-term-help-notices\";a:1:{s:11:\"product_cat\";s:32:\"d692ef39ea6bb5effc91b73f4478a3bb\";}}s:28:\"\0WPML_Notices\0user_dismissed\";a:1:{s:18:\"WPML_User_Language\";a:1:{s:35:\"WPML_User_Languagehow_to_set_notice\";s:32:\"2390e6178e81f608f73ac34c1c0a8360\";}}s:34:\"\0WPML_Notices\0original_notices_md5\";s:32:\"6353a1600a3673e5d0fab274f791b340\";}s:45:\"\0WPML_Taxonomy_Translation_Help_Notice\0notice\";r:68;}i:1;s:26:\"should_display_help_notice\";}}s:15:\"\0WPML_Notice\0id\";s:11:\"product_cat\";s:17:\"\0WPML_Notice\0text\";s:235:\"Translating Product categories? Use the hidden link\"> Category translation table for easier translation.\";s:27:\"\0WPML_Notice\0collapsed_text\";N;s:18:\"\0WPML_Notice\0group\";s:26:\"taxonomy-term-help-notices\";s:35:\"\0WPML_Notice\0restricted_to_user_ids\";a:0:{}s:20:\"\0WPML_Notice\0actions\";a:1:{i:0;O:18:\"WPML_Notice_Action\":9:{s:27:\"\0WPML_Notice_Action\0dismiss\";b:0;s:37:\"\0WPML_Notice_Action\0display_as_button\";b:0;s:24:\"\0WPML_Notice_Action\0hide\";b:0;s:24:\"\0WPML_Notice_Action\0text\";s:7:\"Dismiss\";s:23:\"\0WPML_Notice_Action\0url\";s:1:\"#\";s:36:\"\0WPML_Notice_Action\0group_to_dismiss\";s:26:\"taxonomy-term-help-notices\";s:31:\"\0WPML_Notice_Action\0js_callback\";s:40:\"wpml_dismiss_taxonomy_translation_notice\";s:42:\"\0WPML_Notice_Action\0dismiss_different_text\";b:1;s:31:\"\0WPML_Notice_Action\0link_target\";N;}}s:28:\"\0WPML_Notice\0css_class_types\";a:1:{i:0;s:4:\"info\";}s:24:\"\0WPML_Notice\0css_classes\";a:0:{}s:24:\"\0WPML_Notice\0dismissible\";b:0;s:31:\"\0WPML_Notice\0exclude_from_pages\";a:0:{}s:21:\"\0WPML_Notice\0hideable\";b:0;s:24:\"\0WPML_Notice\0collapsable\";b:0;s:30:\"\0WPML_Notice\0restrict_to_pages\";a:0:{}s:38:\"\0WPML_Notice\0restrict_to_page_prefixes\";a:0:{}s:35:\"\0WPML_Notice\0restrict_to_screen_ids\";a:0:{}s:34:\"\0WPML_Notice\0hide_if_noti
