Skip Navigation

Home › Support › English Support › [Closed] problem with some tables in the database

[Closed] problem with some tables in the database

This is the technical support forum for WPML - the multilingual WordPress plugin.

Everyone can read, but only WPML clients can post here. WPML team is replying on the forum 6 days per week, 22 hours per day.

Sun Mon Tue Wed Thu Fri Sat
- 9:00 – 13:00 9:00 – 13:00 9:00 – 13:00 9:00 – 13:00 9:00 – 13:00 -
- 14:00 – 18:00 14:00 – 18:00 14:00 – 18:00 14:00 – 18:00 14:00 – 18:00 -

Supporter timezone: America/Los_Angeles (GMT-08:00)

Tagged: 

This topic contains 3 replies, has 0 voices.

Last updated by Bobby 2 weeks ago.

Assisted by: Bobby.

Author Posts
December 12, 2024 at 6:23 pm #16509170

pedroF-15

Background of the issue:
I am trying to install WPML String Translation Plugin. The issue can be seen at hidden link.

Symptoms:
We have detected a problem with some tables in the database. WordPress database error: Could not perform query because it contains invalid data.

Questions:
Help in removing this issue and the smooth translation process
December 12, 2024 at 6:26 pm #16509220

Bobby
Supporter

Languages: English (English )

Timezone: America/Los_Angeles (GMT-08:00)

Hi there,

These types of warnings can come up when using emojis and many times are resolved on their own

Please 'x' out the notification and refresh the dashboard.

Does the warning re-populate?

Let me know your results, please.

December 13, 2024 at 4:58 am #16509885

pedroF-15

Hi Bobby,

thanks for the reply. Yes, its re-populating even after closing the notice and refreshing the page.

let me know how we can fix this.

thanks in advance
December 13, 2024 at 9:58 pm #16512773

Bobby
Supporter

Languages: English (English )

Timezone: America/Los_Angeles (GMT-08:00)

Thank you for verifying.

The error is triggered by an emoji character that is at the end of this string 'Givers Gain'

Emojis are Unicode characters that require UTF-8 encoding, specifically UTF-8 MB4 (4-byte) support, to be stored in a MySQL database

Please check your database character set and Collation and verify that everything is set up correctly and supports emoji characters.

The topic ‘[Closed] problem with some tables in the database’ is closed to new replies.