Problema: Al intentar activar y configurar WPML en un sitio de prueba, que es una copia del sitio de producción con un gran volumen de publicaciones y adjuntos, se generan consultas SQL intensivas que provocan un uso excesivo de recursos y errores de tiempo de espera (error 524). Solución: Si estás experimentando un consumo excesivo de recursos durante la activación de WPML en entornos con alto contenido, te recomendamos contactar con tu proveedor de hosting para aumentar los recursos del servidor. Además, desactiva todos los plugins y activa un tema por defecto de WordPress durante la instalación para minimizar el consumo de recursos. Si el problema persiste o la solución proporcionada no es relevante porque está desactualizada o no se aplica a tu caso, te sugerimos abrir un nuevo ticket de soporte. También recomendamos revisar los problemas conocidos relacionados, verificar la versión de la solución permanente y confirmar que tienes instaladas las últimas versiones de temas y plugins.
Para asistencia adicional, no dudes en contactar nuestro foro de soporte en WPML support forum.
Problem: If you're experiencing an issue with your database growing too large due to the icl_translate (4.3 GB) and icl_translation_status (3.2 GB) tables, it might be due to how WPML retains data. Solution: We recommend updating to the latest version of WPML where this issue has been addressed. After updating, you can find a new option to clear old translation data under WPML > Support > Troubleshooting. To update WPML, navigate to Plugins > Add new in your WordPress dashboard, click on the "Commercial" tab, and then click "Check for WPML Updates".
Please note that this solution might be irrelevant if it's 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 the issue persists, please open a new support ticket at WPML support forum.
Problem: The client was experiencing performance issues on their site's archive pages, particularly with high load times and frequent errors. The WPML_Element_Translation->maybe_populate_cache() function was being called excessively, resulting in around 1,800 SELECT queries per request, significantly affecting site performance. Solution: We identified that the issue was related to the Adjust ID setting in WPML, which was trying to fetch translated IDs for menu items not set in other languages. To resolve this, we recommended the following steps: 1. Disable the Adjust ID option. 2. Navigate to WPML > String translation > Admin Texts Translation. 3. Locate the default language theme option for the main menu at [theme_mods_motors][nav_menu_locations]primary with ID 207. 4. Add this option for translation and assign the translated menu ID for other languages, such as French ID 253. After applying these changes, the site's load time improved significantly, with pages loading in about 2.5 seconds even with cache disabled. For further details on optimizing SQL queries, you can visit https://wpml.org/faq/how-to-optimize-mysql-queries/.
If this solution does not apply to your case, or if it seems outdated, 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. Should you need further assistance, please do not hesitate to open a new support ticket at WPML support forum.
