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.
