Skip Navigation

This thread is resolved. Here is a description of the problem and solution.

Problem:
The client is trying to clean up their wp_options table and is unsure about deleting or disabling autoload for WPML-related options. They are particularly concerned about the option '_wpml_jobs_not_notified' which is large in size.
Solution:
1. We advised the client not to delete essential WPML options or disable their autoload as they are crucial for WPML's functionality.
2. The '_wpml_jobs_not_notified' option stores temporary data about translation job notifications. It can be safely deleted if the client is not using WPML's Translation Management to connect to a translation service or assign translations to local translators. Deleting this option will not cause issues if the client decides to use WPML Translation Management in the future, as WPML will recreate the option as needed.
3. This option will likely regenerate if new translation jobs are created, but since all jobs are completed, it shouldn’t grow significantly unless new jobs are assigned.
4. The option remains because WPML doesn’t automatically remove completed jobs from the database, and it keeps metadata for completed jobs in case they need to be referenced later.

If this solution does not resolve your issue or seems irrelevant due to being outdated or not applicable to your case, we highly recommend checking related known issues at https://wpml.org/known-issues/, verifying the version of the permanent fix, and confirming that you have installed the latest versions of themes and plugins. If further assistance is needed, please open a new support ticket at WPML support forum.

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 5 replies, has 0 voices.

Last updated by Osama Mersal 1 month, 1 week ago.

Assisted by: Osama Mersal.

Author Posts
February 20, 2025 at 9:36 pm #16731517

dmitrijsH

Background of the issue:
I am trying to clean up my wp_options table, especially with autoload. The issue can be seen at hidden link.

Symptoms:
There are several options related to WPML that I am unsure about deleting or disabling autoload.

Questions:
Can I delete some of the WPML-related options?
Can I disable autoload for these options?

# Option Name Size
1 _wpml_jobs_not_notified 809 KB
2 icl_sitepress_settings 94 KB
9 wcml_currency_switcher_template_objects 32 KB
18 _wcml_settings 24 KB
20 WPML(ST-MO) 23 KB

February 24, 2025 at 3:39 pm #16741984

Osama Mersal
Supporter

Languages: English (English ) Arabic (العربية )

Timezone: Africa/Cairo (GMT+02:00)

Hi,

Thanks for contacting WPML forums support. I'll be glad to help you today.

First of all, sorry for the late reply; it was due to a higher workload.

1) The options you mentioned are essential for WPML, so please don't delete them or disable autoload.

2) Could you please share your Debug information with me?
You can read a detailed explanation about it here. (http://wpml.org/faq/provide-debug-information-faster-support)
The debug info will give me much information about how your site is configured.

Best regards,
Osama

February 24, 2025 at 8:54 pm #16743167

dmitrijsH

Hello,

Thank you for your reply. I will not delete without an agreement from your side. However, I do not understand what option _wpml_jobs_not_notified 809 KB is doing.

It is very big. Maybe I have not closed some translation tasks or so?

Kind regards,

February 25, 2025 at 7:46 am #16744148

Osama Mersal
Supporter

Languages: English (English ) Arabic (العربية )

Timezone: Africa/Cairo (GMT+02:00)

Hi,

This option stores translation job notifications. You can delete it if you are not using WPML's Translation Management to connect to a translation service or assign translations to local translators.

Best regards,
Osama

February 25, 2025 at 9:45 am #16744677

dmitrijsH

Hello,

I do not uae external translators and do not send the jobs to anyone.

However, I have concerns about deleting the option.

1. If I just delete it manually, won't it do any harm if in the future, I decide to assign jobs.

2. If I just delete it manually, won't it come back? Maybe it is more appropriate to cancel/delete jobs themselves.

3. I have all the jobs with the status Completed, why does this option appear.

Kind regards,

February 25, 2025 at 10:43 am #16745032

Osama Mersal
Supporter

Languages: English (English ) Arabic (العربية )

Timezone: Africa/Cairo (GMT+02:00)

Hi,

1) If I manually delete _wpml_jobs_not_notified, will it cause issues if I later decide to assign jobs?

No, deleting _wpml_jobs_not_notified will not cause any harm if you decide to use WPML Translation Management in the future.

This option only stores temporary job notification data (e.g., whether WPML has notified translators of a new job).

If you delete it and later assign jobs, WPML will recreate the option as needed.

2) If I delete _wpml_jobs_not_notified, will it come back? Is it better to cancel/delete jobs instead?

Yes, this option will likely regenerate if new translation jobs are created. However, since you mentioned that all jobs are completed, it shouldn’t grow significantly unless new jobs are assigned.

3) Why does _wpml_jobs_not_notified appear even though all jobs are marked as "Completed"?

This option remains because WPML doesn’t automatically remove completed jobs from the database. Possible reasons:

* Some old jobs might still be stored in the system, even if marked as completed.
* WPML keeps metadata for completed jobs in case you need to reference them later.

Best regards,
Osama