periclesR

Problem:
On my WordPress dashboard there's the following message:

We have detected a problem with some tables in the database. Please contact WPML support to get this fixed.

WordPress database error: Could not perform query because it contains invalid data.
Array
(
[language] => en
[context] => gutenberg-8795
[gettext_context] =>
[domain_name_context_md5] => b2e238c1b6e1a38b84edd5d3a077f897
[name] => 79477389dae0d2192f541865f392eb23
[value] => Look at this water 😍
[status] => 0
[translation_priority] => optional
[allow_empty_value] =>
)

Solution:
This may be happening because of the emojis in that text content. Please try the workaround suggested in the following tickets after a full site backup and let us know if it works well for you:

https://wpml.org/forums/topic/detected-a-problem-with-some-tables-in-the-database-p/#post-10535875

https://wpml.org/forums/topic/wordpress-database-error-could-not-perform-query-because-it-contains-invalid-da/#post-10524611

https://wpml.org/forums/topic/invalid-data-in-the-database/#post-10838029