[Waiting for user confirmation] Pending reviews not displaying

Thank you for contacting WPML support.

Have you tried setting yourself up as a translator, configuring the language pairs, and then checking if you see the translation queue? Here’s how to do this: https://wpml.org/documentation/support/wpml-admin-capabilities/#add-translator

I need to request temporary access (wp-admin and FTP) to your site—preferably to a test site where the problem has been replicated if possible—in order to be of better help. When you log in to leave your next reply, you will find the needed fields below the comment area. The information you will enter is private, meaning only you and I can see and access it.

We have identified the cause of the issue you experienced. Your site encountered the following error in the debug.log:

WordPress database error: Illegal mix of collations for operation 'UNION' for query

This error indicates that your database tables have different collations. While the core WordPress tables and the WPML tables have the same collation, individual columns within those tables may have different collations. This discrepancy can lead to SQL errors when running queries that join columns with mismatched collations.

For example, the default collation for the `wp_posts` table is `utf8mb4_general_ci`, which is the same collation used for WPML tables. However, some individual columns have different collations.

To resolve this specific issue, I changed the collation of the `post_title` column in the `wp_posts` table back to the default `utf8mb4_general_ci`. I have completed this fix on your staging site using the Adminer plugin and attached the screenshots for your reference.

I also recommend reviewing all your database tables and their columns to ensure that they all have consistent collations.

Please backup your database before making any changes.

To confirm, so to fix this on live the only table i need to change to utf8mb4_general_ci` is `post_title` column in the `wp_posts` table?

Yes, in order to see the translation qeueue.

Also, one more thing, i see here now the posts in the pending review page but some of them are throwing errors when I try to approve (others approved fine)

It seems there may be an issue with this specific item review. Please navigate to WPML → Translation Management, click on the link to review, and complete the translation for this item review. I was able to do this successfully in your staging environment.