Translatepress image errors

Resolved ohmykomu
(@ohmykomu)

1 year, 1 month ago
I keep getting errors like:

last_errorIllegal mix of collations for operation ‘in’disable_automatic_translationsYesurlhttps://komudesigns.com/wp-admin/admin-ajax.phpdetailsError running get_string_rows()last_querySELECT id, original, translated, status, block_type, original_id FROM www_trp_dictionary_sv_se_en_gb WHERE original IN ( ‘https://komudesigns.com/wp-content/uploads/2025/03/0.kd_.Frodiga.blommor.jpg’, ‘https://komudesigns.com/wp-content/uploads/2025/03/0.kd_.Frodiga.blommor.nr_.jpg’, ‘https://komudesigns.com/wp-content/uploads/2025/03/0.kd_.Frodiga.blommor.ec_.jpg’, ‘https://komudesigns.com/wp-content/uploads/2025/02/Frodiga.blommor.orig_.jpg’, ‘https://komudesigns.com/wp-content/uploads/2025/03/0.kd_.Frodiga.blommor.jpg’, ‘https://komudesigns.com/wp-content/uploads/2025/03/0.kd_.Frodiga.blommor.nr_.jpg’, ‘https://komudesigns.com/wp-content/uploads/2025/03/0.kd_.Frodiga.blommor.ec_.jpg’, ‘https://komudesigns.com/wp-content/uploads/2025/02/Frodiga.blommor.orig_.jpg’, ‘https://komudesigns.com/wp-content/uploads/2025/03/0.kd_.Frodiga.blommor.jpg’, ‘https://komudesigns.com/wp-content/uploads/2025/03/0.kd_.Frodiga.blommor.nr_.jpg’, ‘https://komudesigns.com/wp-content/uploads/2025/03/0.kd_.Frodiga.blommor.ec_.jpg’, ‘https://komudesigns.com/wp-content/uploads/2025/02/Frodiga.blommor.orig_.jpg’, ‘https://komudesigns.com/wp-content/uploads/2025/03/0.kd_.Frodiga.blommor.jpg’, ‘https://komudesigns.com/wp-content/uploads/2025/03/0.kd_.Frodiga.blommor.nr_.jpg’, ‘https://komudesigns.com/wp-content/uploads/2025/03/0.kd_.Frodiga.blommor.ec_.jpg’, ‘https://komudesigns.com/wp-content/uploads/2025/02/Frodiga.blommor.orig_.jpg’, ‘https://komudesigns.com/wp-content/uploads/2025/03/0.kd_.Frodiga.blommor-120×120.jpg’, ‘https://komudesigns.com/wp-content/uploads/2025/03/0.kd_.Frodiga.blommor.nr_-120×120.jpg’, ‘https://komudesigns.com/wp-content/uploads/2025/03/0.kd_.Frodiga.blommor.ec_-120×120.jpg’, ‘https://komudesigns.com/wp-content/uploads/2025/02/Frodiga.blommor.orig_-120×120.jpg’, ‘????’, ‘View full-screen image gallery’ )date_time2025-04-11 01:07:47timestamp1744333667

After a hosting change. I’ve made sure that all trp databases have the same collation, see https://snipboard.io/ae1bV7.jpg for example. I’ve done A, B and C on the error page, deleting all the problem lines (did not copy, do not need them translated). But they keep regenerating. Can I manually disable translatepress from trying to work with these? It’s only ever the wp-content/uploads that cause an issue.

I tried putting https://komudesigns.com/wp-content/uploads/ in exclude strings and pages>Exclude Paths From Translation but it doesn’t seem to help. Please advice
- This topic was modified 1 year, 1 month ago by ohmykomu.
The page I need help with: [log in to see the link]

Viewing 3 replies - 1 through 3 (of 3 total)

Plugin Support Anca
(@ancavictoria)

1 year, 1 month ago

Hello,

Please change the collation of your ‘trp_*’ database tables to utf8mb4_general_ci. This adjustment may resolve the problem you’re encountering.

To exclude external links/files/images, you will need to download and activate this plugin on your site: https://translatepress.com/download/1288661/?tmstv=1727704348. Then, in its settings (WordPress ➜ Settings ➜ TranslatePress Cleanup Database), add the desired exclusion (https://komudesigns.com/wp-content/uploads/ ) and click Start Database Cleanup.
For example: “apple” will delete all records of strings found in the database that contain it like “Ana has an apple”. So use with caution.
By using this plugin, these entries will be deleted and will not be re-added to the database.

IMPORTANT: Please make sure to make a database backup before performing this on the live site.

Let me know how this goes.

Kind regards,

Anca

Thread Starter ohmykomu
(@ohmykomu)

1 year ago

Hi, it didn’t help. I am still getting the same errors despite changing the database collation for trp tables to utf8mb4_general_ci, and using the plugin as advised. I have saved changes on the first settings page as well. I am still getting errors like this (for all images when i browse, they all look the same.

last_errorIllegal mix of collations for operation ‘in’
disable_automatic_translationsYes
urlhttps://komudesigns.com/wp-admin/admin-ajax.php
detailsError running get_string_rows()
last_querySELECT id, original, translated, status, block_type, original_id FROM www_trp_dictionary_sv_se_en_gb WHERE original IN ( ‘https://komudesigns.com/wp-content/uploads/2025/03/0.kd-brunblomster.jpg’, ‘https://komudesigns.com/wp-content/uploads/2025/03/0.kd-brunblomster.n.jpg’, ‘https://komudesigns.com/wp-content/uploads/2025/02/brunblomster.orig_.jpg’, ‘https://komudesigns.com/wp-content/uploads/2025/03/0.kd-brunblomster.jpg’, ‘https://komudesigns.com/wp-content/uploads/2025/03/0.kd-brunblomster.n.jpg’, ‘https://komudesigns.com/wp-content/uploads/2025/02/brunblomster.orig_.jpg’, ‘https://komudesigns.com/wp-content/uploads/2025/03/0.kd-brunblomster.jpg’, ‘https://komudesigns.com/wp-content/uploads/2025/03/0.kd-brunblomster.n.jpg’, ‘https://komudesigns.com/wp-content/uploads/2025/02/brunblomster.orig_.jpg’, ‘https://komudesigns.com/wp-content/uploads/2025/03/0.kd-brunblomster.jpg’, ‘https://komudesigns.com/wp-content/uploads/2025/03/0.kd-brunblomster.n.jpg’, ‘https://komudesigns.com/wp-content/uploads/2025/02/brunblomster.orig_.jpg’, ‘https://komudesigns.com/wp-content/uploads/2025/03/0.kd-brunblomster-600×600-120×120.jpg’, ‘https://komudesigns.com/wp-content/uploads/2025/03/0.kd-brunblomster.n-120×120.jpg’, ‘https://komudesigns.com/wp-content/uploads/2025/02/brunblomster.orig_-120×120.jpg’, ‘????’, ‘View full-screen image gallery’ )
date_time2025-04-25 14:22:24
timestamp1745590944

Thread Starter ohmykomu
(@ohmykomu)

1 year ago

can someone please help? Same errors still. Hosting can’t do anything. Uninstalling the plugin and installing it again just reloads the old stuff. I really don’t want to have to delete the database tables and start from scratch again.

Viewing 3 replies - 1 through 3 (of 3 total)

The topic ‘Translatepress image errors’ is closed to new replies.

Tags