Skip Navigation

Home › Support › English Support › [Closed] Slow backend issues

[Closed] Slow backend issues

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 – 13:00 9:00 – 13:00 9:00 – 13:00 9:00 – 13:00 9:00 – 13:00 - -
14:00 – 18:00 14:00 – 18:00 14:00 – 18:00 14:00 – 18:00 14:00 – 18:00 - -

Supporter timezone: Asia/Jerusalem (GMT+02:00)

Tagged: 

This topic contains 22 replies, has 3 voices.

Last updated by Waqas Bin Hasan 1 year, 3 months ago.

Assisted by: Itamar.

Author Posts
August 3, 2023 at 1:33 pm #14149969

caterinag-2

Hi, I'm experiencing some trouble and slow performance on my site
August 4, 2023 at 12:23 pm #14154831

caterinag-2

Staging site created hidden link
August 6, 2023 at 11:16 am #14159781

Itamar
Supporter

Languages: English (English ) Hebrew (עברית )

Timezone: Asia/Jerusalem (GMT+02:00)

Hi,

I'll keep helping you with this issue.

1. Is the backend performance issue still there?

2. Have you tried my colleague's suggestion to check if the problem persists in a minimum environment?

If not, here is what you need to try.

I suspect that there is a collision with the theme or another plugin that might cause this problem (backend performance issue). If possible, get your site into a minimum environment. Minimum environment means switching to a default WordPress theme like TwentyTwenty-One and no plugins activated except WPML.

First, you must check if the problem persists when just the theme is switched to TwentyTwenty-One (for example). If it continues, deactivate all plugins except the WPML, its add-ons, and WooCommerce itself (without its extensions). Then please check if the problem persists. If it does not persist, start by activating the plugins one by one and check when the problem comes back, then report to me which was the culprit plugin.

**** Important! Please make a full site backup (files and DB) before you proceed with those steps****


*** If your site is live, you might want to try those procedures in a staging environment or a snapshot of your site on your local server or another server. ***

Regards,
Itamar.
August 7, 2023 at 11:17 am #14163117

caterinag-2

Hi, I'm working on a staging site. All plugin deactivated except theme woocommerce and wmpl. Unfortunately I get several different error mesage and is not easy to identify where the main problem is

thats the query I copied once my theme has been activated
SELECT option_value
FROM wpstg0_options
WHERE option_name = 'wp_installer_settings'
LIMIT 1

get_option()
wp-includes/option.php:199
OTGS\Installer\Settings::load()
wp-content/plugins/sitepress-multilingual-cms/vendor/otgs/installer/includes/class-otgs-installer-settings.php:8
WP_Installer->get_settings()
wp-content/plugins/sitepress-multilingual-cms/vendor/otgs/installer/includes/class-wp-installer.php:679
WP_Installer->__construct()
wp-content/plugins/sitepress-multilingual-cms/vendor/otgs/installer/includes/class-wp-installer.php:94
WP_Installer::instance()
wp-content/plugins/sitepress-multilingual-cms/vendor/otgs/installer/includes/class-wp-installer.php:86
WP_Installer()
wp-content/plugins/sitepress-multilingual-cms/vendor/otgs/installer/includes/functions-core.php:6
wpml_installer_instance_delegator()
wp-content/plugins/sitepress-multilingual-cms/vendor/otgs/installer/loader.php:227
do_action('after_setup_theme')
wp-includes/plugin.php:517
August 7, 2023 at 11:42 am #14163319

Itamar
Supporter

Languages: English (English ) Hebrew (עברית )

Timezone: Asia/Jerusalem (GMT+02:00)

Hi,

You presented this query but didn't mention what was wrong with it.

1. Does this query effects the backend performance?

2. If so, then how long does it take to load?

3. What other error messages do you get?

Can you please answer those questions and let me have access to the staging site?

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.

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.--
August 7, 2023 at 12:19 pm #14163655

caterinag-2

loading time varies from 15 to 60 sec, depending on pages and time.
other errror message are listed in the chat, but maybe navigating the backend is the bestway to understand. I'm not such and expert, sorry
August 7, 2023 at 12:52 pm #14163843

Itamar
Supporter

Languages: English (English ) Hebrew (עברית )

Timezone: Asia/Jerusalem (GMT+02:00)

Hi, and thanks for the access details.

Yes, I've read your chat with Noman, my colleague.

You wrote: "SIte is extremely slow. The backend also. Cannot edit post/page, delete/add plugin."

I'm not noticing a significant slowness on your site. I tried to edit a page and a post, and I was able to do so. Not as you say.

1. Is there a specific page or post I should edit to see this problem?

I noticed that only our core plugin WPML Multilingual CMS is active. When using WooCommerce, it is a must also to activate Strings Translation and WooCommerce Multilingual & Multicurrency. So I activated them.

Please note that Query Monitor itself causes performance issues. We mention the following in our guide about working with this plugin.

Please note that Query Monitor requires significant resources by itself. You should activate it only to identify performance problems and deactivate it afterward.

You can see this guide here.

https://wpml.org/tutorials/2019/10/analyze-performance-issues-with-query-monitor/

I also noticed that you used the Plain permalink structure on the staging site, which does not work with WPML. So I switched the permalink structure to the Post name. Please see the attached screenshot.

In addition, I switched from the Salient child theme to the parent theme. This is to ensure we don't face any issues with custom code in the child theme.

Now, when Strings Translation and WooCommerce Multilingual & Multicurrency are active, the Query Monitor is deactivated, and the permalink structure is adjusted, I can see your site (front and backend is loading faster).

2. Do you observe this?

If you still think WPML is causing a performance issue on your site, please be more specific and tell us the exact steps to take to see this problem. Tell us exactly where to go to see the performance issue.

We also need FTP access to your staging site, which you have not provided yet. We need to check for any PHP errors. Please edit the previous private message and add the FTP access details.

Thanks,
Itamar.

2023-08-07_15-37-44.jpg
August 7, 2023 at 1:05 pm #14163951

caterinag-2

Dear Itamar,
all plugin on the staging site are deactivated as you requested. that's why no issue. in the real site permalink are set as you noted. On the staging site, probably they have been modified when plug in have been deactivated. off course als the other compòlementary WPML plugin are active on the living site, despite the WPML debug says they are not.
August 7, 2023 at 1:37 pm #14164211

Itamar
Supporter

Languages: English (English ) Hebrew (עברית )

Timezone: Asia/Jerusalem (GMT+02:00)

Hi, and thanks for the extra information.

I need to continue to investigate this issue on the staging site and not on the live site, as I'm not allowed to change anything on the live site. I will activate each plugin at a time and check which plugin causes the problem. But I also need FTP access to the staging site. You have not provided it yet. Please provide the access details in the following private message, including the FTP access to the staging site.

Thanks,
Itamar.

August 8, 2023 at 4:45 pm #14171365

Itamar
Supporter

Languages: English (English ) Hebrew (עברית )

Timezone: Asia/Jerusalem (GMT+02:00)

Thanks for the FTP access.

On your staging site, I can see a loading time difference when WPML is active and not active with the Salient theme. Please see the attached screenshots. So I installed the All In One Migration plugin and created a copy of your site. I escalated the issue to our second-tier supporters with all the details I had. Our second-tier supporters will investigate this issue, and I'll update you here when I have news from them.

I appreciate your patience.

Regards,
Itamar.

2023-08-08_14-56-04.jpg
2023-08-08_14-55-36.jpg
2023-08-08_14-56-55.jpg
2023-08-08_14-57-17.jpg
August 9, 2023 at 9:26 am #14174245

caterinag-2

Thanks, I also formwarded your message to the Theme support, so they can also investigate
August 10, 2023 at 1:41 pm #14182863

Itamar
Supporter

Languages: English (English ) Hebrew (עברית )

Timezone: Asia/Jerusalem (GMT+02:00)

Hi,

Our second-tier supporter has found the issue on your site. It is a compatibility issue with the WP Social Ninja plugin.

https://wordpress.org/plugins/wp-social-reviews/

This plugin is not officially compatible with WPML. It is not on our list here.

https://wpml.org/plugin/

However, we could provide a workaround for this compatibility problem. Here is what we have tried on your staging site, and we can see a performance improvement.

1. Edit this file with a code editor.

/wp-content/plugins/wp-social-reviews/app/Services/GlobalSettings.php

2. Replace the following function.

    public static function getTranslations()
    {
        $settings = get_option('wpsr_global_settings', []);
        $translations_settings = (new self)->formatGlobalSettings($settings);
        return Arr::get($translations_settings, 'global_settings.translations', []);
    }

With our fixed function.

    public static function getTranslations()
    {
        $settings = get_option('wpsr_global_settings', []);
	    $lang = apply_filters( 'wpml_current_language', null );
	    $translations_settings = get_transient('trsettings_'. $lang );
		if (!$translations_settings) {
			$translations_settings = ( new self )->formatGlobalSettings( $settings );
			set_transient('trsettings_' . $lang, $translations_settings );
		}
        return Arr::get($translations_settings, 'global_settings.translations', []);
    }

3. Save the file.

**** Important! Please make a full site backup (files and DB) before you proceed with those steps****

This should improve the loading of your site in a few seconds. We're seeing about 6 seconds improvement in loading time on your staging site, where we implemented this change.

Please try it also on your production site.

Regards,
Itamar.

August 10, 2023 at 2:54 pm #14183671

caterinag-2

Hi I applied the code on the staging site but the theme crashes. Pages are no more full width. Code cannot be used, sorry
August 10, 2023 at 3:32 pm #14183991

Itamar
Supporter

Languages: English (English ) Hebrew (עברית )

Timezone: Asia/Jerusalem (GMT+02:00)

Hi, and thanks for trying my suggestion.

I'm unsure why the theme would crash. I did the same on the staging site; nothing like that happened.

Did you apply the change in /wp-content/plugins/wp-social-reviews/app/Services/GlobalSettings.php?

Please take special care in how you apply this. You need to remove only the lines I specified and add the new lines; otherwise, the code might break.

If you are unsure and allow me, I can make this change for you on the live site hidden link.

**** Important! Please make a full site backup (files and DB) before you proceed with those steps****
August 10, 2023 at 3:44 pm #14184013

caterinag-2

I tink i did right. I selected the lines to be removed and paste the new ones. I try again deleting first and then pasting.

The topic ‘[Closed] Slow backend issues’ is closed to new replies.