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
10:00 – 13:00 10:00 – 13:00 10:00 – 13:00 10:00 – 13:00 10:00 – 13:00 - -
14:00 – 19:00 14:00 – 19:00 14:00 – 19:00 14:00 – 19:00 14:00 – 19:00 - -

Supporter timezone: Asia/Dhaka (GMT+06:00)

Tagged: 

This topic contains 45 replies, has 4 voices.

Last updated by rickyR-3 2 weeks ago.

Assigned support staff: Faisal Ahammad.

Author Posts
January 14, 2023 at 10:35 pm #12818917

rickyR-3

Hello,
I saw this article
https://wpml.org/errata/reducing-size-of-icl_translate_job-icl_translate-and-other-wpml-tables/

Can you give me the help plugin?

My load time now is 2-3 seconds. Without WPML is 1 second.

January 15, 2023 at 2:01 pm #12821547

Faisal Ahammad

Hello,
We apologize for any inconvenience this may have caused. You can download and install the plugin on your site using the following link: hidden link.

Once you have followed all the steps outlined in the instructions, please let us know how it goes. If you encounter any issues, I'm here to help.

Thank you for your patience.

January 15, 2023 at 3:39 pm #12822071

rickyR-3

Hello,
I run the cleaning plugin procedure
After 3 times of cleaning (50+50+30 = 130 ID's)
the final result is: 14566 rows deleted from icl_translation_status table.

Unfortunately the site is underperforming. Products / Categories load in 3-4 seconds. If WPML is off - 1-1,5 second.

I read all post you have (more than 100) with all the suggestions and nothing help.
We are running on VDS machine and is well configured.
NGINX cache also not helping. As Redis cache gain 1 second in general.

What do you need to help me?

Please notice this problem will be better if a 2nd level can handle this because all "standard" and routine procedure are made. Most probably should be seen the MySql tables and the index in each table.

Thanks
Ricky

January 16, 2023 at 10:07 am #12825333

Faisal Ahammad

Hi,
If you need further help with this, please share the access details to your site with me. I'm enabling a private message for the following reply. After that, I'll move your ticket to the 2nd tier support team.

Privacy and Security Policy:
We have strict policies regarding privacy and access to your information. Please see: https://wpml.org/purchase/support-policy/privacy-and-security-when-providing-debug-information-for-support/

**IMPORTANT**
- Please backup the site files and database before providing us access.
- If you have a staging site where the problem can be reproduced, it is better to share access to the staging site.

Thank you

January 16, 2023 at 4:09 pm #12828339

rickyR-3

Hello,
this is a link you can login.

---- removed by support ----

As this is very heavy woo commerce site and we receive different order, restoring form backup will be very noisy. Anyway we have backup every 6 hours for the db.

January 17, 2023 at 10:28 am #12832711

Faisal Ahammad

Hi,
Thank you for providing the direct login link. I want to forward this to our second-tier support team so they can enable/disable plugins and run some SQL queries. To ensure that our tests do not interfere with your live site, I'd request you create a staging site and provide us with the login credentials.

I recommend using a plugin such as Duplicator (https://wordpress.org/plugins/duplicator/) for creating a staging site. Documentation and tutorials can be found at the following links:

- Documentation: hidden link
- Tutorial: hidden link

I look forward to hearing back from you soon. Thank you for your assistance.

January 19, 2023 at 6:29 pm #12853685

rickyR-3

Hello,
this should be an issue considering the site is very heavy.
I can send you the files and db and you can mount this on your machine.
Can you do this?

January 20, 2023 at 3:40 pm #12860921

rickyR-3

Hello,
any reply?

January 22, 2023 at 8:29 am #12866009

Faisal Ahammad

Hello,
You can send me a duplicate copy of your site using the Duplicator plugin. Make sure to exclude the uploads folder under the wp-content folder to keep the website backup size minimum.

I will make your next reply private. Please include your Duplicator package so I can install it on our sandbox server and investigate the issue further.

I appreciate your cooperation.

January 23, 2023 at 1:11 am #12868083

rickyR-3

Hello,
the process is done.

January 23, 2023 at 1:58 pm #12873531

rickyR-3

Hello,
I take this error:
hidden link

Evidently there are problems with this method.

I would like to point out that from the files I sent you with our link we are talking about <1GB for the entire site if we exclude uploads/media which are the images.

Can't you mount WP with the files I passed you?

I await your suggestion and understand what to do.

Thank you

January 23, 2023 at 2:18 pm #12873641

Faisal Ahammad

Hi Ricky,
The website's backup files you sent are too large. Could you use the All-in-One WP Migration plugin (https://wordpress.org/plugins/all-in-one-wp-migration/) to create a backup and then send it? You can upload the backup file to Google Drive and then send me the link to download it.

To help you exclude spam comments, post revisions, and media files, here is a screen recording that will guide you through the process: hidden link.

Thank you for your cooperation.

Best regards,
Faisal

January 23, 2023 at 5:24 pm #12875087

rickyR-3

Hello,
this plugin makes 22 GB file:
hidden link

Do you want to send it to you?

I repeat that you can download the files I sent you days ago, and I would have done much sooner.

How do we go on now?

Thanks

Ricky

January 23, 2023 at 8:10 pm #12875483

rickyR-3

Hello
I receive email this installation is finished ***3210185***

January 24, 2023 at 1:26 pm #12881967

Faisal Ahammad

Hello Ricky,
Good morning. I have escalated your issue to our second-tier support team. Please do not delete your website backup files from the following link: hidden link.

Our support team will download the files to investigate your issue on their sandbox server. I will keep you updated as soon as I receive any feedback from them.

I am grateful for your cooperation. Thank you for your patience.