Background of the issue:
I'm trying to translate the menus on my site hidden link. The menus have some custom items and links. I wanted to use WP Menus Sync to translate them and then do the String Translation.
Symptoms:
I'm getting a timeout accessing the WP Menus Sync page since we have a lot of menus and we are behind Cloudflare.
Questions:
What are my best options for translating the menus?
Should I recreate the menus in French manually?
I've checked your Website and I noticed that your navigation menu is not complex or heavily populated.
I will need to closely examine your website. Therefore, I will require temporary access (WP-Admin and FTP) to a test site where the problem has been replicated, if possible. This will enable me to provide better assistance and determine if any configurations need to be modified.
Please note that it is important to have a backup for security purposes and to prevent any potential data loss. You can use the UpdraftPlus plugin (https://wordpress.org/plugins/updraftplus/) to fulfill your backup requirements.
Your upcoming reply will be treated with confidentiality and will only be visible to you and me.
✙ To resolve the issue, I may need your consent to deactivate and reactivate plugins and the theme, as well as make configuration changes on the site if necessary. This emphasizes the significance of having a backup.
Thanks for your reply. Before I escalate this to our 2nd Tier Support, I kindly ask for a snapshot of the site. Alternatively, with your permission, I can create one myself. For this purpose, I typically recommend using the free plugin "Duplicator." If you're already familiar with Duplicator (https://wordpress.org/plugins/duplicator/), please skip the following steps and simply send me the archive file you downloaded.
To guide you further, please adhere to these instructions:
1. View the Duplicator instructions video: hidden link
3. If the archive file exceeds 400MB, please use Duplicator's file filters to exclude cache, wp-uploads directory, media, and archive files.
Once you have the archive file ready, kindly share the link with us. You can utilize platforms like Google Drive, Dropbox, or similar for file sharing, as the snapshot file might be large.
Please note that your next reply will be private, visible only to you and me. You can paste the file link there. Rest assured that once the issue is resolved, I will delete the local site.
I have another feedback to share and this is what our 2nd Tier Support mentioned.
I deployed the exact version of MariaDB locally.
However, I am not seeing the same issue.
At this time, I think we have an issue with Disk IO. It is not serious to get such a slow query for just:
SELECT COUNT(*)
FROM wp_comments JOIN wp_icl_translations icltr2
ON icltr2.element_id = wp_comments.comment_post_ID JOIN wp_posts
ON wp_posts.ID = icltr2.element_id
AND CONCAT('post_', wp_posts.post_type) = icltr2.element_type
LEFT JOIN wp_icl_translations icltr_comment
ON icltr_comment.element_id = wp_comments.comment_ID
AND icltr_comment.element_type = 'comment'
WHERE ( comment_approved = '1' )
AND icltr2.language_code = 'en'
AND (icltr_comment.language_code IS NULL
OR icltr_comment.language_code = icltr2.language_code )
and not happening locally with 1:1 setup.
All this means that the user should contact his hosting to ask them whats going on.
Have you checked with your hosting provider? Also, yes, let's try this on another host and see if it loads correctly.
The entire staging site was being very slow. I had to do a database repair and it became fast again. However, going to WP Menus Sync still took almost 6 minutes.
I recorded a video for Nexcess and we'll see what they say. I also disabled the code profiler.
