Problem: The client is using WPML 4.8 with String Translation on a WordPress Multisite hosted on SiteGround. Several subsites were experiencing 502 errors, large php_errorlog files with repeated entries, and a 'Database is limited' warning. The main multisite database had exceeded 1 GB, causing temporary blocking of INSERT/UPDATE queries. Despite running cleanup and repair tools, the issues persisted. Solution: We recommended following the steps in our optimization guide to address the database issues. The guide includes deleting obsolete strings, optimizing WPML tables, and clearing caches. These steps are detailed in our documentation, which can be accessed here: Optimizing WPML Database Tables. If the problem persists or recurs, we suggested taking a copy of the site and database for further investigation. Additionally, we requested temporary admin and FTP access to perform a more thorough check.
Please note that the solution provided might be outdated or not applicable to your specific 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.
