As I requested let's proceed one by one. About WooCommerce index let's first finish the media issues.
For the forum bug, please open the link when you are logged-in to the wpml.org forum. The number of pages are different for logged-in and logged-out users due to private replies.
I have shared the script here hidden link
Please follow these steps:-
#1 Make sure you have a complete DB backup. Or try this on the staging site first.
#2 Copy the code from the above link and paste to theme functions.php
#3 Now logged into the site and visit the dashboard then visit this URL hidden link
#4 Let the script run and wait do not close the browser and tab. It will keep refreshing the page, I have done it to avoid a request termination in one go.
Once it is done copy the logs that you will see in the notice and please share them here.
#5 Confirm if everything on the site is fine regarding the images.
After your feedback, I will clean the leftover from WPML tables using PHPMyAdmin and then we will duplicate images using WPML once all the processes are done the WPML media slow queries issue should be fixed.
Please note that WPML Media Translation doesn’t duplicate any files on your site. Duplication here means that new entries are created in the database with your translated image captions, titles, meta text, and other information.
The script will delete duplicated entries from the database. After it posts meta table and WPML tables need to be cleaned.
Post meta table can be cleaned using this query
DELETE pm
FROM wp_postmeta pm
LEFT JOIN wp_posts wp ON wp.ID = pm.post_id
WHERE wp.ID IS NULL
Deleting post meta for the posts that do not exist in the WP posts table.
That is the root of the issue. Running in the background and slowing your site. Once WPML media setup is done WPML does not run these background tasks.
Usually this happens in a couple of minutes when WPML is installed and new languages is added but since your database was corrupted this process was stuck.
just sharing that we saw the same behavior of brands also in blog, that some images db entities were not created,
hopefully the script will resolve it too
and if you load the site from the same browser you are logged in, you will not be served with cache, try even incognito admin and then run in another tab the
Nevermind I found it here in child theme functions/wpmlsupp-10550_fix.php
but I don't have the write permission to change the code there.
So I checked the caching setting and found you have turned on Cache WP-Admin in LiteSpeed object cache and that object caching giving inaccurate results to the script.
I have turned this off while running the script and so far it is fine.
You may see higher CPU and RAM uses please be patient I will update you once it is finished.
This is taking too much time to finish. I don't think we can make it like this so I have converted it to WP CLI command.
With WP CLI command you can ask server support to run it and then turn on the caching if you wish in backend and continue working.
Please follow these new steps:-
1. Copy the code from the same link here hidden link
2. Replace the code that you added previously with this new code.
3. Ask your server support to run this command
wp DeleteMediaDuplicates
Please ask them to log the output of this command in a file so we can have it later if needed.
I will keep checking mails when the command is finished.
