This thread is resolved. Here is a description of the problem and solution.
Problem: You encountered a database error after scanning plugins and themes for new strings, indicating an issue with non UTF encoded characters in your database, specifically an emoji (🚀) in the content. Solution: We recommend two options to resolve this issue: Option 1: Remove the Emoji - Locate the page containing the text "Your website could be much faster if it could take advantage of our new features and enhancements. 🚀". - Delete the emoji from the content. - Resubmit the page for translation.
Option 2: Change Database Collation - Ensure you back up your website first. - Access your website's database via your hosting service panel. - Modify the collation of all database tables to one of the recommended settings, which can be found here: Recommended Collations and Charsets.
If these solutions do not apply to your case, or if they seem outdated, 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.
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.
I got this error after scanning plugins and themes for new strings:
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] => rocket
[gettext_context] =>
[domain_name_context_md5] => 652b82bdb446b890ccc417696fac6fd7
[name] => 636550a9adcd9d23ae191182bcc9676a
[value] => Your website could be much faster if it could take advantage of our %1$snew features and enhancements%2$s. 🚀
[status] => 0
[translation_priority] => optional
[allow_empty_value] =>
)
Welcome to WPML support. According to the error that you shared the problem is an emoji 🚀 in the content.
It seems that you use a non UTF encoding for your website database, that is why it does not allow you to use characters such as 🚀 for translation.
Option 1: Remove the character
- Find the page containing "Your website could be much faster if it could take advantage of ..." text that has the emoji.
- Remove the emoji from the content.
- Send the page for translation again and finish the translation.
Option 2:
Change the collation of your website database. This is an advanced topic and you most probably will need your hosting service provider's help and ask them to do so.
- Backup the website
- Access your website database from the hosting service panel
- Change the collation of all the website database tables according to one of the recommended ones here:
Hello,
My host did what you suggested in Option 2, but the error is still there.
Please, yours is the only plugin I pay for and it's bringing me problem after problem.
Can't you enter my wordpress and fix it yourself?
Thank you,
Milos
Sure I will do my best, I'd appreciate it if you could give me the URL/User/Pass of your WordPress dashboard after you make sure that you have a backup of your website.
It is absolutely important that you give us a guarantee that you have a backup so if something happens you will have a point of restore.
