Skip Navigation

This is the technical support forum for WPML - the multilingual WordPress plugin.

Everyone can read, but only WPML clients can post here. WPML team is replying on the forum 6 days per week, 22 hours per day.

Sun Mon Tue Wed Thu Fri Sat
9:00 – 18:00 9:00 – 18:00 9:00 – 18:00 9:00 – 18:00 9:00 – 18:00 - -
- - - - - - -

Supporter timezone: Asia/Yerevan (GMT+04:00)

Tagged: 

This topic contains 7 replies, has 2 voices.

Last updated by Christopher Amirian 1 year, 5 months ago.

Assisted by: Christopher Amirian.

Author Posts
December 19, 2023 at 1:10 pm #15092897

kaitlinG

Hi- we are facing an issue with wpml plugin. whenever we are updating any content in the backend, the site gets down. we have found some WPML queries creating issues. it is related to updating the options wpml_tp_com_log and wpml_notices.

December 19, 2023 at 1:22 pm #15093037

Christopher Amirian
WPML Supporter since 07/2020

Languages: English (English )

Timezone: Asia/Yerevan (GMT+04:00)

Hi there,

I'd appreciate it if you could get back to us with the result of the steps mentioned in the chat.

Thanks.

December 19, 2023 at 5:07 pm #15095469

kaitlinG

Hi-We have updated the plugins on our staging site. Now we are getting fatal errors when we are editing any page/post. I checked the debug file and I found this error.

WordPress database error COLLATION 'utf8mb4_unicode_520_ci' is not valid for CHARACTER SET 'utf8mb 3' for query
CREATE TABLE IF NOT EXISTS `wp_3_icl_background_task` (
`task_id` BIGINT UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY,
`task_type` VARCHAR(500) NOT NULL,
`task_status` SMALLINT UNSIGNED NOT NULL DEFAULT 0,
`starting_date` DATETIME NULL,
`total_count` INT UNSIGNED NOT NULL DEFAULT 0,
`completed_count` INT UNSIGNED NOT NULL DEFAULT 0,
`completed_ids` TEXT NULL DEFAULT NULL,
`payload` TEXT NULL DEFAULT NULL,
`retry_count` SMALLINT UNSIGNED NOT NULL DEFAULT 0
) DEFAULT CHARACTER SET utf8 COLLATE utf8mb4_unicode_520_ci;
made by WPML\Upgrade\Commands\CreateBackgroundTaskTable::run

WordPress database error Table 'db.wp_3_icl_background_task' doesn't exist for query SELECT * FROM wp_3_icl_background_task WHERE task_status IN ('1','0','2') AND 1=1 made by WPML\Core\BackgroundTask\Repository\BackgroundTaskRepository::getAllByTaskStatus

Please check.

December 19, 2023 at 6:58 pm #15096071

kaitlinG

8.0.35 -- MYSQL instance version

The character set support on version 8 has been changed
you cannot use utf8 in version 8 (deprecated) instead you should use utf8mb4

It seems the latest wpml doesnt support this. Please check

December 20, 2023 at 7:43 am #15098441

Christopher Amirian
WPML Supporter since 07/2020

Languages: English (English )

Timezone: Asia/Yerevan (GMT+04:00)

Hi there,

The reason for this issue is that various database tables use a different collations.

To solve the issue a matching and similar collation for all DB tables.

You can run the following MySQL query to solve such an issue, but it will need to be adjusted with the matching table prefix and also in case a different collation is used than mentioned inside the query:

ALTER TABLE wp_posts CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci;

Make sure you have a backup fo the database before doing the steps above.

For more information:

hidden link

Thanks.

December 22, 2023 at 2:34 am #15113717

kaitlinG

We have updated the plugin to the latest version.

Each time we open a page to edit this update query is running behind the scene causing a deadlock on the DB. How can we prevent that? (We are just opening the page in edit mode without making any updates)

UPDATE `wp_3_options` SET `option_value` = 'a:5:{s:26:\"taxonomy-term-help-notices\";a:2:{s:20:\"translation_priority\";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\";b:0;s:35:\"\0WPML_Notice_Render

December 22, 2023 at 3:10 am #15113719

kaitlinG

Also, When we update any menu item on the website (menu has no connection with WPML), this query is running multiple times with different option_value. Any idea why?

UPDATE wp_3_options SET option_value = '1703214288.8785910606384277343750' WHERE option_name = '_transient_doing_cron'

December 24, 2023 at 11:37 am #15123717

Christopher Amirian
WPML Supporter since 07/2020

Languages: English (English )

Timezone: Asia/Yerevan (GMT+04:00)

Hi there,

The update query that you have mentioned needs to be checked by us. I wonder if we are allowed to copy the staging version of your website to our server?

If yes, please get back to us with the login information of the staging server by setting the next reply as private and we will follow up.

By the way the only report that I have found which was something similar to the update query you mentioned was this:

https://wpml.org/forums/topic/translation-jobs-showing-error/#post-13718651

In that scenario the issue was that there was some sort of additional language assigned to you the profile of the customer causing the issue.

I am not sure if this is the same scenario for you but it is worth the check.

Thanks.

The topic ‘[Closed] whenever we are updating any content in the backend, the site gets down’ is closed to new replies.