Problem: The client is experiencing an issue where their website is not detecting the available translation credits despite having sufficient credits. The website continuously prompts for more credits, and clicking the option indicating that credits have been added does not resolve the issue. Solution: If you're experiencing this issue, we recommend you try the following steps to resolve it: 1. Log in to your WPML.org account and navigate to the Sites page. 2. Delete the existing site key. 3. Log in to your site, go to the Dashboard >> Plugins >> Add new > Commercial tab and click the Unregister WPML from this site link if it exists. 4. Click the Register WPML link. 5. Click the Get a key for this site link. This will generate a new key for your site, and you can assign the credits using that popup. 6. Copy the new key, paste it into the input box on your site, and press the Register button. Additionally, to ensure WPML and other plugins operate smoothly and to avoid unexpected errors, add the following line to your wp-config.php file to increase the WP memory limit:
You can confirm the WP memory settings from the WPML >> Support page.
If this solution does not resolve your issue or if it 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.
Problem: If you're using WPML for automatic translations and encounter an issue where it shows a lot of pending reviews, but when you attempt to approve them, you receive a 'no data' message, this might be due to a database collation error. Solution: We found that the issue typically arises from a mismatch in database collations. For instance, while your core WordPress and WPML tables might share the same collation, such as 'utf8mb4_general_ci', individual columns within these tables could differ. This discrepancy can cause SQL errors during operations that involve joining columns with different collations. To fix this, you can adjust the collation of the affected columns to match the default. For example, changing the 'post_title' column in the 'wp_posts' table back to 'utf8mb4_general_ci' should resolve the issue. We recommend using a database management tool like Adminer to make these changes. Always ensure to back up your database before making any modifications.
If this solution does not apply to your case, or if it seems outdated, please check the related known issues and confirm that you have the latest versions of themes and plugins installed. If the problem persists, we highly recommend opening a new support ticket at WPML support forum for further assistance.
