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.

Tagged: 

This topic contains 49 replies, has 3 voices.

Last updated by Bruno Kos 1 year, 7 months ago.

Assisted by: Bruno Kos.

Author Posts
August 12, 2023 at 1:50 pm #14191737

samaan-habibM

Hi, we start the development of my client's website on our server so we use the development key and then when transferring the website to the client-server we unregister the key and add a new product key, and then when lunch the website takes the whole server's resources and the website is down I need to know if the problem is when we change the key or We did something wrong in WPML setting which causes this effect on client-server and when and when deactivate the whole WPML plugins the website works

August 12, 2023 at 9:34 pm #14192223

Mihai Apetrei
WPML Supporter since 03/2018

Languages: English (English )

Timezone: Europe/Bucharest (GMT+03:00)

Hi there.

Before this ticket gets assigned to my colleagues, I will try to help.

I am not sure what is the exact 100% process that you are following when migrating websites but our recommendation is to use the Duplicator plugin when you are migrating the site between the testing and live environments.

- https://wordpress.org/plugins/duplicator/

Documentation can be found here:
hidden link

Here is a small tutorial on how to use Duplicator:
hidden link

This should help you perfectly migrate your website while maintaining the exact same setup and also taking care of the search and replace process so that the old links will be overwritten with the new URLs of the new domain you are migrating to (in case you are also changing the domain and not only the server).

I hope that you will find this helpful 🙂 I use only Duplicator each time I want to migrate WP websites. They also have a premium version but if you don't have a huge website with a huge database, the free version should work fine.

The thing is that, if a website is correctly migrated and nothing bad goes on while the migration process runs, the website and WPML should act normally after the migration.

Please let us know how things go.

Mihai Apetrei

August 16, 2023 at 8:50 pm #14241341

samaan-habibM

Hi, I don't have issue with migrate the website and I always use duplicator and everything works fine my problem is with the strange behaviour since I've migrate the website the website database crashed and website stop working until I deactivate the WPML I tried to rest the settings the website works for a short time but now returns to give an error in the database
My question is does wpml has cron job for queries which may cause this issue
while searching in the support forum I found someone has the the same issue but the problem is not solved

August 17, 2023 at 6:43 am #14242417

Bruno Kos
WPML Supporter since 12/2018

Languages: English (English ) German (Deutsch ) French (Français )

Timezone: Europe/Zagreb (GMT+02:00)

Given that you say that migrated website crashes with WPML only, can you do the following:

1. Edit wp-config.php and insert the following lines (just before /* That's all, stop editing! Happy publishing. */ part)

define( 'WP_DEBUG', true);
define( 'WP_DEBUG_LOG', true);
define( 'WP_DEBUG_DISPLAY', false);

2. Reproduce the issue - activate WPML and access the site I believe?

3. Locate the debug log in: /wp-content/debug.log

4. Paste the latest lines here. No need to paste the entire log file, just 10 lines or so will do. Please censor any sensitive information.

https://codex.wordpress.org/Debugging_in_WordPress

But also need this:

- do the above reproducing (so from step 2)
- get the latest server debug logs (you can ask hosting support if unsure how to locate them)

Let us know how it goes or if you need further information!

August 17, 2023 at 11:26 am #14245475

samaan-habibM

Ok I do as you said the debug log did not include any fatal error from php most of them are php notice or warming which has nothing to do with the database crashing I also talk with the hosting and they told me that there is a very large number of queries on the database and this happened only when WPML is active
so I need to know why WPML calling these queries ?

August 17, 2023 at 12:47 pm #14245997

Bruno Kos
WPML Supporter since 12/2018

Languages: English (English ) German (Deutsch ) French (Français )

Timezone: Europe/Zagreb (GMT+02:00)

Does the site work with WPML if you disable String Translation perhaps?

Also, can you please provide us with the debug information, so that we can get a better idea of your setup?

https://wpml.org/faq/provide-debug-information-faster-support/

If not yet the case, make sure to have the latest updates already installed, including not only WPML but also related plugins (such as Elementor, WooCommerce, etc).

https://wpml.org/account/downloads/

Please do the above and let us know if the issue is still happening.

August 17, 2023 at 1:32 pm #14246657

samaan-habibM

Hi, the website is working but suddenly give database error please I need to solve this issue as my boss wants to start his campaign and I can't let leads face this issue eachtime they opn the webiste

August 17, 2023 at 2:20 pm #14246981

Bruno Kos
WPML Supporter since 12/2018

Languages: English (English ) German (Deutsch ) French (Français )

Timezone: Europe/Zagreb (GMT+02:00)

Do you have error logs perhaps? You can get them like this:

1. Edit wp-config.php and insert the following lines (just before /* That's all, stop editing! Happy publishing. */ part)

define( 'WP_DEBUG', true);
define( 'WP_DEBUG_LOG', true);
define( 'WP_DEBUG_DISPLAY', false);

2. Reproduce the issue - browse the site until it hits fatal error.

3. Locate the debug log in: /wp-content/debug.log

4. Paste the latest lines here. No need to paste the entire log file, just 10 lines or so will do. Please censor any sensitive information.

https://codex.wordpress.org/Debugging_in_WordPress

But more importantly we need this:

- do the above reproducing (so from step 2)
- get the latest server debug logs (you can ask hosting support if unsure how to locate them)

August 17, 2023 at 2:57 pm #14247207

samaan-habibM

there is no fatal error as the error only because of the very large amount of MySQL quires I see the debug log file there is no fatal error

August 18, 2023 at 7:13 am #14250075

Bruno Kos
WPML Supporter since 12/2018

Languages: English (English ) German (Deutsch ) French (Français )

Timezone: Europe/Zagreb (GMT+02:00)

I see, can you tell me what happens if you temporarily disable String Translation plugin? Does it work then?

August 18, 2023 at 5:19 pm #14254369

samaan-habibM

The website is not all the time not working
While users visit the website suddenly got the database error and contact us
do you thing the problem is with string translations and if so why this happened ?

August 21, 2023 at 6:37 am #14259953

Bruno Kos
WPML Supporter since 12/2018

Languages: English (English ) German (Deutsch ) French (Français )

Timezone: Europe/Zagreb (GMT+02:00)

Database error should be recorded at least in server logs, if not in WordPress logs, perhaps memory exhausted limit? I can only help if I have the logs, otherwise we can't know what the underlying issue is.

What if you try this?
https://wpml.org/errata/wordpress-6-3-performance-issues-with-string-translation-in-specific-scenarios/

You can use https://wordpress.org/plugins/wp-downgrade/

Does it help?

August 23, 2023 at 2:31 pm #14278995

samaan-habibM

Hi, the issue is not resolved I still get this error in the debug file
[23-Aug-2023 14:18:37 UTC] PHP Warning: mysqli_real_connect(): (HY000/1226): User 'lilacmar_wp_7xmiw' has exceeded the 'max_user_connections' resource (current value: 30) in /home/lilacmar/public_html/wp-includes/class-wpdb.php on line 2019
PHP Deprecated: Constant FILTER_SANITIZE_STRING is deprecated in /home/lilacmar/public_html/wp-content/plugins/wpml-string-translation/inc/gettext/wpml-theme-string-scanner.class.php on line 33
[22-Aug-2023 10:42:08 UTC] PHP Deprecated: Implicit conversion from float 80.1 to int loses precision in /home/lilacmar/public_html/wp-includes/class-wp-hook.php on line 77

I search in the forum and found that this issue may happened because of un completed WPLM activation and by the way I have noticed that this issue happened when tow admin users work on the website I need to solve this issue please Our website campaign is very late

August 23, 2023 at 3:09 pm #14279127

samaan-habibM

[22-Aug-2023 18:43:03 UTC] PHP Deprecated: strtotime(): Passing null to parameter #1 ($datetime) of type string is deprecated in /home/lilacmar/public_html/wp-content/plugins/sitepress-multilingual-cms/classes/emails/notification/summary/class-wpml-tm-jobs-summary-report.php on line 60
the debug file contains about 41000 line error about wpml

August 23, 2023 at 6:56 pm #14280413

samaan-habibM

Hi, I've notice that the website works fine until to open WPML string translations and start translate after a few minutes we got the database error
mysqli_real_connect(): (HY000/1226): User 'lilacmar_wp_7xmiw' has exceeded the