There are thousands of duplicate queries being run, such as the example below.
Also, I had to disable this script or I could not use the admin:
sitepress-multilingual-cms/dist/js/ate-jobs-sync/app.js
Please let me know how I can stop all these queries and make the site usable.
Here is the debug information as it was to big to submit.
hidden link
Thanks.
SELECT autoload
FROM wp_options
WHERE option_name = 'wpml.WPML\\TM\\Settings\\ProcessNewTranslatableFields.lock' /* From [www.sunriver.org/wp-admin/post.php?post=32163&action=edit&lang=en&message=1] in [/nas/content/live/sunriver1/wp-content/plugins/sitepress-multilingual-cms/vendor/wpml/core-api/core/utility/Lock.php:80] */ 1,602 0.4425
1,602 calls
delete_option
1,602 calls
DELETE
FROM wp_options
WHERE option_name = 'wpml.WPML\\TM\\Settings\\ProcessNewTranslatableFields.lock' /* From [www.sunriver.org/wp-admin/post.php?post=32163&action=edit&lang=en&message=1] in [/nas/content/live/sunriver1/wp-content/plugins/sitepress-multilingual-cms/vendor/wpml/core-api/core/utility/Lock.php:80] */ 1,602 2.6651
1,602 calls
delete_option
1,602 calls
UPDATE wp_options
SET option_value = '1689330882'
WHERE option_name = 'wpml.WPML\\TM\\Settings\\ProcessNewTranslatableFields.lock' /* From [www.sunriver.org/wp-admin/post.php?post=32163&action=edit&lang=en&message=1] in [/nas/content/live/sunriver1/wp-content/plugins/sitepress-multilingual-cms/vendor/wpml/core-api/core/utility/Lock.php:69] */ 4 0.0059
4 calls
update_option
4 calls
INSERT IGNORE INTO wp_options ( option_name, option_value, autoload )
VALUES ('wpml.WPML\\TM\\Settings\\ProcessNewTranslatableFields.lock', '1689330883', 'no') /* LOCK */ /* From [www.sunriver.org/wp-admin/post.php?post=32163&action=edit&lang=en&message=1] in [/nas/content/live/sunriver1/wp-content/plugins/sitepress-multilingual-cms/vendor/wpml/core-api/core/utility/Lock.php:47] */ 231 0.3574
I would like to request temporary access (wp-admin and FTP) to your site to test the issue.
(preferably to a test site where the problem has been replicated if possible)
**Before we proceed It is necessary to take FULL BACKUP of your database and your website. Providing us with access, you agree that a backup has been taken **
I often use the Duplicator plugin for this purpose: http://wordpress.org/plugins/duplicator/
You will find the needed fields for this below the comment area when you log in to leave your next reply.
The information you enter is private which means only you and I have access to it.
NOTE: If access to the live site is not possible and the staging site does not exist please provide me with a duplicator package created with the duplicator plugin.
Thank you for the access details! I was able to reproduce this behavior on your staging environment using a minimal setup, however, I was not able to reproduce it on a fresh sandbox environment.
I am currently still testing this and will be escalating to our second tier to further review.
Before doing so could you also please confirm with me if you used before the automatic translation feature?
After discussing this with our team I can say that this is caused by certain tasks that are stuck and the system is trying to execute. When using the Classic Translation Editor they willl not be executed.
A quick workaround and fix would be to clean and remove any entries in the icl_background_task table in the database.
-- NOTE: Please make sure to have a full backup in place before doing this.
OR
Make sure that cron works
Enable Advanced Translation Editor if not enabled as an editor (it is not) and this will allow the tasks to finish.
Our team is currently working on a permanent fix but at the moment you can this workaround.
