Autoloaded data

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

Problem:
The client is trying to reduce the autoloader data value in their database and has questions about specific WPML-related values and how they affect autoloading.
Solution:
We recommend the following steps to address the issue:
1. Install a plugin to help reduce the size of WPML tables. You can download it from here.
2. Navigate to WPML > Support > Troubleshooting and perform the following actions:
- Clear the cache in WPML
- Remove ghost entries
- Fix element_type collation
- Set language information
- Fix post type assignment
- Clean up strings and optimize
Additionally, the 'wp_installer_setting' is a WP field that holds significant data, including WPML configuration data. Removing this might require reconfiguring WPML, though it won't result in data loss. The 'theme_mods_flatsome-child' is related to your theme and its options, and should be handled with care as well.

If this solution does not resolve your issue or seems outdated, please check for related known issues at https://wpml.org/known-issues/, verify the version of the permanent fix, and confirm that you have installed the latest versions of themes and plugins. If further assistance is needed, we highly recommend opening 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: Known issue

This topic contains 5 replies, has 0 voices.

Last updated by thomasD-100 2 weeks, 3 days ago.

Assisted by: Bobby.

Author	Posts
March 17, 2025 at 4:11 pm #16826306
thomasD-100	Background of the issue: I am trying to reduce the autoloader data value from our database. I see there are some values related to WPML. I went through the resolved threads and I found some interesting ones but there were dated 2023. Maybe you have now some more info. What I have done till now is deactivating the icl_sitepress_settings' autoload but I think I have something more to do. What I don't get is the theme_mods_flatsome-child value. Link to a page where the issue can be seen: hidden link Symptoms: The site has 4042 autoloader options (site: 1,005 KB). Questions: How can I further reduce the autoloader data value related to WPML? What is the theme_mods_flatsome-child value and how does it affect autoloading?
March 19, 2025 at 7:19 am #16833365
Bobby Supporter Languages: English (English ) Timezone: America/Los_Angeles (GMT-07:00)	Hi there, Please try the following steps - Install the next plugin from us and follow steps from next errata: https://wpml.org/errata/reducing-size-of-icl_translate_job-icl_translate-and-other-wpml-tables/ - Plugin hidden link - Go to WPML > Support > Troubleshooting > Clean up and click to run next: - Clear the cache in WPML - Remove ghost entries - Fix element_type collation - Set language information - Fix post type assignment - Clean up strings and optimize Let me know your results, please.
March 19, 2025 at 9:46 am #16834208
thomasD-100	Hi, I can't download the plugin via the link.
March 19, 2025 at 6:24 pm #16836907
Bobby Supporter Languages: English (English ) Timezone: America/Los_Angeles (GMT-07:00)	Apologies for that, please go to https://wpml.org/errata/reducing-size-of-icl_translate_job-icl_translate-and-other-wpml-tables/ and click on "Download this temporary plugin" it should automatically download it. I just tested and it worked ok for me while using the Google Chrome browser
March 20, 2025 at 11:39 am #16839766
thomasD-100	Don't worry at all. Everything worked correctly. What I see now: hidden link wp_installer_setting and theme_mods_flatsoe_child are also WPML related?
March 20, 2025 at 7:48 pm #16841777
Bobby Supporter Languages: English (English ) Timezone: America/Los_Angeles (GMT-07:00)	Glad that it worked! Did you notice a reducation to the autoloaded data compared to what it was before? The wp_installer_setting is a WP field that holds a lot of data based on your installation, it also holds WPML configuration data, if it's removed it will be as if WPML was never configured(won't lose data but you will have to re configure) -- I'd be careful with that one. theme_mods_flatsoe_child -- this one seems related to your theme and the theme options -- most likely the same here i'd be careful with this as well.
March 24, 2025 at 1:14 pm #16852141
thomasD-100	Thanks a lot for your help! The value of the autoloaded data was reduced, so it worked as expected.